Package com.liferay.util.dao.orm
Class CustomSQL
Object
com.liferay.util.dao.orm.CustomSQL
- Author:
- Brian Wing Shun Chan, Bruno Farache, Raymond Augé
- See Also:
-
com.liferay.portal.dao.orm.custom.sql.CustomSQL
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionappendCriteria
(String sql, String criteria) get
(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition, String tableName) protected String[]
protected String
insertWildcard
(String keyword, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) boolean
Returnstrue
if Hibernate is connecting to a DB2 database.boolean
Returnstrue
if Hibernate is connecting to a Hypersonic database.boolean
Returnstrue
if Hibernate is connecting to an Informix database.boolean
Returnstrue
if Hibernate is connecting to a MySQL database.boolean
Returnstrue
if Hibernate is connecting to an Oracle database.boolean
Returnstrue
if Hibernate is connecting to a PostgreSQL database.String[]
String[]
String[]
String[]
String[]
keywords
(String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) String[]
void
removeGroupBy
(String sql) removeOrderBy
(String sql) replaceAndOperator
(String sql, boolean andOperator) replaceGroupBy
(String sql, String groupBy) replaceIsNull
(String sql) replaceKeywords
(String sql, String field, boolean last, int[] values) replaceKeywords
(String sql, String field, boolean last, long[] values) replaceKeywords
(String sql, String field, String operator, boolean last, String[] values) replaceOrderBy
(String sql, com.liferay.portal.kernel.util.OrderByComparator<?> orderByComparator) protected String
-
Field Details
-
DB2_FUNCTION_IS_NOT_NULL
- See Also:
-
DB2_FUNCTION_IS_NULL
- See Also:
-
INFORMIX_FUNCTION_IS_NOT_NULL
- See Also:
-
INFORMIX_FUNCTION_IS_NULL
- See Also:
-
MYSQL_FUNCTION_IS_NOT_NULL
- See Also:
-
MYSQL_FUNCTION_IS_NULL
- See Also:
-
-
Constructor Details
-
CustomSQL
- Throws:
SQLException
-
-
Method Details
-
appendCriteria
-
get
-
get
-
get
-
isVendorDB2
public boolean isVendorDB2()Returnstrue
if Hibernate is connecting to a DB2 database.- Returns:
true
if Hibernate is connecting to a DB2 database
-
isVendorHSQL
public boolean isVendorHSQL()Returnstrue
if Hibernate is connecting to a Hypersonic database.- Returns:
true
if Hibernate is connecting to a Hypersonic database
-
isVendorInformix
public boolean isVendorInformix()Returnstrue
if Hibernate is connecting to an Informix database.- Returns:
true
if Hibernate is connecting to an Informix database
-
isVendorMySQL
public boolean isVendorMySQL()Returnstrue
if Hibernate is connecting to a MySQL database.- Returns:
true
if Hibernate is connecting to a MySQL database
-
isVendorOracle
public boolean isVendorOracle()Returnstrue
if Hibernate is connecting to an Oracle database. Oracle has a nasty bug where it treats '' as aNULL
value. See http://thedailywtf.com/forums/thread/26879.aspx for more information on this nasty bug.- Returns:
true
if Hibernate is connecting to an Oracle database
-
isVendorPostgreSQL
public boolean isVendorPostgreSQL()Returnstrue
if Hibernate is connecting to a PostgreSQL database.- Returns:
true
if Hibernate is connecting to a PostgreSQL database
-
keywords
-
keywords
-
keywords
-
keywords
-
keywords
-
keywords
-
reloadCustomSQL
- Throws:
SQLException
-
removeGroupBy
-
removeOrderBy
-
replaceAndOperator
-
replaceGroupBy
-
replaceIsNull
-
replaceKeywords
-
replaceKeywords
-
replaceKeywords
-
replaceOrderBy
-
getConfigs
-
insertWildcard
-
transform
-