2 Replies Latest reply on Jun 23, 2004 4:02 AM by Alexey Loubyansky

    EJBQL parsing failure in 3.2.4 - worked in 3.2.3

    rcsnti Newbie

      Hi,

      The following EJB-QL is being passed through to an ejbSelectGeneric() method:

      select object(c) from Cust AS c, CustData AS cd where c.cust
      Guid <> ?1 and c.custGuid = cd.custGuid and cd.parameterGroup='HOME' and ((cd.parameter = 'PHONE' and cd.value = ?2) or ((cd.parameter = 'LAST_NAME' and ucase(cd.value) like ?3) a
      nd ((cd.parameter = 'CITY' and ucase(cd.value) like ?4) or (cd.parameter = 'POSTAL_CODE' and ucase(cd.value) like ?5)) and (cd.parameter = 'COUNTRY' and cd.value = ?6))
      or (cd.parameter = 'EMAIL' and ucase(cd.value) like ?7))


      This is now returning the following error in jboss 3.2.4, where this worked fine in 3.2.3. Can anyone tell me what's wrong here??


      org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "where" at line 1, column 57.
      Was expecting one of:
      EOF
      "," ...

      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.JBossQLParser.generateParseException(JBossQLParser.java:5604)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.JBossQLParser.jj_consume_token(JBossQLParser.java:5485)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.JBossQLParser.ParseFromClause(JBossQLParser.java:348)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.JBossQLParser.parse(JBossQLParser.java:69)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileJBossQL(JDBCEJBQLCompiler.java:193)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:90)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:96)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.invoke(JDBCSelectorBridge.java:69)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:91)
      2004-06-22 12:57:17,968 INFO [STDOUT] at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:62)