nl.nn.adapterframework.jdbc.dbms

Class Db2DbmsSupport

java.lang.Object

nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

nl.nn.adapterframework.jdbc.dbms.Db2DbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class Db2DbmsSupport
extends GenericDbmsSupport

Support for DB2.

Author:

Gerrit van Brakel, 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
Db2DbmsSupport()

Method Summary

Modifier and Type	Method and Description
String	emptyBlobValue()
String	emptyClobValue()
Dbms	getDbms() Numeric value defining database type, defined in DbmsSupportFactory.
String	getFirstRecordQuery(String tableName)
String	getFromForTablelessSelect() http://en.wikipedia.org/wiki/DUAL_table
String	getSchema(Connection conn)
ResultSet	getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern)
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	isStoredProcedureOutParametersSupported() DBMS Feature flag: are OUT parameters for stored procedures supported? Can only be true if IDbmsSupport.isStoredProceduresSupported() is true.
boolean	isStoredProcedureResultSetSupported() DBMS Feature flag: is it possible to call a stored procedure that returns the results of a SELECT statement directly, without needing a REFCURSOR OUT parameter.
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 nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

applyBlobParameter, applyClobParameter, autoIncrementInsertValue, autoIncrementKeyMustBeInserted, autoIncrementUsesSequenceObject, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, getAutoIncrementKeyFieldType, getBlobFieldType, getBlobHandle, getBlobHandle, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBooleanFieldType, getBooleanValue, getCleanUpIbisstoreQuery, getClobFieldType, getClobHandle, getClobHandle, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getClobWriter, getDateAndOffset, getDatetimeLiteral, getDbmsName, getIbisStoreSummaryQuery, getInsertedAutoIncrementValueQuery, getLength, getNumericKeyFieldType, getRowNumber, getRowNumberShortName, getSchemaOwner, getSqlTranslator, getSysDate, getTableColumns, getTableColumns, getTextFieldType, getTimestampAsDate, getTimestampFieldType, getUpdateBlobQuery, getUpdateClobQuery, isBlobType, isClobType, isColumnPresent, isConstraintViolation, isIndexPresent, isParameterTypeMatchRequired, isQueryConversionRequired, isSequencePresent, isTablePresent, mustInsertEmptyBlobBeforeData, mustInsertEmptyClobBeforeData, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, 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

Methods inherited from interface nl.nn.adapterframework.jdbc.dbms.IDbmsSupport

canFetchStatementParameterMetaData, isStoredProcedureRefCursorOutParameterSupported, isStoredProceduresSupported

Constructor Detail

Db2DbmsSupport

public Db2DbmsSupport()

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

hasSkipLockedFunctionality

public boolean hasSkipLockedFunctionality()

Specified by:

hasSkipLockedFunctionality in interface IDbmsSupport

Overrides:

hasSkipLockedFunctionality in class GenericDbmsSupport

getFromForTablelessSelect

public String getFromForTablelessSelect()

Description copied from interface: IDbmsSupport

http://en.wikipedia.org/wiki/DUAL_table

Specified by:

getFromForTablelessSelect in interface IDbmsSupport

Overrides:

getFromForTablelessSelect in class GenericDbmsSupport

emptyBlobValue

public String emptyBlobValue()

Specified by:

emptyBlobValue in interface IDbmsSupport

Overrides:

emptyBlobValue in class GenericDbmsSupport

emptyClobValue

public String emptyClobValue()

Specified by:

emptyClobValue in interface IDbmsSupport

Overrides:

emptyClobValue in class GenericDbmsSupport

prepareQueryTextForWorkQueueReading

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

Specified by:

prepareQueryTextForWorkQueueReading in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueueReading in class GenericDbmsSupport

Throws:

JdbcException

prepareQueryTextForWorkQueuePeeking

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

Specified by:

prepareQueryTextForWorkQueuePeeking in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueuePeeking in class GenericDbmsSupport

Throws:

JdbcException

getFirstRecordQuery

public String getFirstRecordQuery(String tableName)
                           throws JdbcException

Specified by:

getFirstRecordQuery in interface IDbmsSupport

Overrides:

getFirstRecordQuery in class GenericDbmsSupport

Throws:

JdbcException

getSchema

public String getSchema(Connection conn)
                 throws JdbcException

Specified by:

getSchema in interface IDbmsSupport

Overrides:

getSchema 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

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

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)
                          throws JdbcException

Specified by:

hasIndexOnColumns in interface IDbmsSupport

Overrides:

hasIndexOnColumns in class GenericDbmsSupport

Throws:

JdbcException

isStoredProcedureOutParametersSupported

public boolean isStoredProcedureOutParametersSupported()

Description copied from interface: IDbmsSupport

DBMS Feature flag: are OUT parameters for stored procedures supported? Can only be true if IDbmsSupport.isStoredProceduresSupported() is true.

Specified by:

isStoredProcedureOutParametersSupported in interface IDbmsSupport

Overrides:

isStoredProcedureOutParametersSupported in class GenericDbmsSupport

Returns:

true if you can use stored procedures with OUT parameters with this database. H2 does not support this by design. Oracle does not currently support this.

isStoredProcedureResultSetSupported

public boolean isStoredProcedureResultSetSupported()

Description copied from interface: IDbmsSupport

DBMS Feature flag: is it possible to call a stored procedure that returns the results of a SELECT statement directly, without needing a REFCURSOR OUT parameter.

Specified by:

isStoredProcedureResultSetSupported in interface IDbmsSupport

Overrides:

isStoredProcedureResultSetSupported in class GenericDbmsSupport

Returns:

true for database that can directly return SELECT results. Not supported for PostgreSQL and Oracle.