Dear all, let me ask this noob question ;-)

I created a Seam application with seam gen on a AS400/DB2 database. Clicking on 
the list gives me the expected result. But as soon as a add a search criteria I 
get errors and I pinpointed it down to this

......from S65E5B3F.TESTFEBEL.KLALGEMEEN klalgemeen0_ where 
lower(klalgemeen0_.TITEL) like lower(?)||'%' fetch first 25 rows only

17:31:15,301 WARN  [JDBCExceptionReporter] SQL Error: -418, SQLState: 42610
17:31:15,301 ERROR [JDBCExceptionReporter] [SQL0418] Use of || is not legal for 
parameter

Where can I modify code / configuration to get rid of this problem?

Tnx for your time and effort.
Greetz,
Pjotr



View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049985#4049985

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4049985
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to