DB2Platform (EclipseLink 2.6.0, API Reference)

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

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, org.eclipse.persistence.internal.core.databaseaccess.CorePlatform<org.eclipse.persistence.internal.helper.ConversionManager>, org.eclipse.persistence.internal.databaseaccess.Platform

Direct Known Subclasses:

DB2MainframePlatform, DerbyPlatform
```
public class DB2Platform
extends DatabasePlatform
```
Purpose: Provides DB2 specific behavior.
Responsibilities:
- Support for schema creation.
- Native SQL for byte[], Date, Time, & Timestamp.
- Support for table qualified names.
- Support for stored procedures.
- Support for temp tables.
- Support for casting.
- Support for database functions.
- Support for identity sequencing.
- Support for SEQUENCE sequencing.
See Also:
Serialized Form
Since:

TOPLink/Java 1.0

Field Summary
- Fields inherited from class org.eclipse.persistence.platform.database.DatabasePlatform
  DEFAULT_VARCHAR_SIZE
- Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  batchWritingMechanism, 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, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldTrimStrings, statementCacheSize, storedProcedureTerminationToken, stringBindingSize, structConverters, supportsAutoCommit, tableCreationSuffix, transactionIsolation, typeConverters, Types_NCLOB, Types_SQLXML, useJDBCStoredProcedureSyntax, useNationalCharacterVarying, useRownumFiltering, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesStreamsForBinding, usesStringBinding
- Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  conversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultNativeSequenceToTable, defaultSequence, endDelimiter, platformOperators, sequences, sequencesLock, startDelimiter, tableQualifier, timestampQuery

Constructor Summary

Constructors
Constructor and Description

DB2Platform()

Constructors
Constructor and Description
`DB2Platform()`

Method Summary

Methods
Modifier and Type	Method and Description
`protected void`	`appendByteArray(byte[] bytes, java.io.Writer writer)` INTERNAL: Append a byte[] in native DB@ format BLOB(hexString) if usesNativeSQL(), otherwise use ODBC format from DatabasePLatform.
`protected void`	`appendCalendar(java.util.Calendar calendar, java.io.Writer writer)` INTERNAL: Append the Timestamp in native format if usesNativeSQL() is true otherwise use ODBC format from DatabasePlatform.
`protected void`	`appendDate(java.sql.Date date, java.io.Writer writer)` INTERNAL: Appends the Date in native format if usesNativeSQL() otherwise use ODBC format from DatabasePlatform.
`protected void`	`appendDB2Calendar(java.util.Calendar calendar, java.io.Writer writer)` Write a timestamp in DB2 specific format (yyyy-mm-dd-hh.mm.ss.ffffff).
`protected void`	`appendDB2Date(java.sql.Date date, java.io.Writer writer)` INTERNAL: Write a timestamp in DB2 specific format (mm/dd/yyyy).
`protected void`	`appendDB2Timestamp(java.sql.Timestamp timestamp, java.io.Writer writer)` INTERNAL: Write a timestamp in DB2 specific format (yyyy-mm-dd-hh.mm.ss.ffffff).
`protected void`	`appendTime(java.sql.Time time, java.io.Writer writer)` INTERNAL: Append the Time in Native format if usesNativeSQL() otherwise use ODBC format from DAtabasePlatform.
`protected void`	`appendTimestamp(java.sql.Timestamp timestamp, java.io.Writer writer)` INTERNAL: Append the Timestamp in native format if usesNativeSQL() is true otherwise use ODBC format from DatabasePlatform.
`protected java.util.Hashtable`	`buildFieldTypes()`
`ValueReadQuery`	`buildSelectQueryForIdentity()` INTERNAL: Build the identity query for native sequencing.
`ValueReadQuery`	`buildSelectQueryForSequenceObject(java.lang.String seqName, java.lang.Integer size)` INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
`boolean`	`dontBindUpdateAllQueryUsingTempTables()` INTERNAL: DB2 has issues with binding with temp table queries.
`protected java.lang.String`	`getCreateTempTableSqlBodyForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)` INTERNAL: DB2 allows LIKE to be used to create temp tables, which avoids having to know the types.
`protected java.lang.String`	`getCreateTempTableSqlPrefix()` INTERNAL: DB2 temp table syntax.
`protected java.lang.String`	`getCreateTempTableSqlSuffix()` INTERNAL: DB2 temp table syntax.
`int`	`getMaxFieldNameSize()` INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.
`int`	`getMaxForeignKeyNameSize()` INTERNAL: returns the maximum number of characters that can be used in a foreign key name on this platform.
`int`	`getMaxUniqueKeyNameSize()` INTERNAL: returns the maximum number of characters that can be used in a unique key name on this platform.
`java.util.Vector`	`getNativeTableInfo(java.lang.String table, java.lang.String creator, org.eclipse.persistence.internal.sessions.AbstractSession session)` INTERNAL: Return the catalog information through using the native SQL catalog selects.
`java.lang.String`	`getProcedureAsString()` INTERNAL: Used for stored procedure defs.
`java.lang.String`	`getProcedureBeginString()` Used for stored procedure defs.
`java.lang.String`	`getProcedureCallHeader()` INTERNAL: Used for sp calls.
`java.lang.String`	`getProcedureEndString()` INTERNAL: Used for stored procedure defs.
`java.lang.String`	`getSelectForUpdateString()` INTERNAL: Used for pessimistic locking in DB2.
`org.eclipse.persistence.internal.helper.DatabaseTable`	`getTempTableForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)` INTERNAL: DB2 temp table syntax.
`ValueReadQuery`	`getTimestampQuery()` INTERNAL: This method returns the query to select the timestamp from the server for DB2.
`void`	`initializeConnectionData(java.sql.Connection connection)`
`protected void`	`initializePlatformOperators()` INTERNAL: Initialize any platform-specific operators
`boolean`	`isAlterSequenceObjectSupported()` INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
`boolean`	`isDB2()`
`boolean`	`isDynamicSQLRequiredForFunctions()` INTERNAL DB2 has some issues with using parameters on certain functions and relations.
`boolean`	`isNullAllowedInSelectClause()` INTERNAL: DB2 does not allow NULL in select clause.
`java.util.Hashtable`	`maximumNumericValues()` INTERNAL: Builds a table of maximum numeric values keyed on java class.
`java.util.Hashtable`	`minimumNumericValues()` INTERNAL: Builds a table of minimum numeric values keyed on java class.
`void`	`printFieldIdentityClause(java.io.Writer writer)` INTERNAL: Append the receiver's field 'identity' constraint clause to a writer.
`protected void`	`printFieldTypeSize(java.io.Writer writer, FieldDefinition field, org.eclipse.persistence.internal.databaseaccess.FieldTypeDefinition ftd)`
`void`	`printSQLSelectStatement(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call, org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer, org.eclipse.persistence.internal.expressions.SQLSelectStatement statement)` INTERNAL: Print the SQL representation of the statement on a stream, storing the fields in the DatabaseCall.
`boolean`	`shouldIgnoreException(java.sql.SQLException exception)` INTERNAL: Allow for the platform to ignore exceptions.
`boolean`	`shouldPrintForUpdateClause()`
`boolean`	`shouldPrintOutputTokenAtStart()` INTERNAL: This is required in the construction of the stored procedures with output parameters.
`boolean`	`shouldUseJDBCOuterJoinSyntax()` INTERNAL: JDBC defines and outer join syntax, many drivers do not support this.
`boolean`	`supportsGlobalTempTables()` INTERNAL: DB2 supports temp tables.
`boolean`	`supportsIdentity()` INTERNAL: Indicates whether the platform supports identity.
`boolean`	`supportsLockingQueriesWithMultipleTables()` INTERNAL: DB2 does not seem to allow FOR UPDATE on queries with multiple tables.
`boolean`	`supportsSequenceObjects()` INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
`void`	`writeParameterMarker(java.io.Writer writer, org.eclipse.persistence.internal.expressions.ParameterExpression parameter, org.eclipse.persistence.internal.sessions.AbstractRecord record, org.eclipse.persistence.internal.databaseaccess.DatabaseCall call)` INTERNAL: DB2 requires casting on certain operations, such as the CONCAT function, and parameterized queries of the form, ":param = :param".

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendBoolean, appendLiteralToCall, appendLiteralToCallWithBinding, appendNumber, appendParameter, appendParameterInternal, appendString, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildClassTypes, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, copyInto, createArray, createArray, createPlatformDefaultSequence, createStruct, createStruct, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getDriverSupportsNVarChar, getDropCascadeString, getDropDatabaseSchemaString, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getIndexNamePrefix, getInOutputProcedureToken, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxIndexNameSize, getNoWaitString, getObjectFromResultSet, getOutputProcedureToken, getPartitioningCallback, getPingSQL, getProcedureArgumentSetter, getProcedureArgumentString, getProcedureCallTail, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getUseNationalCharacterVaryingTypeForString, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, isCastRequired, isForUpdateCompatibleWithDistinct, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isOutputAllowWithResultSet, isRowCountOutputParameterRequired, isXDBDocument, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printFieldUnique, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureBrackets, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTableInIndexDropDDL, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setClassTypes, setCursorCode, setDriverName, setDriverSupportsNVarChar, setFieldTypes, setIsCastRequired, setMaxBatchWritingSize, setNullFromDatabaseField, setParameterValueInDatabaseCall, 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, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureArgumentNameInCall, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsCountDistinctWithMultipleFields, supportsDeleteOnCascade, supportsForeignKeyConstraints, supportsIndexes, supportsIndividualTableLocking, supportsLocalTempTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsStoredFunctions, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, supportsVPD, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, wasFailureCommunicationBased, writeAddColumnClause, writeAutoAssignmentSetClause, writeAutoJoinWhereClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeFields, writeFieldsAutoClause, writeFieldsList, writeInsertIntoTableSql, writeJoinWhereClause, writeLOB, writeTableCreationSuffix, writeUpdateOriginalFromTempTableSql

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
addOperator, addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultNativeSequenceToTable, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, isAccess, isAttunity, isCloudscape, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle9, isPervasive, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, sequencesAfterCloneCleanup, 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, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - DB2Platform
```
public DB2Platform()
```
- Method Detail
  - initializeConnectionData
```
public void initializeConnectionData(java.sql.Connection connection)
                              throws java.sql.SQLException
```
    Overrides:
    
    initializeConnectionData in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.sql.SQLException
  - appendByteArray
```
protected void appendByteArray(byte[] bytes,
                   java.io.Writer writer)
                        throws java.io.IOException
```
    INTERNAL: Append a byte[] in native DB@ format BLOB(hexString) if usesNativeSQL(), otherwise use ODBC format from DatabasePLatform.
    
    Overrides:
    
    appendByteArray in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - appendDate
```
protected void appendDate(java.sql.Date date,
              java.io.Writer writer)
                   throws java.io.IOException
```
    INTERNAL: Appends the Date in native format if usesNativeSQL() otherwise use ODBC format from DatabasePlatform. Native format: 'mm/dd/yyyy'
    
    Overrides:
    
    appendDate in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - appendDB2Date
```
protected void appendDB2Date(java.sql.Date date,
                 java.io.Writer writer)
                      throws java.io.IOException
```
    INTERNAL: Write a timestamp in DB2 specific format (mm/dd/yyyy).
    
    Throws:
    
    java.io.IOException
  - appendDB2Timestamp
```
protected void appendDB2Timestamp(java.sql.Timestamp timestamp,
                      java.io.Writer writer)
                           throws java.io.IOException
```
    INTERNAL: Write a timestamp in DB2 specific format (yyyy-mm-dd-hh.mm.ss.ffffff).
    
    Throws:
    
    java.io.IOException
  - appendDB2Calendar
```
protected void appendDB2Calendar(java.util.Calendar calendar,
                     java.io.Writer writer)
                          throws java.io.IOException
```
    Write a timestamp in DB2 specific format (yyyy-mm-dd-hh.mm.ss.ffffff).
    
    Throws:
    
    java.io.IOException
  - appendTime
```
protected void appendTime(java.sql.Time time,
              java.io.Writer writer)
                   throws java.io.IOException
```
    INTERNAL: Append the Time in Native format if usesNativeSQL() otherwise use ODBC format from DAtabasePlatform. Native Format: 'hh:mm:ss'
    
    Overrides:
    
    appendTime in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - appendTimestamp
```
protected void appendTimestamp(java.sql.Timestamp timestamp,
                   java.io.Writer writer)
                        throws java.io.IOException
```
    INTERNAL: Append the Timestamp in native format if usesNativeSQL() is true otherwise use ODBC format from DatabasePlatform. Native format: 'YYYY-MM-DD-hh.mm.ss.SSSSSS'
    
    Overrides:
    
    appendTimestamp in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - appendCalendar
```
protected void appendCalendar(java.util.Calendar calendar,
                  java.io.Writer writer)
                       throws java.io.IOException
```
    INTERNAL: Append the Timestamp in native format if usesNativeSQL() is true otherwise use ODBC format from DatabasePlatform. Native format: 'YYYY-MM-DD-hh.mm.ss.SSSSSS'
    
    Overrides:
    
    appendCalendar in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - buildFieldTypes
```
protected java.util.Hashtable buildFieldTypes()
```
    Overrides:
    
    buildFieldTypes in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getMaxFieldNameSize
```
public int getMaxFieldNameSize()
```
    INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.
    
    Overrides:
    
    getMaxFieldNameSize in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getMaxForeignKeyNameSize
```
public int getMaxForeignKeyNameSize()
```
    INTERNAL: returns the maximum number of characters that can be used in a foreign key name on this platform.
    
    Overrides:
    
    getMaxForeignKeyNameSize in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getMaxUniqueKeyNameSize
```
public int getMaxUniqueKeyNameSize()
```
    INTERNAL: returns the maximum number of characters that can be used in a unique key name on this platform.
    
    Overrides:
    
    getMaxUniqueKeyNameSize in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getNativeTableInfo
```
public java.util.Vector getNativeTableInfo(java.lang.String table,
                                  java.lang.String creator,
                                  org.eclipse.persistence.internal.sessions.AbstractSession session)
```
    INTERNAL: Return the catalog information through using the native SQL catalog selects. This is required because many JDBC driver do not support meta-data. Wildcards can be passed as arguments. This is currently not used.
  - getProcedureCallHeader
```
public java.lang.String getProcedureCallHeader()
```
    INTERNAL: Used for sp calls.
    
    Overrides:
    
    getProcedureCallHeader in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getSelectForUpdateString
```
public java.lang.String getSelectForUpdateString()
```
    INTERNAL: Used for pessimistic locking in DB2. Without the "WITH RS" the lock is not held.
    
    Overrides:
    
    getSelectForUpdateString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureEndString
```
public java.lang.String getProcedureEndString()
```
    INTERNAL: Used for stored procedure defs.
    
    Overrides:
    
    getProcedureEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureBeginString
```
public java.lang.String getProcedureBeginString()
```
    Used for stored procedure defs.
    
    Overrides:
    
    getProcedureBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getProcedureAsString
```
public java.lang.String getProcedureAsString()
```
    INTERNAL: Used for stored procedure defs.
    
    Overrides:
    
    getProcedureAsString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldPrintOutputTokenAtStart
```
public boolean shouldPrintOutputTokenAtStart()
```
    INTERNAL: This is required in the construction of the stored procedures with output parameters.
    
    Overrides:
    
    shouldPrintOutputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getTimestampQuery
```
public ValueReadQuery getTimestampQuery()
```
    INTERNAL: This method returns the query to select the timestamp from the server for DB2.
    
    Specified by:
    
    getTimestampQuery in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    getTimestampQuery in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - initializePlatformOperators
```
protected void initializePlatformOperators()
```
    INTERNAL: Initialize any platform-specific operators
    
    Overrides:
    
    initializePlatformOperators in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - isDB2
```
public boolean isDB2()
```
    Specified by:
    
    isDB2 in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    isDB2 in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - maximumNumericValues
```
public java.util.Hashtable maximumNumericValues()
```
    INTERNAL: Builds a table of maximum numeric values keyed on java class. This is used for type testing but might also be useful to end users attempting to sanitize values.
    NOTE: BigInteger & BigDecimal maximums are dependent upon their precision & Scale
    
    Overrides:
    
    maximumNumericValues in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - minimumNumericValues
```
public java.util.Hashtable minimumNumericValues()
```
    INTERNAL: Builds a table of minimum numeric values keyed on java class. This is used for type testing but might also be useful to end users attempting to sanitize values.
    NOTE: BigInteger & BigDecimal minimums are dependent upon their precision & Scale
    
    Overrides:
    
    minimumNumericValues in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldIgnoreException
```
public boolean shouldIgnoreException(java.sql.SQLException exception)
```
    INTERNAL: Allow for the platform to ignore exceptions. This is required for DB2 which throws no-data modified as an exception.
    
    Overrides:
    
    shouldIgnoreException in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldUseJDBCOuterJoinSyntax
```
public boolean shouldUseJDBCOuterJoinSyntax()
```
    INTERNAL: JDBC defines and outer join syntax, many drivers do not support this. So we normally avoid it.
    
    Overrides:
    
    shouldUseJDBCOuterJoinSyntax in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - buildSelectQueryForIdentity
```
public ValueReadQuery buildSelectQueryForIdentity()
```
    INTERNAL: Build the identity query for native sequencing.
    
    Overrides:
    
    buildSelectQueryForIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - printFieldIdentityClause
```
public void printFieldIdentityClause(java.io.Writer writer)
                              throws ValidationException
```
    INTERNAL: Append the receiver's field 'identity' constraint clause to a writer. Used by table creation with sequencing.
    
    Overrides:
    
    printFieldIdentityClause in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    ValidationException
  - printFieldTypeSize
```
protected void printFieldTypeSize(java.io.Writer writer,
                      FieldDefinition field,
                      org.eclipse.persistence.internal.databaseaccess.FieldTypeDefinition ftd)
                           throws java.io.IOException
```
    Overrides:
    
    printFieldTypeSize in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - supportsIdentity
```
public boolean supportsIdentity()
```
    INTERNAL: Indicates whether the platform supports identity. DB2 does through AS IDENTITY field types. This is used by sequencing.
    
    Overrides:
    
    supportsIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - supportsGlobalTempTables
```
public boolean supportsGlobalTempTables()
```
    INTERNAL: DB2 supports temp tables. This is used by UpdateAllQuerys.
    
    Overrides:
    
    supportsGlobalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getCreateTempTableSqlPrefix
```
protected java.lang.String getCreateTempTableSqlPrefix()
```
    INTERNAL: DB2 temp table syntax. This is used by UpdateAllQuerys.
    
    Overrides:
    
    getCreateTempTableSqlPrefix in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getTempTableForTable
```
public org.eclipse.persistence.internal.helper.DatabaseTable getTempTableForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)
```
    INTERNAL: DB2 temp table syntax. This is used by UpdateAllQuerys.
    
    Overrides:
    
    getTempTableForTable in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getCreateTempTableSqlSuffix
```
protected java.lang.String getCreateTempTableSqlSuffix()
```
    INTERNAL: DB2 temp table syntax. This is used by UpdateAllQuerys.
    
    Overrides:
    
    getCreateTempTableSqlSuffix in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getCreateTempTableSqlBodyForTable
```
protected java.lang.String getCreateTempTableSqlBodyForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)
```
    INTERNAL: DB2 allows LIKE to be used to create temp tables, which avoids having to know the types. This is used by UpdateAllQuerys.
    
    Overrides:
    
    getCreateTempTableSqlBodyForTable in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - dontBindUpdateAllQueryUsingTempTables
```
public boolean dontBindUpdateAllQueryUsingTempTables()
```
    INTERNAL: DB2 has issues with binding with temp table queries. This is used by UpdateAllQuerys.
    
    Overrides:
    
    dontBindUpdateAllQueryUsingTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - isNullAllowedInSelectClause
```
public boolean isNullAllowedInSelectClause()
```
    INTERNAL: DB2 does not allow NULL in select clause. This is used by UpdateAllQuerys.
    
    Overrides:
    
    isNullAllowedInSelectClause in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - isDynamicSQLRequiredForFunctions
```
public boolean isDynamicSQLRequiredForFunctions()
```
    INTERNAL DB2 has some issues with using parameters on certain functions and relations. This allows statements to disable binding only in these cases. If users set casting on, then casting is used instead of dynamic SQL.
    
    Overrides:
    
    isDynamicSQLRequiredForFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - writeParameterMarker
```
public void writeParameterMarker(java.io.Writer writer,
                        org.eclipse.persistence.internal.expressions.ParameterExpression parameter,
                        org.eclipse.persistence.internal.sessions.AbstractRecord record,
                        org.eclipse.persistence.internal.databaseaccess.DatabaseCall call)
                          throws java.io.IOException
```
    INTERNAL: DB2 requires casting on certain operations, such as the CONCAT function, and parameterized queries of the form, ":param = :param". This method will write CAST operation to parameters if the type is known. This is not used by default, only if isCastRequired is set to true, by default dynamic SQL is used to avoid the issue in only the required cases.
    
    Overrides:
    
    writeParameterMarker in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    java.io.IOException
  - supportsLockingQueriesWithMultipleTables
```
public boolean supportsLockingQueriesWithMultipleTables()
```
    INTERNAL: DB2 does not seem to allow FOR UPDATE on queries with multiple tables. This is only used by testing to exclude these tests.
    
    Overrides:
    
    supportsLockingQueriesWithMultipleTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - buildSelectQueryForSequenceObject
```
public ValueReadQuery buildSelectQueryForSequenceObject(java.lang.String seqName,
                                               java.lang.Integer size)
```
    INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
    
    Overrides:
    
    buildSelectQueryForSequenceObject in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - supportsSequenceObjects
```
public boolean supportsSequenceObjects()
```
    INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
    
    Overrides:
    
    supportsSequenceObjects in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - isAlterSequenceObjectSupported
```
public boolean isAlterSequenceObjectSupported()
```
    INTERNAL: DB2 added SEQUENCE support as of (I believe) v8.
    
    Overrides:
    
    isAlterSequenceObjectSupported in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - shouldPrintForUpdateClause
```
public boolean shouldPrintForUpdateClause()
```
    Overrides:
    
    shouldPrintForUpdateClause in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - printSQLSelectStatement
```
public void printSQLSelectStatement(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call,
                           org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer,
                           org.eclipse.persistence.internal.expressions.SQLSelectStatement statement)
```
    INTERNAL: Print the SQL representation of the statement on a stream, storing the fields in the DatabaseCall. This implementation works MaxRows and FirstResult into the SQL using DB2's ROWNUMBER() OVER() to filter values if shouldUseRownumFiltering is true.
    
    Overrides:
    
    printSQLSelectStatement in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

Class DB2Platform

Field Summary

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

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

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

Constructor Summary

Method Summary

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

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

Methods inherited from class java.lang.Object

Constructor Detail

DB2Platform

Method Detail

initializeConnectionData

appendByteArray

appendDate

appendDB2Date

appendDB2Timestamp

appendDB2Calendar

appendTime

appendTimestamp

appendCalendar

buildFieldTypes

getMaxFieldNameSize

getMaxForeignKeyNameSize

getMaxUniqueKeyNameSize

getNativeTableInfo

getProcedureCallHeader

getSelectForUpdateString

getProcedureEndString

getProcedureBeginString

getProcedureAsString

shouldPrintOutputTokenAtStart

getTimestampQuery

initializePlatformOperators

isDB2

maximumNumericValues

minimumNumericValues

shouldIgnoreException

shouldUseJDBCOuterJoinSyntax

buildSelectQueryForIdentity

printFieldIdentityClause

printFieldTypeSize

supportsIdentity

supportsGlobalTempTables

getCreateTempTableSqlPrefix

getTempTableForTable

getCreateTempTableSqlSuffix

getCreateTempTableSqlBodyForTable

dontBindUpdateAllQueryUsingTempTables

isNullAllowedInSelectClause

isDynamicSQLRequiredForFunctions

writeParameterMarker

supportsLockingQueriesWithMultipleTables

buildSelectQueryForSequenceObject

supportsSequenceObjects

isAlterSequenceObjectSupported

shouldPrintForUpdateClause

printSQLSelectStatement