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

peter@francq.be do-not-reply at jboss.com
Thu May 31 03:10:45 EDT 2007

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.

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

More information about the jboss-user mailing list