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

Valerie Griffin (JIRA) jira-events at lists.jboss.org
Thu Aug 21 18:57:38 EDT 2008


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


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.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the seam-issues mailing list