public class Db2DbmsSupport extends GenericDbmsSupport
KEYWORD_SELECT, log, sqlTranslators, TYPE_BLOB, TYPE_CLOB, TYPE_FUNCTION
Constructor and Description |
---|
Db2DbmsSupport() |
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) |
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
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
canFetchStatementParameterMetaData, isStoredProcedureRefCursorOutParameterSupported, isStoredProceduresSupported
public Dbms getDbms()
IDbmsSupport
DbmsSupportFactory
.getDbms
in interface IDbmsSupport
getDbms
in class GenericDbmsSupport
public boolean hasSkipLockedFunctionality()
hasSkipLockedFunctionality
in interface IDbmsSupport
hasSkipLockedFunctionality
in class GenericDbmsSupport
public String getFromForTablelessSelect()
IDbmsSupport
getFromForTablelessSelect
in interface IDbmsSupport
getFromForTablelessSelect
in class GenericDbmsSupport
public String emptyBlobValue()
emptyBlobValue
in interface IDbmsSupport
emptyBlobValue
in class GenericDbmsSupport
public String emptyClobValue()
emptyClobValue
in interface IDbmsSupport
emptyClobValue
in class GenericDbmsSupport
public String prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait) throws JdbcException
prepareQueryTextForWorkQueueReading
in interface IDbmsSupport
prepareQueryTextForWorkQueueReading
in class GenericDbmsSupport
JdbcException
public String prepareQueryTextForWorkQueuePeeking(int batchSize, String selectQuery, int wait) throws JdbcException
prepareQueryTextForWorkQueuePeeking
in interface IDbmsSupport
prepareQueryTextForWorkQueuePeeking
in class GenericDbmsSupport
JdbcException
public String getFirstRecordQuery(String tableName) throws JdbcException
getFirstRecordQuery
in interface IDbmsSupport
getFirstRecordQuery
in class GenericDbmsSupport
JdbcException
public String getSchema(Connection conn) throws JdbcException
getSchema
in interface IDbmsSupport
getSchema
in class GenericDbmsSupport
JdbcException
public boolean isTablePresent(Connection conn, String schemaName, String tableName) throws JdbcException
isTablePresent
in interface IDbmsSupport
isTablePresent
in class GenericDbmsSupport
JdbcException
public ResultSet getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern) throws JdbcException
getTableColumns
in interface IDbmsSupport
getTableColumns
in class GenericDbmsSupport
JdbcException
public boolean isColumnPresent(Connection conn, String schemaName, String tableName, String columnName) throws JdbcException
isColumnPresent
in interface IDbmsSupport
isColumnPresent
in class GenericDbmsSupport
JdbcException
public boolean hasIndexOnColumn(Connection conn, String schemaName, String tableName, String columnName) throws JdbcException
hasIndexOnColumn
in interface IDbmsSupport
hasIndexOnColumn
in class GenericDbmsSupport
JdbcException
public boolean hasIndexOnColumns(Connection conn, String schemaOwner, String tableName, List<String> columns) throws JdbcException
hasIndexOnColumns
in interface IDbmsSupport
hasIndexOnColumns
in class GenericDbmsSupport
JdbcException
public boolean isStoredProcedureOutParametersSupported()
IDbmsSupport
IDbmsSupport.isStoredProceduresSupported()
is true.isStoredProcedureOutParametersSupported
in interface IDbmsSupport
isStoredProcedureOutParametersSupported
in class GenericDbmsSupport
OUT
parameters with this database.
H2 does not support this by design. Oracle does not currently support this.public boolean isStoredProcedureResultSetSupported()
IDbmsSupport
isStoredProcedureResultSetSupported
in interface IDbmsSupport
isStoredProcedureResultSetSupported
in class GenericDbmsSupport
Copyright © 2023 Frank!Framework. All rights reserved.