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)