Class H2DbmsSupport

java.lang.Object

org.frankframework.dbms.GenericDbmsSupport

org.frankframework.dbms.H2DbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class H2DbmsSupport
extends GenericDbmsSupport

Support for H2.

Author:

Jaco de Groot

Field Summary

Fields inherited from class GenericDbmsSupport

KEYWORD_SELECT, log, sqlTranslators

Constructor Summary

Constructors

Constructor	Description
H2DbmsSupport()
H2DbmsSupport(@Nullable String productVersion, @Nullable Connection connection)

Method Summary

Modifier and Type	Method	Description
@NonNull Object	getBlobHandle(@NonNull ResultSet rs, int column)
@NonNull Object	getClobHandle(@NonNull ResultSet rs, int column)
String	getDatetimeLiteral(Date date)
Dbms	getDbms()
String	getSchema(Connection conn)
ResultSet	getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern)
String	getTargetSqlDialect()
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	hasSkipLockedFunctionality()
boolean	isColumnPresent(Connection conn, String schemaName, String tableName, String columnName)
boolean	isParameterTypeMatchSupported()	When applying query parameters in String to JDBC prepared statements, some databases can convert from string to the correct type server-side without explicit casting.
boolean	isTablePresent(Connection conn, String schemaName, String tableName)
String	prepareQueryTextForWorkQueuePeeking(int batchSize, String selectQuery, int wait)
String	prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait)

Methods inherited from class GenericDbmsSupport

applyBlobParameter, applyClobParameter, autoIncrementInsertValue, autoIncrementKeyMustBeInserted, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, getAutoIncrementKeyFieldType, getBlobFieldType, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getDateAndOffset, getFormattedDate, getFromForTablelessSelect, getSqlTranslator, getSysDate, getTableColumns, getTableColumns, getTimestampFieldType, isBlobType, isClobType, isColumnPresent, isConstraintViolation, isQueryConversionRequired, isSequencePresent, isTablePresent, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, provideFirstRowsHintAfterFirstKeyword, provideIndexHintAfterFirstKeyword, provideTrailingFirstRowsHint, splitQuery, updateBlob, updateBlob, updateClob, updateClob, warnConvertQuery

Methods inherited from class Object

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

Methods inherited from interface IDbmsSupport

canFetchStatementParameterMetaData, getBooleanValue, getCursorSqlType, getDbmsName, getLength, getTextFieldType, isRowVersionTimestamp, isStoredProcedureResultSetSupported

Constructor Details

H2DbmsSupport

public H2DbmsSupport()

H2DbmsSupport

public H2DbmsSupport(@Nullable String productVersion,
 @Nullable Connection connection)

Method Details

getTargetSqlDialect

public String getTargetSqlDialect()

isParameterTypeMatchSupported

public boolean isParameterTypeMatchSupported()

Description copied from interface: IDbmsSupport

When applying query parameters in String to JDBC prepared statements, some databases can convert from string to the correct type server-side without explicit casting.
Some databases require the correct types to be used when setting the value in the PreparedStatement, however our generic code can only get that information from the ParameterMetaData.
This method indicates if the database supports retrieving the column-type information that is needed for the parameter type matching from the ParameterMetaData, before the query has been executed.

Returns:

true for PostgreSQL, H2 and MS SQL Server. false for Oracle, MySQL and MariaDB.

getDbms

public Dbms getDbms()

Specified by:

getDbms in interface IDbmsSupport

Overrides:

getDbms in class GenericDbmsSupport

hasSkipLockedFunctionality

public boolean hasSkipLockedFunctionality()

Specified by:

hasSkipLockedFunctionality in interface IDbmsSupport

Overrides:

hasSkipLockedFunctionality in class GenericDbmsSupport

prepareQueryTextForWorkQueueReading

public String prepareQueryTextForWorkQueueReading(int batchSize,
 String selectQuery,
 int wait)
                                           throws DbmsException

Specified by:

prepareQueryTextForWorkQueueReading in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueueReading in class GenericDbmsSupport

Throws:

DbmsException

prepareQueryTextForWorkQueuePeeking

public String prepareQueryTextForWorkQueuePeeking(int batchSize,
 String selectQuery,
 int wait)

Specified by:

prepareQueryTextForWorkQueuePeeking in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueuePeeking in class GenericDbmsSupport

getSchema

public String getSchema(Connection conn)
                 throws DbmsException

Specified by:

getSchema in interface IDbmsSupport

Overrides:

getSchema in class GenericDbmsSupport

Throws:

DbmsException

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 @NonNull Object getClobHandle(@NonNull ResultSet rs,
 int column)
                              throws SQLException

Specified by:

getClobHandle in interface IDbmsSupport

Overrides:

getClobHandle in class GenericDbmsSupport

Throws:

SQLException

getBlobHandle

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

Specified by:

getBlobHandle in interface IDbmsSupport

Overrides:

getBlobHandle in class GenericDbmsSupport

Throws:

SQLException

getTableColumns

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

Specified by:

getTableColumns in interface IDbmsSupport

Overrides:

getTableColumns in class GenericDbmsSupport

Throws:

DbmsException

isTablePresent

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

Specified by:

isTablePresent in interface IDbmsSupport

Overrides:

isTablePresent in class GenericDbmsSupport

Throws:

DbmsException

isColumnPresent

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

Specified by:

isColumnPresent in interface IDbmsSupport

Overrides:

isColumnPresent in class GenericDbmsSupport

Throws:

DbmsException

hasIndexOnColumn

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

Specified by:

hasIndexOnColumn in interface IDbmsSupport

Overrides:

hasIndexOnColumn in class GenericDbmsSupport

Throws:

DbmsException

hasIndexOnColumns

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

Specified by:

hasIndexOnColumns in interface IDbmsSupport

Overrides:

hasIndexOnColumns in class GenericDbmsSupport