org.apache.openjpa.persistence.ArgumentException: "Encountered "cfg" at character 83, but expected: [",", ".", "GROUP", "HAVING", "INNER", "JOIN", "LEFT", "ORDER", "WHERE", <EOF>]." while parsing JPQL "SELECT DISTINCT cf FROM CouponFunction cf LEFT JOIN FETCH cf.couponFunctionGroups cfg WHERE cf.id in :aIdList". See nested stack trace for original parse error.

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

I get org.apache.openjpa.persistence.ArgumentException while running a junit Test

"Encountered "cfg" at character 83, but expected: [",", ".", "GROUP", "HAVING", "INNER", "JOIN", "LEFT", "ORDER", "WHERE", <EOF>]." while parsing JPQL "SELECT DISTINCT cf FROM CouponFunction cf LEFT JOIN FETCH cf.couponFunctionGroups cfg WHERE cf.id in :aIdList". See nested stack trace for original parse error.

JPA/MySQL - Whats wrong with this JPQL query?

"Encountered "SIZE" at character 31, but expected: ["AVG", "COUNT", "KEY", "MAX", "MIN", "SUM", "VALUE", <IDENTIFIER>]." while parsing JPQL "SELECT p FROM Post p ORDER BY SIZE(p.comments) DESC". See nested stack trace for original parse error.

How to convert the below SQL to JPQL?

"Encountered "location" at character 66, but expected: [",", "GROUP", "HAVING", "INNER", "JOIN", "LEFT", "ORDER", "WHERE", <EOF>]." while parsing JPQL "SELECT nameTest FROM PrintRequest nameTest, LEFT JOIN LOCATION location ON nameTest.place

sysdate-15 implementation

"Encountered "-" at character 144, but expected: ["AND", "GROUP", "HAVING", "OR", "ORDER", <EOF>]." while parsing JPQL "select current_date-15 from dual". See nested stack trace for original parse error.

Error on LDAP login

>, <STRING_LITERAL2>, <STRING_LITERAL>, <TIMESTAMP_LITERAL>, <TIME_LITERAL>]." while parsing JPQL "select c from State as c where c.name ILIKE :name AND c.deleted <> :deleted". See nested stack trace for original parse error.

OpenJPA How to use WHERE condition on collection with join fetch?

" Encountered "f" at character 50, but expected [",", ".", "GROUP", "HAVING", "INNER", "JOIN", "LEFT", "ORDER", "WHERE", <EOF>]."

org.apache.openjpa.persistence.ArgumentException: "Encountered "cfg" at character 83, but expected: [",", ".", "GROUP", "HAVING", "INNER", "JOIN", "LEFT", "ORDER", "WHERE", <EOF>]." while parsing JPQL "SELECT DISTINCT cf FROM CouponFunction cf LEFT JOIN FETCH cf.couponFunctionGroups cfg WHERE cf.id in :aIdList". See nested stack trace for original parse error.	at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:51)	at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)	at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)	at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)	at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)	at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)	at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)	at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1037)	at com.ibm.ws.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:74)	at com.ibm.ws.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:34)	at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1016)	at colruyt.couponservicesmwejb.service.dl.CouponFunctionDlService.findByPkIncludingCouponFunctionGroups(CouponFunctionDlService.java:41)	at colruyt.couponservicemwejb.service.dl.CouponFunctionDlServiceTest.findByPkIncludingCouponFunctionGroups(CouponFunctionDlServiceTest.java:98)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)	at java.lang.reflect.Method.invoke(Method.java:619)	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)