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)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839542#3839542
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839542
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
