Interface JdbcDialect
- 
- All Superinterfaces:
- Serializable
 - All Known Implementing Classes:
- BasicJdbcDialect,- DB2Dialect,- H2Dialect,- MySQLDialect,- OracleDialect,- SQLServerDialect
 
 public interface JdbcDialect extends Serializable Represents a dialect of SQL implemented by a particular RDBMS.
- 
- 
Method SummaryAll Methods Instance Methods Abstract Methods Modifier and Type Method Description Stringescape(String ident)intgetFetchSize()Gives the JDBC driver a hint how many rows should be fetched from the database when more rows are needed.intgetMaxParameterCount()Get max query parameters count.booleanhasMerge()StringinsertQuery(String fullTblName, Collection<String> keyCols, Collection<String> valCols)Construct insert query.StringloadCacheQuery(String fullTblName, Iterable<String> uniqCols)Construct load cache query.StringloadCacheRangeQuery(String fullTblName, Collection<String> keyCols, Iterable<String> uniqCols, boolean appendLowerBound, boolean appendUpperBound)Construct load cache query over specified range.StringloadCacheSelectRangeQuery(String fullTblName, Collection<String> keyCols)Construct query to get ranges bounds.StringloadQuery(String fullTblName, Collection<String> keyCols, Iterable<String> cols, int keyCnt)Construct load query.StringmergeQuery(String fullTblName, Collection<String> keyCols, Collection<String> uniqCols)Construct merge query.StringremoveQuery(String fullTblName, Iterable<String> keyCols)Construct remove query.StringupdateQuery(String fullTblName, Collection<String> keyCols, Iterable<String> valCols)Construct update query.
 
- 
- 
- 
Method Detail- 
escapeString escape(String ident) - Parameters:
- ident- SQL identifier to escape.
- Returns:
- Escaped SQL identifier.
 
 - 
loadCacheSelectRangeQueryString loadCacheSelectRangeQuery(String fullTblName, Collection<String> keyCols) Construct query to get ranges bounds.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns for order.
- Returns:
- Query for select count.
 
 - 
loadCacheRangeQueryString loadCacheRangeQuery(String fullTblName, Collection<String> keyCols, Iterable<String> uniqCols, boolean appendLowerBound, boolean appendUpperBound) Construct load cache query over specified range.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns for order.
- uniqCols- Database unique value columns.
- appendLowerBound- Need add lower bound for range.
- appendUpperBound- Need add upper bound for range.
- Returns:
- Query for select count.
 
 - 
loadCacheQueryString loadCacheQuery(String fullTblName, Iterable<String> uniqCols) Construct load cache query.- Parameters:
- fullTblName- Full table name.
- uniqCols- Database unique value columns.
- Returns:
- Load cache query.
 
 - 
loadQueryString loadQuery(String fullTblName, Collection<String> keyCols, Iterable<String> cols, int keyCnt) Construct load query.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns.
- cols- Selected columns.
- keyCnt- Key count.
- Returns:
- Load query.
 
 - 
insertQueryString insertQuery(String fullTblName, Collection<String> keyCols, Collection<String> valCols) Construct insert query.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns.
- valCols- Database value columns.
- Returns:
- Insert query.
 
 - 
updateQueryString updateQuery(String fullTblName, Collection<String> keyCols, Iterable<String> valCols) Construct update query.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns.
- valCols- Database value columns.
- Returns:
- Update query.
 
 - 
hasMergeboolean hasMerge() - Returns:
- Trueif database support merge operation.
 
 - 
mergeQueryString mergeQuery(String fullTblName, Collection<String> keyCols, Collection<String> uniqCols) Construct merge query.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns.
- uniqCols- Database unique value columns.
- Returns:
- Merge query.
 
 - 
removeQueryString removeQuery(String fullTblName, Iterable<String> keyCols) Construct remove query.- Parameters:
- fullTblName- Full table name.
- keyCols- Database key columns.
- Returns:
- Remove query.
 
 - 
getMaxParameterCountint getMaxParameterCount() Get max query parameters count.- Returns:
- Max query parameters count.
 
 - 
getFetchSizeint getFetchSize() Gives the JDBC driver a hint how many rows should be fetched from the database when more rows are needed. If the value specified is zero, then the hint is ignored. The default value is zero.- Returns:
- The fetch size for result sets.
 
 
- 
 
-