nl.nn.adapterframework.jdbc.dbms

Class OracleDbmsSupport

java.lang.Object

nl.nn.adapterframework.jdbc.dbms.GenericDbmsSupport

nl.nn.adapterframework.jdbc.dbms.OracleDbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class OracleDbmsSupport
extends GenericDbmsSupport

Author:

Gerrit van Brakel

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
OracleDbmsSupport()

Method Summary

Modifier and Type	Method and Description
String	autoIncrementInsertValue(String sequenceName)
boolean	autoIncrementKeyMustBeInserted()
boolean	autoIncrementUsesSequenceObject()
boolean	canFetchStatementParameterMetaData()
String	emptyBlobValue()
String	getAutoIncrementKeyFieldType()
String	getBlobFieldType()
String	getBooleanFieldType()
String	getBooleanValue(boolean value)
Dbms	getDbms() Numeric value defining database type, defined in DbmsSupportFactory.
String	getFirstRecordQuery(String tableName)
String	getFromForTablelessSelect() http://en.wikipedia.org/wiki/DUAL_table
String	getInsertedAutoIncrementValueQuery(String sequenceName)
String	getNumericKeyFieldType()
String	getRowNumber(String order, String sort)
String	getRowNumberShortName()
String	getSchema(Connection conn)
String	getSysDate() SQL String returning current date and time of dbms.
ResultSet	getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern)
String	getTextFieldType()
String	getTimestampFieldType()
String	getUpdateBlobQuery(String table, String blobField, String keyField)
boolean	hasIndexOnColumn(Connection conn, String schemaOwner, 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	isIndexPresent(Connection conn, String schemaOwner, String tableName, String indexName)
boolean	isSequencePresent(Connection conn, String schemaOwner, String tableName, String sequenceName)
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)
boolean	mustInsertEmptyBlobBeforeData()
String	prepareQueryTextForWorkQueueReading(int batchSize, String selectQuery, int wait)
String	provideFirstRowsHintAfterFirstKeyword(int rowCount)
String	provideIndexHintAfterFirstKeyword(String tableName, String indexName)
void	updateBlob(ResultSet rs, int column, Object blobUpdateHandle)
void	updateBlob(ResultSet rs, String column, Object blobUpdateHandle)
void	updateClob(ResultSet rs, int column, Object clobUpdateHandle)
void	updateClob(ResultSet rs, String column, Object clobUpdateHandle)

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

applyBlobParameter, applyClobParameter, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, emptyClobValue, getBlobHandle, getBlobHandle, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getCleanUpIbisstoreQuery, getClobFieldType, getClobHandle, getClobHandle, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getClobWriter, getDateAndOffset, getDatetimeLiteral, getDbmsName, getIbisStoreSummaryQuery, getLength, getSchemaOwner, getSqlTranslator, getTableColumns, getTableColumns, getTimestampAsDate, getUpdateClobQuery, isBlobType, isClobType, isColumnPresent, isConstraintViolation, isParameterTypeMatchRequired, isQueryConversionRequired, isStoredProcedureOutParametersSupported, isTablePresent, mustInsertEmptyClobBeforeData, prepareQueryTextForNonLockingRead, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueuePeeking, prepareQueryTextForWorkQueueReading, provideTrailingFirstRowsHint, splitQuery, 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

isStoredProcedureRefCursorOutParameterSupported, isStoredProceduresSupported

Constructor Detail

OracleDbmsSupport

public OracleDbmsSupport()

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

getSysDate

public String getSysDate()

Description copied from interface: IDbmsSupport

SQL String returning current date and time of dbms.

Specified by:

getSysDate in interface IDbmsSupport

Overrides:

getSysDate in class GenericDbmsSupport

getNumericKeyFieldType

public String getNumericKeyFieldType()

Specified by:

getNumericKeyFieldType in interface IDbmsSupport

Overrides:

getNumericKeyFieldType 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

getAutoIncrementKeyFieldType

public String getAutoIncrementKeyFieldType()

Specified by:

getAutoIncrementKeyFieldType in interface IDbmsSupport

Overrides:

getAutoIncrementKeyFieldType in class GenericDbmsSupport

autoIncrementKeyMustBeInserted

public boolean autoIncrementKeyMustBeInserted()

Specified by:

autoIncrementKeyMustBeInserted in interface IDbmsSupport

Overrides:

autoIncrementKeyMustBeInserted in class GenericDbmsSupport

autoIncrementInsertValue

public String autoIncrementInsertValue(String sequenceName)

Specified by:

autoIncrementInsertValue in interface IDbmsSupport

Overrides:

autoIncrementInsertValue in class GenericDbmsSupport

autoIncrementUsesSequenceObject

public boolean autoIncrementUsesSequenceObject()

Specified by:

autoIncrementUsesSequenceObject in interface IDbmsSupport

Overrides:

autoIncrementUsesSequenceObject in class GenericDbmsSupport

getInsertedAutoIncrementValueQuery

public String getInsertedAutoIncrementValueQuery(String sequenceName)

Specified by:

getInsertedAutoIncrementValueQuery in interface IDbmsSupport

Overrides:

getInsertedAutoIncrementValueQuery in class GenericDbmsSupport

getTimestampFieldType

public String getTimestampFieldType()

Specified by:

getTimestampFieldType in interface IDbmsSupport

Overrides:

getTimestampFieldType in class GenericDbmsSupport

getBlobFieldType

public String getBlobFieldType()

Specified by:

getBlobFieldType in interface IDbmsSupport

Overrides:

getBlobFieldType in class GenericDbmsSupport

mustInsertEmptyBlobBeforeData

public boolean mustInsertEmptyBlobBeforeData()

Specified by:

mustInsertEmptyBlobBeforeData in interface IDbmsSupport

Overrides:

mustInsertEmptyBlobBeforeData in class GenericDbmsSupport

getUpdateBlobQuery

public String getUpdateBlobQuery(String table,
                                 String blobField,
                                 String keyField)

Specified by:

getUpdateBlobQuery in interface IDbmsSupport

Overrides:

getUpdateBlobQuery in class GenericDbmsSupport

emptyBlobValue

public String emptyBlobValue()

Specified by:

emptyBlobValue in interface IDbmsSupport

Overrides:

emptyBlobValue in class GenericDbmsSupport

getTextFieldType

public String getTextFieldType()

Specified by:

getTextFieldType in interface IDbmsSupport

Overrides:

getTextFieldType 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

getFirstRecordQuery

public String getFirstRecordQuery(String tableName)
                           throws JdbcException

Specified by:

getFirstRecordQuery in interface IDbmsSupport

Overrides:

getFirstRecordQuery in class GenericDbmsSupport

Throws:

JdbcException

provideIndexHintAfterFirstKeyword

public String provideIndexHintAfterFirstKeyword(String tableName,
                                                String indexName)

Specified by:

provideIndexHintAfterFirstKeyword in interface IDbmsSupport

Overrides:

provideIndexHintAfterFirstKeyword in class GenericDbmsSupport

provideFirstRowsHintAfterFirstKeyword

public String provideFirstRowsHintAfterFirstKeyword(int rowCount)

Specified by:

provideFirstRowsHintAfterFirstKeyword in interface IDbmsSupport

Overrides:

provideFirstRowsHintAfterFirstKeyword in class GenericDbmsSupport

updateClob

public void updateClob(ResultSet rs,
                       int column,
                       Object clobUpdateHandle)
                throws SQLException

Specified by:

updateClob in interface IDbmsSupport

Overrides:

updateClob in class GenericDbmsSupport

Throws:

SQLException

updateClob

public void updateClob(ResultSet rs,
                       String column,
                       Object clobUpdateHandle)
                throws SQLException

Specified by:

updateClob in interface IDbmsSupport

Overrides:

updateClob in class GenericDbmsSupport

Throws:

SQLException

updateBlob

public void updateBlob(ResultSet rs,
                       int column,
                       Object blobUpdateHandle)
                throws SQLException

Specified by:

updateBlob in interface IDbmsSupport

Overrides:

updateBlob in class GenericDbmsSupport

Throws:

SQLException

updateBlob

public void updateBlob(ResultSet rs,
                       String column,
                       Object blobUpdateHandle)
                throws SQLException

Specified by:

updateBlob in interface IDbmsSupport

Overrides:

updateBlob in class GenericDbmsSupport

Throws:

SQLException

getSchema

public String getSchema(Connection conn)
                 throws JdbcException

Specified by:

getSchema in interface IDbmsSupport

Overrides:

getSchema in class GenericDbmsSupport

Throws:

JdbcException

getRowNumber

public String getRowNumber(String order,
                           String sort)

Specified by:

getRowNumber in interface IDbmsSupport

Overrides:

getRowNumber in class GenericDbmsSupport

getRowNumberShortName

public String getRowNumberShortName()

Specified by:

getRowNumberShortName in interface IDbmsSupport

Overrides:

getRowNumberShortName in class GenericDbmsSupport

getBooleanFieldType

public String getBooleanFieldType()

Specified by:

getBooleanFieldType in interface IDbmsSupport

Overrides:

getBooleanFieldType in class GenericDbmsSupport

getBooleanValue

public String getBooleanValue(boolean value)

Specified by:

getBooleanValue in interface IDbmsSupport

Overrides:

getBooleanValue in class GenericDbmsSupport

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

isIndexPresent

public boolean isIndexPresent(Connection conn,
                              String schemaOwner,
                              String tableName,
                              String indexName)

Specified by:

isIndexPresent in interface IDbmsSupport

Overrides:

isIndexPresent in class GenericDbmsSupport

isSequencePresent

public boolean isSequencePresent(Connection conn,
                                 String schemaOwner,
                                 String tableName,
                                 String sequenceName)

Specified by:

isSequencePresent in interface IDbmsSupport

Overrides:

isSequencePresent in class GenericDbmsSupport

hasIndexOnColumn

public boolean hasIndexOnColumn(Connection conn,
                                String schemaOwner,
                                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

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.

canFetchStatementParameterMetaData

public boolean canFetchStatementParameterMetaData()