org.eclipse.persistence.platform.database.oracle

Class Oracle9Platform

java.lang.Object

org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

org.eclipse.persistence.platform.database.DatabasePlatform

org.eclipse.persistence.platform.database.OraclePlatform

org.eclipse.persistence.platform.database.oracle.Oracle8Platform

org.eclipse.persistence.platform.database.oracle.Oracle9Platform

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, CorePlatform<ConversionManager>, Platform

Direct Known Subclasses:

Oracle10Platform

public class Oracle9Platform
extends Oracle8Platform

Purpose: Supports usage of certain Oracle JDBC specific APIs.

Supports binding NCHAR, NVARCHAR, NCLOB types as required by Oracle JDBC drivers.

Supports Oracle JDBC TIMESTAMP, TIMESTAMPTZ, TIMESTAMPLTZ types.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.Class	NCHAR
static java.lang.Class	NCLOB
static java.lang.Class	NSTRING
static java.lang.Class	XMLTYPE

Fields inherited from class org.eclipse.persistence.platform.database.DatabasePlatform

DEFAULT_VARCHAR_SIZE

Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, IS_VALID_TIMEOUT, shouldIgnoreCaseOnFieldComparisons, Types_NCLOB, Types_SQLXML

Constructor Summary

Constructors

Constructor and Description
Oracle9Platform()

Method Summary

Modifier and Type	Method and Description
int	addBatch(java.sql.PreparedStatement statement) INTERNAL: This gets called on each iteration to add parameters to the batch Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).
boolean	canUnwrapOracleConnection() INTERNAL: Indicates whether this Oracle platform can unwrap Oracle connection.
void	clearConnectionData()
void	clearOracleConnectionCache(java.sql.Connection conn) INTERNAL: Clears both implicit and explicit caches of OracleConnection
java.lang.Object	clone()
java.lang.Object	convertObject(java.lang.Object sourceObject, java.lang.Class javaClass) INTERNAL: Allow for conversion from the Oracle type to the Java type.
void	copyInto(Platform platform) Copy the state into the new platform.
ConnectionCustomizer	createConnectionCustomizer(Accessor accessor, AbstractSession session) INTERNAL:
int	executeBatch(java.sql.Statement statement, boolean isStatementPrepared) INTERNAL: This gets called on each batch statement execution Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).
java.lang.String	getConnectionUserName() INTERNAL: Returns user name retrieved from JDBC connection.
java.lang.Object	getCustomModifyValueForCall(Call call, java.lang.Object value, DatabaseField field, boolean shouldBind) INTERNAL: Used by SQLCall.translate(..) The binding *must* be performed (NCHAR, NSTRING, NCLOB).
java.util.Vector	getDataTypesConvertedFrom(java.lang.Class javaClass) INTERNAL: Return the list of Classes that can be converted to from the passed in javaClass.
java.util.Vector	getDataTypesConvertedTo(java.lang.Class javaClass) INTERNAL: Return the list of Classes that can be converted from to the passed in javaClass.
java.lang.String	getDriverVersion() INTERNAL: Return the driver version.
int	getJDBCType(java.lang.Class javaType) Return the JDBC type for the Java type.
int	getJDBCTypeForSetNull(DatabaseField field) Return the JDBC type for the given database field to be passed to Statement.setNull The Oracle driver does not like the OPAQUE type so VARCHAR must be used.
int	getLobValueLimits() PUBLIC: Return the BLOB/CLOB value limits on thin driver.
java.lang.Object	getObjectFromResultSet(java.sql.ResultSet resultSet, int columnNumber, int type, AbstractSession session) INTERNAL: Get a timestamp value from a result set.
java.sql.Timestamp	getTimestampFromServer(AbstractSession session, java.lang.String sessionName) INTERNAL: Answer the timestamp from the server.
java.lang.Object	getTIMESTAMPLTZFromResultSet(java.sql.ResultSet resultSet, int columnNumber, int type, AbstractSession session) INTERNAL: Get a TIMESTAMPLTZ value from a result set.
ValueReadQuery	getTimestampQuery() INTERNAL: This method returns the query to select the SYSTIMESTAMP as TIMESTAMPTZ from the server for Oracle9i.
java.lang.Object	getTIMESTAMPTZFromResultSet(java.sql.ResultSet resultSet, int columnNumber, int type, AbstractSession session) INTERNAL: Get a TIMESTAMPTZ value from a result set.
void	initializeConnectionData(java.sql.Connection connection) INTERNAL:
boolean	isLtzTimestampInGmt() INTERNAL: Return if ltz timestamps are returned in GMT by the driver.
boolean	isOracle9() PUBLIC: Return is this is the Oracle 9 platform.
boolean	isTimestampInGmt() INTERNAL: Return if timestamps are returned in GMT by the driver.
boolean	isXDBDocument(java.lang.Object obj) INTERNAL: Indicates whether the passed object is an instance of XDBDocument.
java.sql.Statement	prepareBatchStatement(java.sql.Statement statement, int maxBatchWritingSize) INTERNAL: Allows setting the batch size on the statement Is used with parameterized SQL, and should only be passed in prepared statements
java.lang.String	serverTimestampString() INTERNAL: Return the current SYSTIMESTAMP as TIMESTAMPTZ from the server.
void	setLobValueLimits(int lobValueLimits) PUBLIC: Set the BLOB/CLOB value limits on thin driver.
void	setParameterValueInDatabaseCall(java.lang.Object parameter, java.sql.PreparedStatement statement, int index, AbstractSession session) INTERNAL: Note that index (not index+1) is used in statement.setObject(index, parameter) Binding starts with a 1 not 0, so make sure that index > 0.
void	setShouldTruncateDate(boolean shouldTruncateDate) PUBLIC: Indicates whether time component of java.sql.Date should be truncated (hours, minutes, seconds all set to zero) before been passed as a parameter to PreparedStatement.
boolean	shouldTruncateDate() PUBLIC: Indicates whether time component of java.sql.Date should be truncated (hours, minutes, seconds all set to zero) before been passed as a parameter to PreparedStatement.
boolean	shouldUseCustomModifyForCall(DatabaseField field) INTERNAL Used by SQLCall.appendModify(..) If the field should be passed to customModifyInDatabaseCall, retun true, otherwise false.
boolean	supportsConnectionUserName() INTERNAL: User name from JDBC connection is stored in initializeConnectionData(Connection).
java.sql.Connection	unwrapOracleConnection(java.sql.Connection connection) INTERNAL: If can unwrap returns unwrapped Oracle connection, otherwise original connection.

Methods inherited from class org.eclipse.persistence.platform.database.oracle.Oracle8Platform

createArray, createStruct, freeTemporaryObject, getConnection, getRefValue, isNativeConnectionRequiredForLobLocator, setShouldUseLocatorForLOBWrite, shouldUseLocatorForLOBWrite, writeLOB

Methods inherited from class org.eclipse.persistence.platform.database.OraclePlatform

allowsSizeInProcedureArguments, atan2Operator, buildCallWithReturning, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, canBuildCallWithReturning, exceptOperator, getAssignmentString, getBatchBeginString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getDeclareBeginString, getDropCascadeString, getDropDatabaseSchemaString, getMaxFieldNameSize, getNativeTableInfo, getProcedureArgumentSetter, getProcedureCallHeader, getProcedureCallTail, getSelectForUpdateString, getSelectForUpdateWaitString, getStoredProcedureParameterPrefix, getSystemChangeNumberQuery, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, isAlterSequenceObjectSupported, isForUpdateCompatibleWithDistinct, isLobCompatibleWithDistinct, isLockTimeoutException, isOracle, isRowCountOutputParameterRequired, maximumNumericValues, minimumNumericValues, printFieldNullClause, printSQLSelectStatement, regexpOperator, setSupportsIdentity, shouldPrintStoredProcedureArgumentNameInCall, shouldUseJDBCOuterJoinSyntax, supportsAutoConversionToNumericForArithmeticOperations, supportsIdentity, supportsSelectForUpdateNoWait, supportsSequenceObjects, supportsStoredFunctions, supportsVPD, useJDBCStoredProcedureSyntax, wasFailureCommunicationBased

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

addStructConverter, appendLiteralToCall, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, createArray, createStruct, dontBindUpdateAllQueryUsingTempTables, executeStoredProcedure, getBatchDelimiterString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getDefaultSequenceTableName, getDriverSupportsNVarChar, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getIndexNamePrefix, getInOutputProcedureToken, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJdbcTypeName, getMaxBatchWritingSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getOutputProcedureToken, getPartitioningCallback, getPingSQL, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureEndString, 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, minimumTimeIncrement, printFieldIdentityClause, printFieldNotNullClause, printFieldTypeSize, printFieldUnique, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureBrackets, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTableInIndexDropDDL, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setCursorCode, setDriverName, setDriverSupportsNVarChar, setIsCastRequired, setMaxBatchWritingSize, setPartitioningCallback, setPingSQL, setPrintInnerJoinInWhereClause, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldCacheAllStatements, setShouldCreateIndicesOnForeignKeys, 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, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintForUpdateClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTrimStrings, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsCountDistinctWithMultipleFields, supportsDeleteOnCascade, supportsForeignKeyConstraints, supportsGlobalTempTables, supportsIndexes, supportsIndividualTableLocking, supportsLocalTempTables, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, writeAddColumnClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeInsertIntoTableSql, writeParameterMarker, writeTableCreationSuffix, writeUpdateOriginalFromTempTableSql

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, getConversionManager, getDefaultNativeSequenceToTable, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isPervasive, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, setConversionManager, setDefaultNativeSequenceToTable, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, toString, usesPlatformDefaultSequence

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

NCHAR

public static final java.lang.Class NCHAR

NSTRING

public static final java.lang.Class NSTRING

NCLOB

public static final java.lang.Class NCLOB

XMLTYPE

public static final java.lang.Class XMLTYPE

Constructor Detail

Oracle9Platform

public Oracle9Platform()

Method Detail

copyInto

public void copyInto(Platform platform)

Copy the state into the new platform.

Specified by:

copyInto in interface Platform

Overrides:

copyInto in class Oracle8Platform

getObjectFromResultSet

public java.lang.Object getObjectFromResultSet(java.sql.ResultSet resultSet,
                                               int columnNumber,
                                               int type,
                                               AbstractSession session)
                                        throws java.sql.SQLException

INTERNAL: Get a timestamp value from a result set. Overrides the default behavior to specifically return a timestamp. Added to overcome an issue with the oracle 9.0.1.4 JDBC driver.

Overrides:

getObjectFromResultSet in class OraclePlatform

Throws:

java.sql.SQLException

See Also:

org.eclipse.persistence.oraclespecific.Oracle9Platform

getTIMESTAMPTZFromResultSet

public java.lang.Object getTIMESTAMPTZFromResultSet(java.sql.ResultSet resultSet,
                                                    int columnNumber,
                                                    int type,
                                                    AbstractSession session)
                                             throws java.sql.SQLException

INTERNAL: Get a TIMESTAMPTZ value from a result set.

Throws:

java.sql.SQLException

getTIMESTAMPLTZFromResultSet

public java.lang.Object getTIMESTAMPLTZFromResultSet(java.sql.ResultSet resultSet,
                                                     int columnNumber,
                                                     int type,
                                                     AbstractSession session)
                                              throws java.sql.SQLException

INTERNAL: Get a TIMESTAMPLTZ value from a result set.

Throws:

java.sql.SQLException

shouldUseCustomModifyForCall

public boolean shouldUseCustomModifyForCall(DatabaseField field)

INTERNAL Used by SQLCall.appendModify(..) If the field should be passed to customModifyInDatabaseCall, retun true, otherwise false. Methods shouldCustomModifyInDatabaseCall and customModifyInDatabaseCall should be kept in sync: shouldCustomModifyInDatabaseCall should return true if and only if the field is handled by customModifyInDatabaseCall.

Specified by:

shouldUseCustomModifyForCall in interface Platform

Overrides:

shouldUseCustomModifyForCall in class Oracle8Platform

clone

public java.lang.Object clone()

Specified by:

clone in interface Platform

Overrides:

clone in class DatasourcePlatform

convertObject

public java.lang.Object convertObject(java.lang.Object sourceObject,
                                      java.lang.Class javaClass)
                               throws ConversionException,
                                      DatabaseException

INTERNAL: Allow for conversion from the Oracle type to the Java type.

Specified by:

convertObject in interface CorePlatform<ConversionManager>

Specified by:

convertObject in interface Platform

Overrides:

convertObject in class DatasourcePlatform

javaClass - - the class that the object must be converted to

Returns:

- the newly converted object

Throws:

ConversionException

DatabaseException

initializeConnectionData

public void initializeConnectionData(java.sql.Connection connection)
                              throws java.sql.SQLException

INTERNAL:

Overrides:

initializeConnectionData in class OraclePlatform

Throws:

java.sql.SQLException

clearConnectionData

public void clearConnectionData()

clearOracleConnectionCache

public void clearOracleConnectionCache(java.sql.Connection conn)

INTERNAL: Clears both implicit and explicit caches of OracleConnection

Overrides:

clearOracleConnectionCache in class OraclePlatform

setParameterValueInDatabaseCall

public void setParameterValueInDatabaseCall(java.lang.Object parameter,
                                            java.sql.PreparedStatement statement,
                                            int index,
                                            AbstractSession session)
                                     throws java.sql.SQLException

INTERNAL: Note that index (not index+1) is used in statement.setObject(index, parameter) Binding starts with a 1 not 0, so make sure that index > 0. Treat Calendar separately. Bind Calendar as TIMESTAMPTZ.

Overrides:

setParameterValueInDatabaseCall in class DatabasePlatform

Throws:

java.sql.SQLException

getTimestampFromServer

public java.sql.Timestamp getTimestampFromServer(AbstractSession session,
                                                 java.lang.String sessionName)

INTERNAL: Answer the timestamp from the server. Convert TIMESTAMPTZ to Timestamp

Specified by:

getTimestampFromServer in interface Platform

Overrides:

getTimestampFromServer in class DatasourcePlatform

getTimestampQuery

public ValueReadQuery getTimestampQuery()

INTERNAL: This method returns the query to select the SYSTIMESTAMP as TIMESTAMPTZ from the server for Oracle9i.

Specified by:

getTimestampQuery in interface Platform

Overrides:

getTimestampQuery in class OraclePlatform

serverTimestampString

public java.lang.String serverTimestampString()

INTERNAL: Return the current SYSTIMESTAMP as TIMESTAMPTZ from the server.

Overrides:

serverTimestampString in class OraclePlatform

getLobValueLimits

public int getLobValueLimits()

PUBLIC: Return the BLOB/CLOB value limits on thin driver. The default value is 0. If usesLocatorForLOBWrite is true, locator will be used in case the lob's size is larger than lobValueLimit.

Overrides:

getLobValueLimits in class Oracle8Platform

setLobValueLimits

public void setLobValueLimits(int lobValueLimits)

PUBLIC: Set the BLOB/CLOB value limits on thin driver. The default value is 0. If usesLocatorForLOBWrite is true, locator will be used in case the lob's size is larger than lobValueLimit.

Overrides:

setLobValueLimits in class Oracle8Platform

getCustomModifyValueForCall

public java.lang.Object getCustomModifyValueForCall(Call call,
                                                    java.lang.Object value,
                                                    DatabaseField field,
                                                    boolean shouldBind)

INTERNAL: Used by SQLCall.translate(..) The binding *must* be performed (NCHAR, NSTRING, NCLOB). In these special cases the method returns a wrapper object which knows whether it should be bound or appended and knows how to do that.

Specified by:

getCustomModifyValueForCall in interface Platform

Overrides:

getCustomModifyValueForCall in class Oracle8Platform

getDataTypesConvertedFrom

public java.util.Vector getDataTypesConvertedFrom(java.lang.Class javaClass)

INTERNAL: Return the list of Classes that can be converted to from the passed in javaClass. oracle.sql.TIMESTAMP and NCHAR types are added in some lists.

Overrides:

getDataTypesConvertedFrom in class DatasourcePlatform

Parameters:

javaClass - - the class that is converted from

Returns:

- a vector of classes

getDataTypesConvertedTo

public java.util.Vector getDataTypesConvertedTo(java.lang.Class javaClass)

INTERNAL: Return the list of Classes that can be converted from to the passed in javaClass. A list is added for oracle.sql.TIMESTAMP and NCHAR types.

Overrides:

getDataTypesConvertedTo in class DatasourcePlatform

Parameters:

javaClass - - the class that is converted to

Returns:

- a vector of classes

getJDBCTypeForSetNull

public int getJDBCTypeForSetNull(DatabaseField field)

Return the JDBC type for the given database field to be passed to Statement.setNull The Oracle driver does not like the OPAQUE type so VARCHAR must be used.

Overrides:

getJDBCTypeForSetNull in class DatabasePlatform

getJDBCType

public int getJDBCType(java.lang.Class javaType)

Return the JDBC type for the Java type. The Oracle driver does not like the OPAQUE type so VARCHAR must be used.

Overrides:

getJDBCType in class DatabasePlatform

executeBatch

public int executeBatch(java.sql.Statement statement,
                        boolean isStatementPrepared)
                 throws java.sql.SQLException

INTERNAL: This gets called on each batch statement execution Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).

Overrides:

executeBatch in class DatabasePlatform

Parameters:

isStatementPrepared - - flag is set to true if this statement is prepared

Returns:

- number of rows modified/deleted by this statement

Throws:

java.sql.SQLException

addBatch

public int addBatch(java.sql.PreparedStatement statement)
             throws java.sql.SQLException

INTERNAL: This gets called on each iteration to add parameters to the batch Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking). Is used with parameterized SQL

Overrides:

addBatch in class DatabasePlatform

Returns:

- number of rows modified/deleted by this statement if it was executed (0 if it wasn't)

Throws:

java.sql.SQLException

prepareBatchStatement

public java.sql.Statement prepareBatchStatement(java.sql.Statement statement,
                                                int maxBatchWritingSize)
                                         throws java.sql.SQLException

INTERNAL: Allows setting the batch size on the statement Is used with parameterized SQL, and should only be passed in prepared statements

Overrides:

prepareBatchStatement in class DatabasePlatform

Returns:

- statement to be used for batch writing

Throws:

java.sql.SQLException

isXDBDocument

public boolean isXDBDocument(java.lang.Object obj)

INTERNAL: Indicates whether the passed object is an instance of XDBDocument.

Overrides:

isXDBDocument in class DatabasePlatform

Returns:

boolean

canUnwrapOracleConnection

public boolean canUnwrapOracleConnection()

INTERNAL: Indicates whether this Oracle platform can unwrap Oracle connection.

Overrides:

canUnwrapOracleConnection in class OraclePlatform

unwrapOracleConnection

public java.sql.Connection unwrapOracleConnection(java.sql.Connection connection)

INTERNAL: If can unwrap returns unwrapped Oracle connection, otherwise original connection.

Overrides:

unwrapOracleConnection in class OraclePlatform

isOracle9

public boolean isOracle9()

PUBLIC: Return is this is the Oracle 9 platform.

Specified by:

isOracle9 in interface Platform

Overrides:

isOracle9 in class DatasourcePlatform

createConnectionCustomizer

public ConnectionCustomizer createConnectionCustomizer(Accessor accessor,
                                                       AbstractSession session)

INTERNAL:

Overrides:

createConnectionCustomizer in class DatasourcePlatform

getDriverVersion

public java.lang.String getDriverVersion()

INTERNAL: Return the driver version.

isTimestampInGmt

public boolean isTimestampInGmt()

INTERNAL: Return if timestamps are returned in GMT by the driver.

isLtzTimestampInGmt

public boolean isLtzTimestampInGmt()

INTERNAL: Return if ltz timestamps are returned in GMT by the driver.

shouldTruncateDate

public boolean shouldTruncateDate()

PUBLIC: Indicates whether time component of java.sql.Date should be truncated (hours, minutes, seconds all set to zero) before been passed as a parameter to PreparedStatement. Starting with version 12.1 oracle jdbc Statement.setDate no longer zeroes sql.Date's entire time component (only milliseconds). "true" indicates that the platform truncates days/hours/minutes before passing the date to Statement.setDate method.

setShouldTruncateDate

public void setShouldTruncateDate(boolean shouldTruncateDate)

PUBLIC: Indicates whether time component of java.sql.Date should be truncated (hours, minutes, seconds all set to zero) before been passed as a parameter to PreparedStatement. Starting with version 12.1 oracle jdbc Statement.setDate no longer zeroes sql.Date's entire time component (only milliseconds). Set this flag to true to make the platform to truncate days/hours/minutes before passing the date to Statement.setDate method.

supportsConnectionUserName

public boolean supportsConnectionUserName()

INTERNAL: User name from JDBC connection is stored in initializeConnectionData(Connection).

Overrides:

supportsConnectionUserName in class DatabasePlatform

Returns:

Always returns true

getConnectionUserName

public java.lang.String getConnectionUserName()

INTERNAL: Returns user name retrieved from JDBC connection. initializeConnectionData(Connection) shall be called before this method.

Overrides:

getConnectionUserName in class DatabasePlatform

Returns:

User name retrieved from JDBC connection.