public class CustomSQL
extends java.lang.Object
| Modifier and Type | Field and Description |
|---|---|
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 and Description |
|---|
CustomSQL() |
| Modifier and Type | Method and Description |
|---|---|
java.lang.String |
appendCriteria(java.lang.String sql,
java.lang.String criteria) |
java.lang.String |
get(java.lang.String id) |
java.lang.String |
get(java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition) |
java.lang.String |
get(java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition,
java.lang.String tableName) |
protected java.lang.String[] |
getConfigs() |
protected java.lang.String |
insertWildcard(java.lang.String keyword,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
boolean |
isVendorDB2()
Returns
true if Hibernate is connecting to a DB2 database. |
boolean |
isVendorHSQL()
Returns
true if Hibernate is connecting to a Hypersonic
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) |
java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
java.lang.String[] |
keywords(java.lang.String keywords,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
protected void |
read(java.lang.ClassLoader classLoader,
java.lang.String source) |
void |
reloadCustomSQL() |
java.lang.String |
removeGroupBy(java.lang.String sql) |
java.lang.String |
removeOrderBy(java.lang.String sql) |
java.lang.String |
replaceAndOperator(java.lang.String sql,
boolean andOperator) |
java.lang.String |
replaceGroupBy(java.lang.String sql,
java.lang.String groupBy) |
java.lang.String |
replaceIsNull(java.lang.String sql) |
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values) |
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values) |
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) |
public static final java.lang.String DB2_FUNCTION_IS_NOT_NULL
public static final java.lang.String DB2_FUNCTION_IS_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NOT_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NOT_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NOT_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NULL
public CustomSQL()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.String appendCriteria(java.lang.String sql,
java.lang.String criteria)
public java.lang.String get(java.lang.String id)
public java.lang.String get(java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)
public java.lang.String get(java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition,
java.lang.String tableName)
public boolean isVendorDB2()
true if Hibernate is connecting to a DB2 database.true if Hibernate is connecting to a DB2 databasepublic boolean isVendorHSQL()
true if Hibernate is connecting to a Hypersonic
database.true if Hibernate is connecting to a Hypersonic
databasepublic boolean isVendorInformix()
true if Hibernate is connecting to an Informix
database.true if Hibernate is connecting to an Informix
databasepublic boolean isVendorMySQL()
true if Hibernate is connecting to a MySQL database.true if Hibernate is connecting to a MySQL databasepublic boolean isVendorOracle()
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.true if Hibernate is connecting to an Oracle
databasepublic boolean isVendorPostgreSQL()
true if Hibernate is connecting to a PostgreSQL
database.true if Hibernate is connecting to a PostgreSQL
databasepublic boolean isVendorSybase()
true if Hibernate is connecting to a Sybase
database.true if Hibernate is connecting to a Sybase databasepublic java.lang.String[] keywords(java.lang.String keywords)
public java.lang.String[] keywords(java.lang.String keywords,
boolean lowerCase)
public java.lang.String[] keywords(java.lang.String keywords,
boolean lowerCase,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public java.lang.String[] keywords(java.lang.String keywords,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public java.lang.String[] keywords(java.lang.String[] keywordsArray)
public java.lang.String[] keywords(java.lang.String[] keywordsArray,
boolean lowerCase)
public void reloadCustomSQL()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.String removeGroupBy(java.lang.String sql)
public java.lang.String removeOrderBy(java.lang.String sql)
public java.lang.String replaceAndOperator(java.lang.String sql,
boolean andOperator)
public java.lang.String replaceGroupBy(java.lang.String sql,
java.lang.String groupBy)
public java.lang.String replaceIsNull(java.lang.String sql)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values)
public java.lang.String replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator<?> obc)
protected java.lang.String[] getConfigs()
protected java.lang.String insertWildcard(java.lang.String keyword,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
protected void read(java.lang.ClassLoader classLoader,
java.lang.String source)
throws java.lang.Exception
java.lang.Exceptionprotected java.lang.String transform(java.lang.String sql)