Package org.frankframework.dbms

Class OracleDbmsSupport

java.lang.Object

org.frankframework.dbms.GenericDbmsSupport

org.frankframework.dbms.OracleDbmsSupport

All Implemented Interfaces:

IDbmsSupport

public class OracleDbmsSupport
extends GenericDbmsSupport

Author:

Gerrit van Brakel

Field Summary

Fields

Modifier and Type	Field	Description
static final org.frankframework.dbms.CustomSQLType	ORACLE_CURSOR_TYPE_DEF

Fields inherited from class org.frankframework.dbms.GenericDbmsSupport

KEYWORD_SELECT, log, sqlTranslators

Constructor Summary

Constructors

Constructor	Description
OracleDbmsSupport()

Method Summary

Modifier and Type	Method	Description
String	autoIncrementInsertValue(String sequenceName)
boolean	autoIncrementKeyMustBeInserted()
boolean	autoIncrementUsesSequenceObject()
boolean	canFetchStatementParameterMetaData()
String	getAutoIncrementKeyFieldType()
String	getBooleanValue(boolean value)
SQLType	getCursorSqlType()
Dbms	getDbms()
String	getFromForTablelessSelect()	http://en.wikipedia.org/wiki/DUAL_table
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()
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	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)
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 org.frankframework.dbms.GenericDbmsSupport

applyBlobParameter, applyClobParameter, convertQuery, createTranslator, doHasIndexOnColumns, doIsColumnPresent, doIsTablePresent, getBlobFieldType, getBlobHandle, getBlobHandle, getBlobInputStream, getBlobInputStream, getBlobOutputStream, getBlobOutputStream, getBlobOutputStream, getClobHandle, getClobHandle, getClobReader, getClobReader, getClobWriter, getClobWriter, getDateAndOffset, getDatetimeLiteral, getFormattedDate, getLength, getSqlTranslator, getTableColumns, getTableColumns, getTimestampAsDate, getTimestampFieldType, isBlobType, isClobType, isColumnPresent, isConstraintViolation, isParameterTypeMatchRequired, isQueryConversionRequired, isTablePresent, 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 org.frankframework.dbms.IDbmsSupport

getDbmsName, isRowVersionTimestamp

Field Details

ORACLE_CURSOR_TYPE_DEF

public static final org.frankframework.dbms.CustomSQLType ORACLE_CURSOR_TYPE_DEF

Constructor Details

OracleDbmsSupport

public OracleDbmsSupport()

Method Details

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

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

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

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 DbmsException

Specified by:

prepareQueryTextForWorkQueueReading in interface IDbmsSupport

Overrides:

prepareQueryTextForWorkQueueReading in class GenericDbmsSupport

Throws:

DbmsException

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 DbmsException

Specified by:

getSchema in interface IDbmsSupport

Overrides:

getSchema in class GenericDbmsSupport

Throws:

DbmsException

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 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

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 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

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.

Returns:

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

canFetchStatementParameterMetaData

public boolean canFetchStatementParameterMetaData()

getCursorSqlType

public SQLType getCursorSqlType()