com.liferay.util.dao.orm
Class CustomSQL

java.lang.Object
  extended by com.liferay.util.dao.orm.CustomSQL

public class CustomSQL
extends java.lang.Object

View Source

Author:
Brian Wing Shun Chan, Bruno Farache

Field Summary
static java.lang.String DB2_FUNCTION_IS_NOT_NULL
           
static java.lang.String DB2_FUNCTION_IS_NULL
           
static java.lang.String INFORMIX_FUNCTION_IS_NOT_NULL
           
static java.lang.String INFORMIX_FUNCTION_IS_NULL
           
static java.lang.String MYSQL_FUNCTION_IS_NOT_NULL
           
static java.lang.String MYSQL_FUNCTION_IS_NULL
           
static java.lang.String SYBASE_FUNCTION_IS_NOT_NULL
           
static java.lang.String SYBASE_FUNCTION_IS_NULL
           
 
Constructor Summary
CustomSQL()
           
 
Method Summary
 java.lang.String get(java.lang.String id)
           
protected  java.lang.String[] getConfigs()
           
 boolean isVendorDB2()
          Returns true if Hibernate is connecting to a DB2 database.
 boolean isVendorInformix()
          Returns true if Hibernate is connecting to an Informix database.
 boolean isVendorMySQL()
          Returns true if Hibernate is connecting to a MySQL database.
 boolean isVendorOracle()
          Returns true if Hibernate is connecting to an Oracle database.
 boolean isVendorPostgreSQL()
          Returns true if Hibernate is connecting to a PostgreSQL database.
 boolean isVendorSybase()
          Returns true if Hibernate is connecting to a Sybase database.
 java.lang.String[] keywords(java.lang.String keywords)
           
 java.lang.String[] keywords(java.lang.String[] keywordsArray)
           
 java.lang.String[] keywords(java.lang.String[] keywordsArray, boolean lowerCase)
           
 java.lang.String[] keywords(java.lang.String keywords, boolean lowerCase)
           
protected  void read(java.lang.ClassLoader classLoader, java.lang.String source)
           
 java.lang.String removeOrderBy(java.lang.String sql)
           
 java.lang.String replaceAndOperator(java.lang.String sql, boolean andOperator)
           
 java.lang.String replaceIsNull(java.lang.String sql)
           
 java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, java.lang.String operator, boolean last, java.lang.String[] values)
           
 java.lang.String replaceOrderBy(java.lang.String sql, com.liferay.portal.kernel.util.OrderByComparator obc)
           
protected  java.lang.String transform(java.lang.String sql)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DB2_FUNCTION_IS_NULL

public static final java.lang.String DB2_FUNCTION_IS_NULL
See Also:
Constant Field Values

DB2_FUNCTION_IS_NOT_NULL

public static final java.lang.String DB2_FUNCTION_IS_NOT_NULL
See Also:
Constant Field Values

INFORMIX_FUNCTION_IS_NULL

public static final java.lang.String INFORMIX_FUNCTION_IS_NULL
See Also:
Constant Field Values

INFORMIX_FUNCTION_IS_NOT_NULL

public static final java.lang.String INFORMIX_FUNCTION_IS_NOT_NULL
See Also:
Constant Field Values

MYSQL_FUNCTION_IS_NULL

public static final java.lang.String MYSQL_FUNCTION_IS_NULL
See Also:
Constant Field Values

MYSQL_FUNCTION_IS_NOT_NULL

public static final java.lang.String MYSQL_FUNCTION_IS_NOT_NULL
See Also:
Constant Field Values

SYBASE_FUNCTION_IS_NULL

public static final java.lang.String SYBASE_FUNCTION_IS_NULL
See Also:
Constant Field Values

SYBASE_FUNCTION_IS_NOT_NULL

public static final java.lang.String SYBASE_FUNCTION_IS_NOT_NULL
See Also:
Constant Field Values
Constructor Detail

CustomSQL

public CustomSQL()
          throws java.sql.SQLException
Throws:
java.sql.SQLException
Method Detail

get

public java.lang.String get(java.lang.String id)

isVendorDB2

public boolean isVendorDB2()
Returns true if Hibernate is connecting to a DB2 database.

Returns:
true if Hibernate is connecting to a DB2 database

isVendorInformix

public boolean isVendorInformix()
Returns true if Hibernate is connecting to an Informix database.

Returns:
true if Hibernate is connecting to an Informix database

isVendorMySQL

public boolean isVendorMySQL()
Returns true if Hibernate is connecting to a MySQL database.

Returns:
true if Hibernate is connecting to a MySQL database

isVendorOracle

public boolean isVendorOracle()
Returns true if Hibernate is connecting to an Oracle database. Oracle has a nasty bug where it treats '' as a NULL 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()
Returns true if Hibernate is connecting to a PostgreSQL database.

Returns:
true if Hibernate is connecting to a PostgreSQL database

isVendorSybase

public boolean isVendorSybase()
Returns true if Hibernate is connecting to a Sybase database.

Returns:
true if Hibernate is connecting to a Sybase database

keywords

public java.lang.String[] keywords(java.lang.String keywords)

keywords

public java.lang.String[] keywords(java.lang.String keywords,
                                   boolean lowerCase)

keywords

public java.lang.String[] keywords(java.lang.String[] keywordsArray)

keywords

public java.lang.String[] keywords(java.lang.String[] keywordsArray,
                                   boolean lowerCase)

replaceAndOperator

public java.lang.String replaceAndOperator(java.lang.String sql,
                                           boolean andOperator)

replaceIsNull

public java.lang.String replaceIsNull(java.lang.String sql)

replaceKeywords

public java.lang.String replaceKeywords(java.lang.String sql,
                                        java.lang.String field,
                                        java.lang.String operator,
                                        boolean last,
                                        java.lang.String[] values)

removeOrderBy

public java.lang.String removeOrderBy(java.lang.String sql)

replaceOrderBy

public java.lang.String replaceOrderBy(java.lang.String sql,
                                       com.liferay.portal.kernel.util.OrderByComparator obc)

getConfigs

protected java.lang.String[] getConfigs()

read

protected void read(java.lang.ClassLoader classLoader,
                    java.lang.String source)
             throws java.lang.Exception
Throws:
java.lang.Exception

transform

protected java.lang.String transform(java.lang.String sql)