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.

Google Groups | Mahmut Teker | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error on LDAP login

    Google Groups | 4 years ago | Mahmut Teker
    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.
  2. 0

    JPA/MySQL - Whats wrong with this JPQL query?

    Stack Overflow | 3 years ago | Wlad
    org.apache.openjpa.persistence.ArgumentException: "Encountered "SIZE" at character 31, but expected: ["AVG", "COUNT", "KEY", "MAX", "MIN", "SUM", "VALUE", &lt;IDENTIFIER&gt;]." while parsing JPQL "SELECT p FROM Post p ORDER BY SIZE(p.comments) DESC". See nested stack trace for original parse error.
  3. 0

    OpenJPA Exception "The type(*) has not been enhanced

    Stack Overflow | 3 years ago | user1712638
    org.apache.openjpa.persistence.ArgumentException: The type "class model.Session" has not been enhanced.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    query with OneToMany - openJPA vs EclipseLink

    Stack Overflow | 2 years ago
    org.apache.openjpa.persistence.ArgumentException: Query projections cannot include array, collection, or map fields. Invalid query: "SELECT m.valMessages FROM ThreePhaseMotorInput m WHERE m.id = :id"
  6. 0

    openjpa

    solveseek.com | 2 years ago
    org.apache.openjpa.persistence.ArgumentException: The type "class model.Session" has not been enhanced.

    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. 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()
    2. OpenJPA Aggregate Jar
      EntityManagerImpl.createNamedQuery
      1. org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:13162)[openjpa-bundle-2.2.1.jar:2.2.1]
      2. org.apache.openjpa.kernel.jpql.JPQL.jj_consume_token(JPQL.java:13036)[openjpa-bundle-2.2.1.jar:2.2.1]
      3. org.apache.openjpa.kernel.jpql.JPQL.conditional_primary(JPQL.java:1980)[openjpa-bundle-2.2.1.jar:2.2.1]
      4. org.apache.openjpa.kernel.jpql.JPQL.conditional_factor(JPQL.java:1958)[openjpa-bundle-2.2.1.jar:2.2.1]
      5. org.apache.openjpa.kernel.jpql.JPQL.conditional_term(JPQL.java:1807)[openjpa-bundle-2.2.1.jar:2.2.1]
      6. org.apache.openjpa.kernel.jpql.JPQL.conditional_expression(JPQL.java:1769)[openjpa-bundle-2.2.1.jar:2.2.1]
      7. org.apache.openjpa.kernel.jpql.JPQL.where_clause(JPQL.java:1587)[openjpa-bundle-2.2.1.jar:2.2.1]
      8. org.apache.openjpa.kernel.jpql.JPQL.select_statement(JPQL.java:91)[openjpa-bundle-2.2.1.jar:2.2.1]
      9. org.apache.openjpa.kernel.jpql.JPQL.parseQuery(JPQL.java:63)[openjpa-bundle-2.2.1.jar:2.2.1]
      10. org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:2401)[openjpa-bundle-2.2.1.jar:2.2.1]
      11. org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.<init>(JPQLExpressionBuilder.java:2388)[openjpa-bundle-2.2.1.jar:2.2.1]
      12. org.apache.openjpa.kernel.jpql.JPQLParser.parse(JPQLParser.java:49)[openjpa-bundle-2.2.1.jar:2.2.1]
      13. org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)[openjpa-bundle-2.2.1.jar:2.2.1]
      14. org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)[openjpa-bundle-2.2.1.jar:2.2.1]
      15. org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)[openjpa-bundle-2.2.1.jar:2.2.1]
      16. org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)[openjpa-bundle-2.2.1.jar:2.2.1]
      17. org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)[openjpa-bundle-2.2.1.jar:2.2.1]
      18. org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)[openjpa-bundle-2.2.1.jar:2.2.1]
      19. org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1038)[openjpa-bundle-2.2.1.jar:2.2.1]
      20. org.apache.openjpa.persistence.EntityManagerImpl.createNamedQuery(EntityManagerImpl.java:1017)[openjpa-bundle-2.2.1.jar:2.2.1]
      20 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)[na:na]
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_26]
      3. java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_26]
      3 frames
    4. Spring ORM
      SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke
      1. org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)[org.springframework.orm-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      1 frame
    5. Unknown
      $Proxy14.createNamedQuery
      1. $Proxy14.createNamedQuery(Unknown Source)[na:na]
      1 frame
    6. org.apache.openmeetings
      StateDao$$FastClassByCGLIB$$2e65ce72.invoke
      1. org.apache.openmeetings.data.user.dao.StateDao.getStateByName(StateDao.java:118)[openmeetings-2.1.0-SNAPSHOT.jar:na]
      2. org.apache.openmeetings.data.user.dao.StateDao$$FastClassByCGLIB$$2e65ce72.invoke(<generated>)[com.springsource.net.sf.cglib-2.2.0.jar:na]
      2 frames
    7. IDEA
      MethodProxy.invoke
      1. net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)[com.springsource.net.sf.cglib-2.2.0.jar:na]
      1 frame
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      2 frames
    9. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)[org.springframework.transaction-jar-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      1 frame
    10. Spring AOP
      Cglib2AopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      2. org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)[spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE]
      2 frames
    11. org.apache.openmeetings
      MainService.loginUser
      1. org.apache.openmeetings.data.user.dao.StateDao$$EnhancerByCGLIB$$c7529867.getStateByName(<generated>)[com.springsource.net.sf.cglib-2.2.0.jar:na]
      2. org.apache.openmeetings.ldap.LdapLoginManagement.updateUserFromLdap(LdapLoginManagement.java:800)[openmeetings-2.1.0-SNAPSHOT.jar:na]
      3. org.apache.openmeetings.ldap.LdapLoginManagement.doLdapLogin(LdapLoginManagement.java:579)[openmeetings-2.1.0-SNAPSHOT.jar:na]
      4. org.apache.openmeetings.remote.MainService.loginUser(MainService.java:333)[openmeetings-2.1.0-SNAPSHOT.jar:na]
      4 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.6.0_26]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[na:1.6.0_26]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_26]
      4. java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_26]
      4 frames
    13. Red5
      RTMPMinaIoHandler.messageReceived
      1. org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:196)[red5.jar:na]
      2. org.red5.server.service.ServiceInvoker.invoke(ServiceInvoker.java:115)[red5.jar:na]
      3. org.red5.server.net.rtmp.RTMPHandler.invokeCall(RTMPHandler.java:157)[red5.jar:na]
      4. org.red5.server.net.rtmp.RTMPHandler.onInvoke(RTMPHandler.java:399)[red5.jar:na]
      5. org.red5.server.net.rtmp.BaseRTMPHandler.messageReceived(BaseRTMPHandler.java:130)[red5.jar:na]
      6. org.red5.server.net.rtmp.RTMPMinaIoHandler.messageReceived(RTMPMinaIoHandler.java:164)[red5.jar:na]
      6 frames
    14. Apache MINA Core
      DefaultIoFilterChain$EntryImpl$1.messageReceived
      1. org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)[mina-core-2.0.4.jar:na]
      2. org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na]
      3. org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na]
      4. org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na]
      5. org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)[mina-core-2.0.4.jar:na]
      6. org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)[mina-core-2.0.4.jar:na]
      7. org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na]
      8. org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na]
      9. org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na]
      9 frames
    15. Red5
      RTMPEIoFilter.messageReceived
      1. org.red5.server.net.rtmpe.RTMPEIoFilter.messageReceived(RTMPEIoFilter.java:124)[red5.jar:na]
      1 frame
    16. Apache MINA Core
      AbstractPollingIoProcessor$Processor.run
      1. org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na]
      2. org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)[mina-core-2.0.4.jar:na]
      3. org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)[mina-core-2.0.4.jar:na]
      4. org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)[mina-core-2.0.4.jar:na]
      5. org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)[mina-core-2.0.4.jar:na]
      6. org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)[mina-core-2.0.4.jar:na]
      7. org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:715)[mina-core-2.0.4.jar:na]
      8. org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:668)[mina-core-2.0.4.jar:na]
      9. org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:657)[mina-core-2.0.4.jar:na]
      10. org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:68)[mina-core-2.0.4.jar:na]
      11. org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1141)[mina-core-2.0.4.jar:na]
      11 frames
    17. MINA
      NamePreservingRunnable.run
      1. org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)[mina-core-2.0.4.jar:na]
      1 frame
    18. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[na:1.6.0_26]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[na:1.6.0_26]
      3. java.lang.Thread.run(Thread.java:662)[na:1.6.0_26]
      3 frames