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].

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 538090, 1 year ago
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].
via hivmr.com by Unknown author, 1 year ago
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].
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(EJBQLException.java:350)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.handleANTLRException(EJBQLParserBase.java:230)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.reportError(EJBQLParserBase.java:204)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.variableAccess(EJBQLParser.java:1441)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.pathExpression(EJBQLParser.java:977)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.collectionValuedPathExpression(EJBQLParser.java:1945)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.collectionMemberExpression(EJBQLParser.java:2806)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionWithNotExpression(EJBQLParser.java:2541)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleConditionalExpressionRemainder(EJBQLParser.java:2376)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleConditionalExpression(EJBQLParser.java:2283)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalPrimary(EJBQLParser.java:2218)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalFactor(EJBQLParser.java:2155)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalTerm(EJBQLParser.java:2030)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalExpression(EJBQLParser.java:1989)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.whereClause(EJBQLParser.java:507)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.selectStatement(EJBQLParser.java:184)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.document(EJBQLParser.java:135)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParserBase.parseEJBQLString(EJBQLParserBase.java:313)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:199)
at oracle.toplink.essentials.queryframework.EJBQLPlaceHolderQuery.processEjbQLQuery(EJBQLPlaceHolderQuery.java:96)
at oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2040)
at oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2027)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:679)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:559)
at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:180)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:230)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:78)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:113)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:84)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.