Eclipse Community Forums: EclipseLink » Query error/JPQL Exception

Help

Home

Home » Eclipse Projects » EclipseLink » Query error/JPQL Exception

Show: Today's Messages :: Show Polls :: Message Navigator

Query error/JPQL Exception [message #958800]

Fri, 26 October 2012 08:17

Arnaud Schildknecht

Messages: 1
Registered: October 2012

Junior Member

Hello,

I'm using EclipseLink 2.4.0 on a OC4J 10g server and sometimes when the server reboot automatically this error appears :

Caused by: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [ SELECT o FROM GesdpCompany o join o.gesdpProgramMembers as gpm where o.companyId = :companyID AND gpm.programMemberId='AP'].
[69, 124] The expression is not a valid conditional expression.
[69, 124]  The expression is invalid, which means it does not follow the JPQL grammar.
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildException(HermesParser.java:150)
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.validate(HermesParser.java:325)
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQueryImp(HermesParser.java:270)
        at org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuery(HermesParser.java:157)
        at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:138)
        at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:108)
        at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:92)
        at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:614)
        at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:575)
        at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2244)
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:540)
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:777)
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:722)
        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:213)
        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:542)
        ... 83 more

If I reboot manually the server, it works fine.
Is there any options to resolve this please ?

Note : A few month ago I migrate from TopLink to EclipseLink.

Report message to a moderator