org.apache.openjpa.persistence.ArgumentException

"Encountered "c . name ILIKE" at character 32, but expected: ["(", "*", "+", "-", ".", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "WHERE", <DATE_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <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.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web310

  • via Google Groups by Mahmut Teker, 6 months ago
    >, <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.
  • via Stack Overflow by Thomas Junk
    , 1 year ago
    ", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "NULLIF", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM
  • via openjpa-users by cjackson, 1 year ago
    ", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "NULLIF", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "THEN", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "VALUE
  • Stack trace

    • org.apache.openjpa.persistence.ArgumentException: "Encountered "c . name ILIKE" at character 32, but expected: ["(", "*", "+", "-", ".", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "WHERE", <DATE_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <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. at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:51)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1038)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1017)[openjpa-bundle-2.2.1.jar:2.2.1] at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_26] at java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_26] at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at $Proxy14.createNamedQuery(Unknown Source)[na:na] at org.apache.openmeetings.data.user.dao.StateDao.getStateByName(StateDao.java:118)[openmeetings-2.1.0-SNAPSHOT.jar:na] at org.apache.openmeetings.data.user.dao.StateDao$$FastClassByCGLIB$$2e65ce72.invoke(<generated>)[com.springsource.net.sf.cglib-2.2.0.jar:na] at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)[com.springsource.net.sf.cglib-2.2.0.jar:na] at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)[org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] at org.apache.openmeetings.data.user.dao.StateDao$$EnhancerByCGLIB$$c7529867.getStateByName(<generated>)[com.springsource.net.sf.cglib-2.2.0.jar:na] at org.apache.openmeetings.ldap.LdapLoginManagement.updateUserFromLdap(LdapLoginManagement.java:800)[openmeetings-2.1.0-SNAPSHOT.jar:na] at org.apache.openmeetings.ldap.LdapLoginManagement.doLdapLogin(LdapLoginManagement.java:579)[openmeetings-2.1.0-SNAPSHOT.jar:na] at org.apache.openmeetings.remote.MainService.loginUser(MainService.java:333)[openmeetings-2.1.0-SNAPSHOT.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.6.0_26] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[na:1.6.0_26] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_26] at java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_26] at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)[red5.jar:na] at org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)[red5.jar:na] at org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)[red5.jar:na] at org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)[red5.jar:na] at org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)[red5.jar:na] at org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)[red5.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na] at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)[mina-core-2.0.4.jar:na] at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na] at org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)[red5.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na] at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)[mina-core-2.0.4.jar:na] at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)[mina-core-2.0.4.jar:na] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)[mina-core-2.0.4.jar:na] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)[mina-core-2.0.4.jar:na] at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)[mina-core-2.0.4.jar:na] at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)[mina-core-2.0.4.jar:na] at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)[mina-core-2.0.4.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[na:1.6.0_26] at java.lang.Thread.run(Thread.java:662)[na:1.6.0_26] Caused by: org.apache.openjpa.persistence.ArgumentException: Encountered "c . name ILIKE" at character 32, but expected: ["(", "*", "+", "-", ".", "/", ":", "<", "<=", "<>", "=", ">", ">=", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "TYPE", "UPDATE", "UPPER", "WHERE", <DATE_LITERAL>, <DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL2>, <STRING_LITERAL>, <TIMESTAMP_LITERAL>, <TIME_LITERAL>]. at org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:13162)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:13036)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1980)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1958)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1807)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1769)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1587)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:2401)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:2388)[openjpa-bundle-2.2.1.jar:2.2.1] at org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:49)[openjpa-bundle-2.2.1.jar:2.2.1] ... 60 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    4 times, 10 months ago