nl.nn.adapterframework.jdbc.dbms

Class H2DbmsSupport

java.lang.Object

nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

nl.nn.adapterframework.jdbc.dbms.H2DbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class H2DbmsSupport
extends GenericDbmsSupport

Support for H2.

Author:

Jaco de Groot

Field Summary

Fields inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

KEYWORD_SELECT, log, sqlTranslators, TYPE_BLOB, TYPE_CLOB, TYPE_FUNCTION

Constructor Summary

Constructors

Constructor and Description
H2DbmsSupport()

Method Summary

Modifier and Type	Method and Description
Object	getBlobHandle(ResultSet rs, int column)
Object	getBlobHandle(ResultSet rs, String column)
Object	getClobHandle(ResultSet rs, int column)
Object	getClobHandle(ResultSet rs, String column)
String	getDatetimeLiteral(Date date)
Dbms	getDbms() Numeric value defining database type, defined in DbmsSupportFactory.
String	getSchema(Connection conn)
ResultSet	getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern)
String	getTimestampAsDate(String columnName)
boolean	hasIndexOnColumn(Connection conn, String schemaName, String tableName, String columnName)
boolean	hasIndexOnColumns(Connection conn, String schemaOwner, String tableName, List<String> columns)
boolean	isColumnPresent(Connection conn, String schemaName, String tableName, String columnName)
boolean	isTablePresent(Connection conn, String schemaName, String tableName)

Methods inherited from class nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

applyBlobParameter, applyClobParameter, autoIncrementInsertValue, autoIncrementKeyMustBeInserted, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, emptyBlobValue, emptyClobValue, getAutoIncrementKeyFieldType, getBlobFieldType, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBooleanFieldType, getBooleanValue, getCleanUpIbisstoreQuery, getClobFieldType, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getClobWriter, getDateAndOffset, getDbmsName, getFirstRecordQuery, getFromForTablelessSelect, getIbisStoreSummaryQuery, getInsertedAutoIncrementValueQuery, getLength, getNumericKeyFieldType, getRowNumber, getRowNumberShortName, getSchemaOwner, getSysDate, getTableColumns, getTableColumns, getTextFieldType, getTimestampFieldType, getUpdateBlobQuery, getUpdateClobQuery, hasSkipLockedFunctionality, isBlobType, isClobType, isColumnPresent, isConstraintViolation, isIndexPresent, isParameterTypeMatchRequired, isQueryConversionRequired, isSequencePresent, isTablePresent, mustInsertEmptyBlobBeforeData, mustInsertEmptyClobBeforeData, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, prepareQueryTextForWorkQueueReading, prepareSessionForNonLockingRead, provideFirstRowsHintAfterFirstKeyword, provideIndexHintAfterFirstKeyword, provideTrailingFirstRowsHint, splitQuery, updateBlob, updateBlob, updateClob, updateClob, warnConvertQuery

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

H2DbmsSupport

public H2DbmsSupport()

Method Detail

getDbms

public Dbms getDbms()

Description copied from interface: IDbmsSupport

Numeric value defining database type, defined in DbmsSupportFactory.

Specified by:

getDbms in interface IDbmsSupport

Overrides:

getDbms in class GenericDbmsSupport

getSchema

public String getSchema(Connection conn)
                 throws JdbcException

Specified by:

getSchema in interface IDbmsSupport

Overrides:

getSchema in class GenericDbmsSupport

Throws:

JdbcException

getDatetimeLiteral

public String getDatetimeLiteral(Date date)

Specified by:

getDatetimeLiteral in interface IDbmsSupport

Overrides:

getDatetimeLiteral in class GenericDbmsSupport

getTimestampAsDate

public String getTimestampAsDate(String columnName)

Specified by:

getTimestampAsDate in interface IDbmsSupport

Overrides:

getTimestampAsDate in class GenericDbmsSupport

getClobHandle

public Object getClobHandle(ResultSet rs,
                            int column)
                     throws SQLException,
                            JdbcException

Specified by:

getClobHandle in interface IDbmsSupport

Overrides:

getClobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getClobHandle

public Object getClobHandle(ResultSet rs,
                            String column)
                     throws SQLException,
                            JdbcException

Specified by:

getClobHandle in interface IDbmsSupport

Overrides:

getClobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getBlobHandle

public Object getBlobHandle(ResultSet rs,
                            int column)
                     throws SQLException,
                            JdbcException

Specified by:

getBlobHandle in interface IDbmsSupport

Overrides:

getBlobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getBlobHandle

public Object getBlobHandle(ResultSet rs,
                            String column)
                     throws SQLException,
                            JdbcException

Specified by:

getBlobHandle in interface IDbmsSupport

Overrides:

getBlobHandle in class GenericDbmsSupport

Throws:

SQLException

JdbcException

getTableColumns

public ResultSet getTableColumns(Connection conn,
                                 String schemaName,
                                 String tableName,
                                 String columnNamePattern)
                          throws JdbcException

Specified by:

getTableColumns in interface IDbmsSupport

Overrides:

getTableColumns in class GenericDbmsSupport

Throws:

JdbcException

isTablePresent

public boolean isTablePresent(Connection conn,
                              String schemaName,
                              String tableName)
                       throws JdbcException

Specified by:

isTablePresent in interface IDbmsSupport

Overrides:

isTablePresent in class GenericDbmsSupport

Throws:

JdbcException

isColumnPresent

public boolean isColumnPresent(Connection conn,
                               String schemaName,
                               String tableName,
                               String columnName)
                        throws JdbcException

Specified by:

isColumnPresent in interface IDbmsSupport

Overrides:

isColumnPresent in class GenericDbmsSupport

Throws:

JdbcException

hasIndexOnColumn

public boolean hasIndexOnColumn(Connection conn,
                                String schemaName,
                                String tableName,
                                String columnName)
                         throws JdbcException

Specified by:

hasIndexOnColumn in interface IDbmsSupport

Overrides:

hasIndexOnColumn in class GenericDbmsSupport

Throws:

JdbcException

hasIndexOnColumns

public boolean hasIndexOnColumns(Connection conn,
                                 String schemaOwner,
                                 String tableName,
                                 List<String> columns)

Specified by:

hasIndexOnColumns in interface IDbmsSupport

Overrides:

hasIndexOnColumns in class GenericDbmsSupport