[opencms-dev] DB2 SQL statement error

[Jules Van de Velde]

Hi,

 

I have installed OpenCMS 7.5.2 running against DB2 and was having an
issue with "the LIKE in DB2 does not support having a non-constant
expression in the pattern."

 

This is the same issue as described in the bug at
http://bugzilla.opencms.org/show_bug.cgi?id=1666 

 

It seems that this issue was introduced some time after version 7.0.3,
as the bug does not exist against DB2 for this version.

 

Is there any other queries that may have similar issues running against
a DB2 database? Ie, issues with non-constant expressions in the pattern
of the LIKE statement? I have looked at the query.properties file for
the generic db driver but I am not sure if there is somewhere else I
should be checking as well?

 

Thanks in advance,

Jules Van de Velde




--------------------------------------------------------------------------------- 
The contents of this communication, including any attachment(s), are
confidential and may be privileged.  If you are not the intended recipient (or
are not receiving this communication on behalf of the intended recipient),
please notify the sender immediately and delete or destroy this communication
without reading it, and making, forwarding or retaining any copy or record of it
or its contents.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100623/8fadc15e/attachment.htm>