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

Dan Allen (JIRA) jira-events at lists.jboss.org
Mon Mar 30 01:17:22 EDT 2009

     [ https://jira.jboss.org/jira/browse/JBSEAM-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dan Allen resolved JBSEAM-3297.

    Fix Version/s: 2.2.0.CR1
       Resolution: Done
         Assignee: Dan Allen

Resolved by reversing order of lower() and concat()

> 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.2.0.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.

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