public class Oracle8Platform extends OraclePlatform
Purpose: Supports certain new Oracle 8 data types, and usage of certain Oracle JDBC specific APIs.
Supports Oracle thin JDBC driver LOB >4k binding workaround.
Creates BLOB and CLOB type for byte[] and char[] for table creation.
Supports object-relational data-type creation.
| Modifier and Type | Field and Description |
|---|---|
protected int |
lobValueLimits
The LOB value limits when the Locator is required for the writing
|
protected boolean |
usesLocatorForLOBWrite
Locator is required for Oracle thin driver to write LOB value exceeds the limits
|
END_FROM, END_FROM_ID, FROM, FROM_ID, HINT_END, HINT_START, LOCK_END, LOCK_START_PREFIX, LOCK_START_SUFFIX, MAX_ROW, MIN_ROW, ORDER_BY_ID, SELECT, SELECT_ID_PREFIX, SELECT_ID_SUFFIX, shouldPrintForUpdateClause, supportsIdentity, vpdClearIdentifierQuery, vpdSetIdentifierQueryDEFAULT_VARCHAR_SIZEbatchWritingMechanism, castSizeForVarcharParameter, classTypes, cursorCode, DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, driverName, driverSupportsNationalCharacterVarying, fieldTypes, IS_VALID_TIMEOUT, isCastRequired, maxBatchWritingSize, partitioningCallback, pingSQL, printInnerJoinInWhereClause, printOuterJoinInWhereClause, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldCreateIndicesOnForeignKeys, shouldForceBindAllParameters, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldTrimStrings, statementCacheSize, storedProcedureTerminationToken, stringBindingSize, structConverters, supportsAutoCommit, tableCreationSuffix, transactionIsolation, typeConverters, useJDBCStoredProcedureSyntax, useNationalCharacterVarying, useRownumFiltering, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesStreamsForBinding, usesStringBindingconversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultNativeSequenceToTable, defaultSeqenceAtNextValue, defaultSequence, endDelimiter, platformOperators, sequences, sequencesLock, startDelimiter, tableQualifier, timestampQuery| Constructor and Description |
|---|
Oracle8Platform() |
| Modifier and Type | Method and Description |
|---|---|
protected Hashtable |
buildFieldTypes()
INTERNAL:
|
void |
copyInto(org.eclipse.persistence.internal.databaseaccess.Platform platform)
INTERNAL:
Allow for conversion from the Oralce type to the Java type.
|
Array |
createArray(String elementDataTypeName,
Object[] elements,
Connection connection)
INTERNAL:
Platforms that support java.sql.Array may override this method.
|
Struct |
createStruct(String structTypeName,
Object[] attributes,
Connection connection)
INTERNAL:
Platforms that support java.sql.Struct may override this method.
|
void |
freeTemporaryObject(Object value)
INTERNAL:
Used by Oracle platforms during reading of ResultSet to free temporary LOBs.
|
Connection |
getConnection(org.eclipse.persistence.internal.sessions.AbstractSession session,
Connection connection)
INTERNAL:
This method is used to unwrap the oracle connection wrapped by
the application server.
|
Object |
getCustomModifyValueForCall(Call call,
Object value,
org.eclipse.persistence.internal.helper.DatabaseField field,
boolean shouldBind)
INTERNAL
Used by SQLCall.translate(..)
Typically there is no field translation (and this is default implementation).
|
int |
getLobValueLimits()
PUBLIC:
Return the BLOB/CLOB value limits on thin driver.
|
Object |
getRefValue(Ref ref,
Connection connection)
INTERNAL:
Overrides DatabasePlatform method.
|
protected boolean |
isBlob(Class type)
INTERNAL:
Used in writeLOB method only to identify a BLOB
|
protected boolean |
isClob(Class type)
INTERNAL:
Used in writeLOB method only to identify a CLOB
|
boolean |
isNativeConnectionRequiredForLobLocator()
INTERNAL:
Indicates whether app.
|
protected boolean |
lobValueExceedsLimit(Object value)
INTERNAL:
Return if the LOB value size is larger than the limit, i.e.
|
void |
setLobValueLimits(int lobValueLimits)
PUBLIC:
Set the BLOB/CLOB value limits on thin driver.
|
void |
setShouldUseLocatorForLOBWrite(boolean usesLocatorForLOBWrite)
PUBLIC:
Set if the locator is required for the LOB write.
|
boolean |
shouldUseCustomModifyForCall(org.eclipse.persistence.internal.helper.DatabaseField field)
INTERNAL
Used by SQLCall.appendModify(..)
If the field should be passed to customModifyInDatabaseCall, retun true,
otherwise false.
|
boolean |
shouldUseLocatorForLOBWrite()
PUBLIC:
Return if the locator is required for the LOB write.
|
void |
writeLOB(org.eclipse.persistence.internal.helper.DatabaseField field,
Object value,
ResultSet resultSet,
org.eclipse.persistence.internal.sessions.AbstractSession session)
INTERNAL:
Write LOB value - works on Oracle 10 and newer
|
allowsSizeInProcedureArguments, appendByteArray, appendCalendar, appendDate, appendTime, appendTimestamp, atan2Operator, buildCallWithReturning, buildFirstRowsHint, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, canBuildCallWithReturning, canUnwrapOracleConnection, checkTableExists, clearOracleConnectionCache, createExpressionFor, currentDateOperator, currentTimeOperator, exceptOperator, getAssignmentString, getBatchBeginString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getDeclareBeginString, getDropCascadeString, getDropDatabaseSchemaString, getINClauseLimit, getMaxFieldNameSize, getNativeTableInfo, getObjectFromResultSet, getProcedureArgument, getProcedureCallHeader, getProcedureCallTail, getSelectForUpdateString, getSelectForUpdateWaitString, getStoredProcedureParameterPrefix, getSystemChangeNumberQuery, getTableExistsQuery, getTimestampQuery, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, initializeConnectionData, initializePlatformOperators, isAlterSequenceObjectSupported, isForUpdateCompatibleWithDistinct, isLobCompatibleWithDistinct, isLockTimeoutException, isOracle, isRowCountOutputParameterRequired, logOperator, maximumNumericValues, minimumNumericValues, operatorLocate, operatorLocate2, operatorOuterJoin, printFieldNullClause, printSQLSelectStatement, regexpOperator, serverTimestampString, setSupportsIdentity, shouldPrintForUpdateClause, shouldPrintStoredProcedureArgumentNameInCall, shouldUseJDBCOuterJoinSyntax, supportsAutoConversionToNumericForArithmeticOperations, supportsIdentity, supportsSelectForUpdateNoWait, supportsSequenceObjects, supportsStoredFunctions, supportsVPD, supportsWaitForUpdate, todayOperator, unwrapOracleConnection, useJDBCStoredProcedureSyntax, wasFailureCommunicationBasedaddBatch, addStructConverter, appendBoolean, appendLiteralToCall, appendLiteralToCallWithBinding, appendNumber, appendParameter, appendParameterInternal, appendString, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildClassTypes, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, createArray, createPlatformDefaultSequence, createStruct, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, getBatchDelimiterString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnectionUserName, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateTempTableSqlBodyForTable, getCreateTempTableSqlPrefix, getCreateTempTableSqlSuffix, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getDefaultSequenceTableName, getDriverSupportsNVarChar, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIndexNamePrefix, getInOutputProcedureToken, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getOutputProcedureToken, getParameterValueFromDatabaseCall, getParameterValueFromDatabaseCall, getPartitioningCallback, getPingSQL, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureEndString, getProcedureOptionList, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTempTableForTable, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getUseNationalCharacterVaryingTypeForString, hasPartitioningCallback, initialize, isCastRequired, isDynamicSQLRequiredForFunctions, isInformixOuterJoin, isJDBCExecuteCompliant, isNullAllowedInSelectClause, isOutputAllowWithResultSet, isXDBDocument, minimumTimeIncrement, prepareBatchStatement, printFieldIdentityClause, printFieldNotNullClause, printFieldTypeSize, printFieldTypeSize, printFieldUnique, printFieldUnique, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, registerOutputParameter, registerOutputParameter, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureBrackets, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTableInIndexDropDDL, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setClassTypes, setCursorCode, setDriverName, setDriverSupportsNVarChar, setFieldTypes, setIsCastRequired, setMaxBatchWritingSize, setNullFromDatabaseField, setNullFromDatabaseField, setParameterValueInDatabaseCall, setParameterValueInDatabaseCall, setPartitioningCallback, setPingSQL, setPrintInnerJoinInWhereClause, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldCacheAllStatements, setShouldCreateIndicesOnForeignKeys, setShouldForceBindAllParameters, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setShouldUseRownumFiltering, setStatementCacheSize, setStoredProcedureTerminationToken, setStringBindingSize, setSupportsAutoCommit, setTableCreationSuffix, setTransactionIsolation, setUseJDBCStoredProcedureSyntax, setUseNationalCharacterVaryingTypeForString, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldAlwaysUseTempStorageForModifyAll, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldCreateIndicesForPrimaryKeys, shouldCreateIndicesOnForeignKeys, shouldCreateIndicesOnUniqueKeys, shouldForceBindAllParameters, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsConnectionUserName, supportsCountDistinctWithMultipleFields, supportsDeleteOnCascade, supportsForeignKeyConstraints, supportsGlobalTempTables, supportsIndexes, supportsIndividualTableLocking, supportsLocalTempTables, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, writeAddColumnClause, writeAutoAssignmentSetClause, writeAutoJoinWhereClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeFields, writeFieldsAutoClause, writeFieldsList, writeInsertIntoTableSql, writeJoinWhereClause, writeParameterMarker, writeTableCreationSuffix, writeUpdateOriginalFromTempTableSqladdOperator, addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultNativeSequenceToTable, getDefaultSeqenceAtNextValue, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, initIdentitySequences, isAccess, isAttunity, isCloudscape, isDB2, isDB2Z, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle12, isOracle9, isPervasive, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeIdentitySequences, removeSequence, sequencesAfterCloneCleanup, setConversionManager, setDefaultNativeSequenceToTable, setDefaultSeqenceAtNextValue, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, toString, usesPlatformDefaultSequenceprotected boolean usesLocatorForLOBWrite
protected int lobValueLimits
protected Hashtable buildFieldTypes()
buildFieldTypes in class OraclePlatformpublic void copyInto(org.eclipse.persistence.internal.databaseaccess.Platform platform)
copyInto in interface org.eclipse.persistence.internal.databaseaccess.PlatformcopyInto in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformprotected boolean lobValueExceedsLimit(Object value)
public Connection getConnection(org.eclipse.persistence.internal.sessions.AbstractSession session, Connection connection)
getConnection in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic Object getCustomModifyValueForCall(Call call, Object value, org.eclipse.persistence.internal.helper.DatabaseField field, boolean shouldBind)
getCustomModifyValueForCall in interface org.eclipse.persistence.internal.databaseaccess.PlatformgetCustomModifyValueForCall in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean shouldUseCustomModifyForCall(org.eclipse.persistence.internal.helper.DatabaseField field)
shouldUseCustomModifyForCall in interface org.eclipse.persistence.internal.databaseaccess.PlatformshouldUseCustomModifyForCall in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic void writeLOB(org.eclipse.persistence.internal.helper.DatabaseField field,
Object value,
ResultSet resultSet,
org.eclipse.persistence.internal.sessions.AbstractSession session)
throws SQLException
writeLOB in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformSQLExceptionprotected boolean isBlob(Class type)
protected boolean isClob(Class type)
public boolean isNativeConnectionRequiredForLobLocator()
isNativeConnectionRequiredForLobLocator in class OraclePlatformpublic void setShouldUseLocatorForLOBWrite(boolean usesLocatorForLOBWrite)
public boolean shouldUseLocatorForLOBWrite()
public int getLobValueLimits()
public void setLobValueLimits(int lobValueLimits)
public Array createArray(String elementDataTypeName, Object[] elements, Connection connection) throws SQLException
createArray in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformSQLExceptionpublic Struct createStruct(String structTypeName, Object[] attributes, Connection connection) throws SQLException
createStruct in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformSQLExceptionpublic Object getRefValue(Ref ref, Connection connection) throws SQLException
getRefValue in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformSQLExceptionpublic void freeTemporaryObject(Object value) throws SQLException
freeTemporaryObject in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformSQLExceptionCopyright © 2007–2021 Eclipse.org - EclipseLink Project. All rights reserved.