com.scooterframework.orm.sqldataexpress.vendor
Class H2DBAdapter
java.lang.Object
com.scooterframework.orm.sqldataexpress.vendor.DBAdapter
com.scooterframework.orm.sqldataexpress.vendor.H2DBAdapter
public class H2DBAdapter
- extends DBAdapter
H2DBAdapter class applies to H2 database.
Method Summary |
java.lang.String[] |
getCatalogAndSchema(java.lang.String connName)
Returns both catalog and schema of a connection. |
protected java.lang.String |
getH2Schema(java.lang.String connName)
|
java.lang.String |
getOneRowSelectSQL(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
Returns a SQL SELECT query which retrieves only one record from a table. |
java.lang.String |
preparePaginationSql(java.lang.String selectSql,
java.util.Map<java.lang.String,java.lang.Object> inputs,
java.util.Map<java.lang.String,java.lang.String> outputFilters)
Returns a SQL query for pagination. |
Methods inherited from class com.scooterframework.orm.sqldataexpress.vendor.DBAdapter |
canChangeTableNameCase, dotCount, getBlobData, getClobData, getExpandedTableName, getExpandedTableName, getExpandedTableName, getInputStream, getLoginPassword, getLoginUserId, getObjectFromResultSetByType, getObjectFromStatementByType, getOneRowSelectSQL, getRetrieveAllSQL, getRetrieveAllSQL, getTotalCountSQL, getTotalCountSQL, getType, isEmpty, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTableFromTableName, useLoginAsSchema, vendorSpecificSetObject |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
H2DBAdapter
public H2DBAdapter()
getCatalogAndSchema
public java.lang.String[] getCatalogAndSchema(java.lang.String connName)
- Description copied from class:
DBAdapter
- Returns both catalog and schema of a connection.
- Specified by:
getCatalogAndSchema
in class DBAdapter
- Parameters:
connName
- database connection name
- Returns:
- a string array containing catalog and schema
getH2Schema
protected java.lang.String getH2Schema(java.lang.String connName)
getOneRowSelectSQL
public java.lang.String getOneRowSelectSQL(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
- Description copied from class:
DBAdapter
- Returns a SQL SELECT query which retrieves only one record from a table.
This query is used for retrieving meta data of the underlining table.
- Specified by:
getOneRowSelectSQL
in class DBAdapter
- Parameters:
catalog
- catalog nameschema
- schema nametableName
- table name
- Returns:
- a SELECT query string
preparePaginationSql
public java.lang.String preparePaginationSql(java.lang.String selectSql,
java.util.Map<java.lang.String,java.lang.Object> inputs,
java.util.Map<java.lang.String,java.lang.String> outputFilters)
- Description copied from class:
DBAdapter
- Returns a SQL query for pagination. This method converts a generic SQL
query statement to a SQL query for pagination.
- Specified by:
preparePaginationSql
in class DBAdapter
- Parameters:
selectSql
- the original SQL statementinputs
- inputsoutputFilters
- outputFilters
- Returns:
- a SQL query for pagination