H2Platform

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

All Implemented Interfaces:

Serializable, Cloneable, org.eclipse.persistence.internal.core.databaseaccess.CorePlatform<org.eclipse.persistence.internal.helper.ConversionManager>, org.eclipse.persistence.internal.databaseaccess.Platform
```
public class H2Platform
extends DatabasePlatform
```
See Also:

Serialized Form

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
  DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, IS_VALID_TIMEOUT, Types_NCLOB, Types_SQLXML

Constructor Summary

Constructors
Constructor and Description

H2Platform()

Constructors
Constructor and Description
`H2Platform()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`ValueReadQuery`	`buildSelectQueryForIdentity()` INTERNAL: Returns query used to read back the value generated by Identity.
`ValueReadQuery`	`buildSelectQueryForSequenceObject(String seqName, Integer size)` INTERNAL: Returns query used to read value generated by sequence object (like Oracle sequence).
`int`	`computeMaxRowsForSQL(int firstResultIndex, int maxResults)` INTERNAL: Use the JDBC maxResults and firstResultIndex setting to compute a value to use when limiting the results of a query in SQL.
`ValueReadQuery`	`getTimestampQuery()` This method can be overridden by subclasses to return a query that will return the timestamp from the server.
`boolean`	`isAlterSequenceObjectSupported()` INTERNAL: Override this method if the platform supports sequence objects and it's possible to alter sequence object's increment in the database.
`boolean`	`isDynamicSQLRequiredForFunctions()` INTERNAL H2 has some issues with using parameters on certain functions and relations.
`boolean`	`isH2()`
`static ExpressionOperator`	`monthsBetweenOperator()` INTERNAL: Use MONTH function for MONTH_BETWEEN.
`void`	`printFieldIdentityClause(Writer writer)` Append the receiver's field 'identity' constraint clause to a writer.
`void`	`printSQLSelectStatement(org.eclipse.persistence.internal.databaseaccess.DatabaseCall call, org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer, org.eclipse.persistence.internal.expressions.SQLSelectStatement statement)` Print the pagination SQL using H2 syntax " LIMIT OFFSET ".
`boolean`	`supportsForeignKeyConstraints()`
`boolean`	`supportsGlobalTempTables()` INTERNAL: Indicates whether the platform supports global temporary tables.
`boolean`	`supportsIdentity()` INTERNAL: Indicates whether the platform supports identity.
`boolean`	`supportsSequenceObjects()` INTERNAL: Indicates whether the platform supports sequence objects.
`boolean`	`supportsStoredFunctions()`
`static ExpressionOperator`	`toNumberOperator()` INTERNAL: Use CONVERT function for toNumber.
`void`	`writeUpdateOriginalFromTempTableSql(Writer writer, org.eclipse.persistence.internal.helper.DatabaseTable table, Collection pkFields, Collection assignedFields)` H2 does not allow using () in the update if only one field.

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendLiteralToCall, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, commitTransaction, convertToDatabaseType, copyInto, createArray, createArray, createStruct, createStruct, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getDropCascadeString, getDropDatabaseSchemaString, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getIndexNamePrefix, getInOutputProcedureToken, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxFieldNameSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getOutputProcedureToken, getPartitioningCallback, getPingSQL, getProcedureArgumentSetter, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureCallHeader, getProcedureCallTail, getProcedureEndString, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTempTableForTable, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, initializeConnectionData, isCastRequired, isForUpdateCompatibleWithDistinct, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isNullAllowedInSelectClause, isOutputAllowWithResultSet, isRowCountOutputParameterRequired, isXDBDocument, maximumNumericValues, minimumNumericValues, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureBrackets, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTableInIndexDropDDL, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setCursorCode, setDriverName, setIsCastRequired, setMaxBatchWritingSize, setParameterValueInDatabaseCall, setPartitioningCallback, setPingSQL, setPrintInnerJoinInWhereClause, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldCacheAllStatements, setShouldCreateIndicesOnForeignKeys, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setShouldUseRownumFiltering, setStatementCacheSize, setStringBindingSize, setSupportsAutoCommit, setTableCreationSuffix, setTransactionIsolation, setUseJDBCStoredProcedureSyntax, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldAlwaysUseTempStorageForModifyAll, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldCreateIndicesForPrimaryKeys, shouldCreateIndicesOnForeignKeys, shouldCreateIndicesOnUniqueKeys, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureArgumentNameInCall, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseJDBCOuterJoinSyntax, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsCountDistinctWithMultipleFields, supportsDeleteOnCascade, supportsIndexes, supportsIndividualTableLocking, supportsLocalTempTables, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, supportsVPD, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, wasFailureCommunicationBased, writeAddColumnClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeInsertIntoTableSql, writeLOB, writeParameterMarker, writeTableCreationSuffix

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
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, isDB2, isDBase, isDerby, isFirebird, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle9, 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

- Constructor Detail
  - H2Platform
```
public H2Platform()
```
- Method Detail
  - 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)
```
    Print the pagination SQL using H2 syntax " LIMIT OFFSET ".
    
    Overrides:
    
    printSQLSelectStatement in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - computeMaxRowsForSQL
```
public int computeMaxRowsForSQL(int firstResultIndex,
                                int maxResults)
```
    INTERNAL: Use the JDBC maxResults and firstResultIndex setting to compute a value to use when limiting the results of a query in SQL. These limits tend to be used in two ways. 1. MaxRows is the index of the last row to be returned (like JDBC maxResults) 2. MaxRows is the number of rows to be returned H2 uses case #2 and therefore the maxResults has to be altered based on the firstResultIndex.
    
    Overrides:
    
    computeMaxRowsForSQL in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    See Also:
    
    MySQLPlatform
  - isAlterSequenceObjectSupported
```
public boolean isAlterSequenceObjectSupported()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    INTERNAL: Override this method if the platform supports sequence objects and it's possible to alter sequence object's increment in the database.
    
    Overrides:
    
    isAlterSequenceObjectSupported in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - isDynamicSQLRequiredForFunctions
```
public boolean isDynamicSQLRequiredForFunctions()
```
    INTERNAL H2 has some issues with using parameters on certain functions and relations. This allows statements to disable binding only in these cases.
    
    Overrides:
    
    isDynamicSQLRequiredForFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - buildSelectQueryForSequenceObject
```
public ValueReadQuery buildSelectQueryForSequenceObject(String seqName,
                                                        Integer size)
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
    
    INTERNAL: Returns query used to read value generated by sequence object (like Oracle sequence). In case the other version of this method (taking no parameters) returns null, this method is called every time sequence object NativeSequence reads. If the platform supportsSequenceObjects then (at least) one of buildSelectQueryForSequenceObject methods should return non-null query.
    
    Overrides:
    
    buildSelectQueryForSequenceObject in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - supportsIdentity
```
public boolean supportsIdentity()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
    
    INTERNAL: Indicates whether the platform supports identity. This method is to be used *ONLY* by sequencing classes
    
    Overrides:
    
    supportsIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - supportsSequenceObjects
```
public boolean supportsSequenceObjects()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
    
    INTERNAL: Indicates whether the platform supports sequence objects. This method is to be used *ONLY* by sequencing classes
    
    Overrides:
    
    supportsSequenceObjects in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - buildSelectQueryForIdentity
```
public ValueReadQuery buildSelectQueryForIdentity()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
    
    INTERNAL: Returns query used to read back the value generated by Identity. This method is called when identity NativeSequence is connected, the returned query used until the sequence is disconnected. If the platform supportsIdentity then (at least) one of buildSelectQueryForIdentity methods should return non-null query.
    
    Overrides:
    
    buildSelectQueryForIdentity in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - printFieldIdentityClause
```
public void printFieldIdentityClause(Writer writer)
                              throws ValidationException
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Append the receiver's field 'identity' constraint clause to a writer.
    
    Overrides:
    
    printFieldIdentityClause in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    ValidationException
  - supportsForeignKeyConstraints
```
public boolean supportsForeignKeyConstraints()
```
    Overrides:
    
    supportsForeignKeyConstraints in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - supportsGlobalTempTables
```
public boolean supportsGlobalTempTables()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    INTERNAL: Indicates whether the platform supports global temporary tables. "Global" means that an attempt to create temporary table with the same name for the second time results in exception. EclipseLink attempts to create global temporary table in the beginning of UpdateAllQuery, execution and assumes that it already exists in case SQLException results. In the end of UpdateAllQuery execution all rows are removed from the temporary table - it is necessary in case the same temporary table will be used by another UpdateAllQuery in the same transaction. Override this method if the platform supports global temporary tables. Note that this method is ignored in case supportsLocalTempTables() returns true.
    
    Overrides:
    
    supportsGlobalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - writeUpdateOriginalFromTempTableSql
```
public void writeUpdateOriginalFromTempTableSql(Writer writer,
                                                org.eclipse.persistence.internal.helper.DatabaseTable table,
                                                Collection pkFields,
                                                Collection assignedFields)
                                         throws IOException
```
    H2 does not allow using () in the update if only one field.
    
    Overrides:
    
    writeUpdateOriginalFromTempTableSql in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
    
    Throws:
    
    IOException
  - supportsStoredFunctions
```
public boolean supportsStoredFunctions()
```
    Overrides:
    
    supportsStoredFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
  - getTimestampQuery
```
public ValueReadQuery getTimestampQuery()
```
    Description copied from class: org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
    
    This method can be overridden by subclasses to return a query that will return the timestamp from the server. return null if the time should be the local time.
    
    Specified by:
    
    getTimestampQuery in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    getTimestampQuery in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
  - toNumberOperator
```
public static ExpressionOperator toNumberOperator()
```
    INTERNAL: Use CONVERT function for toNumber.
  - monthsBetweenOperator
```
public static ExpressionOperator monthsBetweenOperator()
```
    INTERNAL: Use MONTH function for MONTH_BETWEEN.
  - isH2
```
public boolean isH2()
```
    Specified by:
    
    isH2 in interface org.eclipse.persistence.internal.databaseaccess.Platform
    
    Overrides:
    
    isH2 in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

Class H2Platform

Field Summary

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

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

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

H2Platform

Method Detail

printSQLSelectStatement

computeMaxRowsForSQL

isAlterSequenceObjectSupported

isDynamicSQLRequiredForFunctions

buildSelectQueryForSequenceObject

supportsIdentity

supportsSequenceObjects

buildSelectQueryForIdentity

printFieldIdentityClause

supportsForeignKeyConstraints

supportsGlobalTempTables

writeUpdateOriginalFromTempTableSql

supportsStoredFunctions

getTimestampQuery

toNumberOperator

monthsBetweenOperator

isH2