public class OracleDbmsSupport extends GenericDbmsSupport
KEYWORD_SELECT, log, sqlTranslators, TYPE_BLOB, TYPE_CLOB, TYPE_FUNCTION
Constructor and Description |
---|
OracleDbmsSupport() |
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
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
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 getSysDate()
IDbmsSupport
getSysDate
in interface IDbmsSupport
getSysDate
in class GenericDbmsSupport
public String getNumericKeyFieldType()
getNumericKeyFieldType
in interface IDbmsSupport
getNumericKeyFieldType
in class GenericDbmsSupport
public String getFromForTablelessSelect()
IDbmsSupport
getFromForTablelessSelect
in interface IDbmsSupport
getFromForTablelessSelect
in class GenericDbmsSupport
public String getAutoIncrementKeyFieldType()
getAutoIncrementKeyFieldType
in interface IDbmsSupport
getAutoIncrementKeyFieldType
in class GenericDbmsSupport
public boolean autoIncrementKeyMustBeInserted()
autoIncrementKeyMustBeInserted
in interface IDbmsSupport
autoIncrementKeyMustBeInserted
in class GenericDbmsSupport
public String autoIncrementInsertValue(String sequenceName)
autoIncrementInsertValue
in interface IDbmsSupport
autoIncrementInsertValue
in class GenericDbmsSupport
public boolean autoIncrementUsesSequenceObject()
autoIncrementUsesSequenceObject
in interface IDbmsSupport
autoIncrementUsesSequenceObject
in class GenericDbmsSupport
public String getInsertedAutoIncrementValueQuery(String sequenceName)
getInsertedAutoIncrementValueQuery
in interface IDbmsSupport
getInsertedAutoIncrementValueQuery
in class GenericDbmsSupport
public String getTimestampFieldType()
getTimestampFieldType
in interface IDbmsSupport
getTimestampFieldType
in class GenericDbmsSupport
public String getBlobFieldType()
getBlobFieldType
in interface IDbmsSupport
getBlobFieldType
in class GenericDbmsSupport
public boolean mustInsertEmptyBlobBeforeData()
mustInsertEmptyBlobBeforeData
in interface IDbmsSupport
mustInsertEmptyBlobBeforeData
in class GenericDbmsSupport
public String getUpdateBlobQuery(String table, String blobField, String keyField)
getUpdateBlobQuery
in interface IDbmsSupport
getUpdateBlobQuery
in class GenericDbmsSupport
public String emptyBlobValue()
emptyBlobValue
in interface IDbmsSupport
emptyBlobValue
in class GenericDbmsSupport
public String getTextFieldType()
getTextFieldType
in interface IDbmsSupport
getTextFieldType
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 getFirstRecordQuery(String tableName) throws JdbcException
getFirstRecordQuery
in interface IDbmsSupport
getFirstRecordQuery
in class GenericDbmsSupport
JdbcException
public String provideIndexHintAfterFirstKeyword(String tableName, String indexName)
provideIndexHintAfterFirstKeyword
in interface IDbmsSupport
provideIndexHintAfterFirstKeyword
in class GenericDbmsSupport
public String provideFirstRowsHintAfterFirstKeyword(int rowCount)
provideFirstRowsHintAfterFirstKeyword
in interface IDbmsSupport
provideFirstRowsHintAfterFirstKeyword
in class GenericDbmsSupport
public void updateClob(ResultSet rs, int column, Object clobUpdateHandle) throws SQLException
updateClob
in interface IDbmsSupport
updateClob
in class GenericDbmsSupport
SQLException
public void updateClob(ResultSet rs, String column, Object clobUpdateHandle) throws SQLException
updateClob
in interface IDbmsSupport
updateClob
in class GenericDbmsSupport
SQLException
public void updateBlob(ResultSet rs, int column, Object blobUpdateHandle) throws SQLException
updateBlob
in interface IDbmsSupport
updateBlob
in class GenericDbmsSupport
SQLException
public void updateBlob(ResultSet rs, String column, Object blobUpdateHandle) throws SQLException
updateBlob
in interface IDbmsSupport
updateBlob
in class GenericDbmsSupport
SQLException
public String getSchema(Connection conn) throws JdbcException
getSchema
in interface IDbmsSupport
getSchema
in class GenericDbmsSupport
JdbcException
public String getRowNumber(String order, String sort)
getRowNumber
in interface IDbmsSupport
getRowNumber
in class GenericDbmsSupport
public String getRowNumberShortName()
getRowNumberShortName
in interface IDbmsSupport
getRowNumberShortName
in class GenericDbmsSupport
public String getBooleanFieldType()
getBooleanFieldType
in interface IDbmsSupport
getBooleanFieldType
in class GenericDbmsSupport
public String getBooleanValue(boolean value)
getBooleanValue
in interface IDbmsSupport
getBooleanValue
in class GenericDbmsSupport
public ResultSet getTableColumns(Connection conn, String schemaName, String tableName, String columnNamePattern) throws JdbcException
getTableColumns
in interface IDbmsSupport
getTableColumns
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 boolean isColumnPresent(Connection conn, String schemaName, String tableName, String columnName) throws JdbcException
isColumnPresent
in interface IDbmsSupport
isColumnPresent
in class GenericDbmsSupport
JdbcException
public boolean isIndexPresent(Connection conn, String schemaOwner, String tableName, String indexName)
isIndexPresent
in interface IDbmsSupport
isIndexPresent
in class GenericDbmsSupport
public boolean isSequencePresent(Connection conn, String schemaOwner, String tableName, String sequenceName)
isSequencePresent
in interface IDbmsSupport
isSequencePresent
in class GenericDbmsSupport
public boolean hasIndexOnColumn(Connection conn, String schemaOwner, 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)
hasIndexOnColumns
in interface IDbmsSupport
hasIndexOnColumns
in class GenericDbmsSupport
public boolean isStoredProcedureResultSetSupported()
IDbmsSupport
isStoredProcedureResultSetSupported
in interface IDbmsSupport
isStoredProcedureResultSetSupported
in class GenericDbmsSupport
public boolean canFetchStatementParameterMetaData()
Copyright © 2023 Frank!Framework. All rights reserved.