Custom SQL

Input a list of comma delimited custom SQL configurations. Liferay Administrators should never need to customize this; this is more of an option for developers who are customizing Liferay's behavior.

custom.sql.configs=custom-sql/default.xml

Some databases do not recognize a NULL IS NULL check. Set the custom.sql.function.isnull and custom.sql.function.isnotnull properties for your specific database.

There is no need to manually set these properties because com.liferay.portal.spring.PortalHibernateConfiguration already sets it. These properties are available, however, so that you can see how you can override it for a database that PortalHibernateConfiguration does not yet know how to auto configure.

DB2

custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL
custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL

MySQL (for testing only)

custom.sql.function.isnull=IFNULL(?, '1') = '1'
custom.sql.function.isnotnull=IFNULL(?, '1') = '0'

Sybase

custom.sql.function.isnull=CONVERT(VARCHAR,?) IS NULL
custom.sql.function.isnotnull=CONVERT(VARCHAR,?) IS NOT NULL

Database

Specify any database vendor specific settings.