javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids]. Local Exception Stack: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids].

hivmr.com | 4 months ago
  1. 0

    db:: 2.93::Join Fetch doesn't work for empty sets? ca

    hivmr.com | 4 months ago
    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids]. Local Exception Stack: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids].
  2. 0

    What is wrong about this query?

    Oracle Community | 1 decade ago | 538090
    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids]. Local Exception Stack: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids].
  3. 0

    Help!!! Problems with client demarcation transactions

    Oracle Community | 8 years ago | viniciusjssouza
    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/17/2008))): oracle.toplink.essentials.exceptions.DatabaseException > Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.IllegalStateException: cannot add non-XA Resource to global JTS transaction. > Error Code: 0 > Local Exception Stack: > Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/17/2008))): oracle.toplink.essentials.exceptions.DatabaseException > Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.IllegalStateException: cannot add non-XA Resource to global JTS transaction. > Error Code: 0 >
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Help!!! Problems with client demarcation transactions

    Oracle Community | 8 years ago | viniciusjssouza
    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/17/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.IllegalStateException: cannot add non-XA Resource to global JTS transaction. Error Code: 0
  6. 0

    Help!!! Problems with client demarcation transactions

    Oracle Community | 8 years ago | viniciusjssouza
    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/17/2008))): oracle.toplink.essentials.exceptions.DatabaseException > Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: java.lang.IllegalStateException: cannot add non-XA Resource to global JTS transaction. > Error Code: 0 >

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. javax.ejb.TransactionRolledbackLocalException

      Exception thrown from bean; nested exception is: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids]. Local Exception Stack: Exception [TOPLINK-8024] (Oracle TopLink Essentials - 2006.8 (Build 060908)): oracle.toplink.essentials.exceptions.EJBQLException Exception Description: Syntax error parsing the query [SELECT a FROM Shipaction a JOIN FETCH a.ship LEFT JOIN FETCH a.destPort LEFT JOIN FETCH a.currentPort LEFT JOIN FETCH a.anchorage LEFT JOIN FETCH a.berth WHERE a.shipactionId MEMBER OF :ids] at [:ids].

      at oracle.toplink.essentials.exceptions.EJBQLException.syntaxErrorAt()
    2. oracle.toplink.essentials
      EntityManagerFactoryImpl.createEntityManager
      1. oracle.toplink.essentials.exceptions.EJBQLException.syntaxErrorAt(EJBQLException.java:350)
      2. oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.handleANTLRException(EJBQLParserBase.java:230)
      3. oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.reportError(EJBQLParserBase.java:204)
      4. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.variableAccess(EJBQLParser.java:1441)
      5. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.pathExpression(EJBQLParser.java:977)
      6. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.collectionValuedPathExpression(EJBQLParser.java:1945)
      7. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.collectionMemberExpression(EJBQLParser.java:2806)
      8. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionWithNotExpression(EJBQLParser.java:2541)
      9. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleConditionalExpressionRemainder(EJBQLParser.java:2376)
      10. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleConditionalExpression(EJBQLParser.java:2283)
      11. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalPrimary(EJBQLParser.java:2218)
      12. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalFactor(EJBQLParser.java:2155)
      13. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalTerm(EJBQLParser.java:2030)
      14. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalExpression(EJBQLParser.java:1989)
      15. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.whereClause(EJBQLParser.java:507)
      16. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.selectStatement(EJBQLParser.java:184)
      17. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.document(EJBQLParser.java:135)
      18. oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.parseEJBQLString(EJBQLParserBase.java:313)
      19. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:199)
      20. oracle.toplink.essentials.queryframework.EJBQLPlaceHolderQuery.processEjbQLQuery(EJBQLPlaceHolderQuery.java:96)
      21. oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2040)
      22. oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2027)
      23. oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:679)
      24. oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:559)
      25. oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:180)
      26. oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:230)
      27. oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
      28. oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
      29. oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:84)
      29 frames
    3. Common Utilities
      EntityManagerWrapper._getDelegate
      1. com.sun.enterprise.util.EntityManagerWrapper._getDelegate(EntityManagerWrapper.java:168)
      1 frame