Hello,

I'm using Liferay (which is using Spring + Hibernate I guess). And I receive some problems which are related to the NULL IS NULL check.

So Liferay know some issues for DB2 and sybase, but I want to find a solution for maxdb

The solution for DB2 should be to set next properties:
custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL
custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL

and for sybase the solution is :
custom.sql.function.isnull=ISNULL(?, '1')='1'
custom.sql.function.isnotnull=ISNULL(?, '1')='0'

I was looking in the documentation for maxdb, and try already next things:

1)
custom.sql.function.isnull=? IS NULL
custom.sql.function.isnotnull= ? IS NOT NULL
=> not working

2)
custom.sql.function.isnull=value(?, '1') = '1'
custom.sql.function.isnotnull=value(?,'0')!='1'
=> Not working, but I guess this function value is the one I need, only I don't know how to set (especially in the isnotnull property...)


anybody can help me?