[seam-issues] [JBoss JIRA] Closed: (JBSEAM-3297) DB2 error on search with seam-gen restriction

DB2 error on search with seam-gen restriction ---------------------------------------------- Key: JBSEAM-3297 URL: https://jira.jboss.org/jira/browse/JBSEAM-3297 Project: Seam Issue Type: Bug Components: Tools Affects Versions: 2.0.3.CR1 Environment: JBoss 4.2, Seam 2.0.3.CR1, Linux, DB2 Reporter: Valerie Griffin Assignee: Dan Allen Fix For: 2.1.2.CR1 Attachments: EntityList.java.ftl The generated action/TblList.java code contains RESTRICTIONS like: "lower(channel.channelType) like concat(lower(#{channelList.channel.channelType}),'%')" which Hibernate turns into a prepared statement containing: "lower(?)" DB2 doesn't like this. It does not permit use of an undefined type in the lower function. This feature is documented on the hibernate web site. If the nesting order is changed to "lower(concat(" DB2 is happy and the function is still standard. I've changed EntityList.java.ftl to fix this problem.