[jboss-user] [JBoss Seam] - Problem with SQL generation

[peter@francq.be]

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