Package org.eclipse.persistence.platform.database

Class PervasivePlatform

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

All Implemented Interfaces:

Serializable, Cloneable, CorePlatform<ConversionManager>, Platform

public class PervasivePlatform
extends DatabasePlatform

Purpose: Provides Pervasive SQL DBMS specific behavior.

Pervasive SQL Platform file
Contributed by: Pervasive Software, Inc.
Contributed under bug: 392109

Developed on Pervasive PSQL Server 11.30

• Eclipselink Core SRG Test passes with known limitations.
• Eclipselink JPA SRG Test passes with known limitations.
• Eclipselink stored procedure tests "CustomSQLTestModel", "StoredProcedureGeneratorModel" pass with known limitations.

Limitations

• Updates are not supported on joined queries or queries with group by.
• The platform method getSelectForUpdateString() currently returns an empty string. This is to avoid avoid joined queries with FOR UPDATE in them, which Pervasive does not support.
• Columns used in indexes must total no more than 255 bytes in length.
• Pervasive SQL does not support dynamic parameters in the SELECT list.
• IDENTITY columns are either 2- or 4-byte integers. Foreign keys referencing such columns must use the same datatypes.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static int	DEFAULT_CHAR_SIZE

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, shouldForceBindAllParameters, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldTrimStrings, statementCacheSize, storedProcedureTerminationToken, stringBindingSize, structConverters, supportsAutoCommit, tableCreationSuffix, transactionIsolation, typeConverters, useJDBCStoredProcedureSyntax, useNationalCharacterVarying, useRownumFiltering, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesStreamsForBinding, usesStringBinding

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

conversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultNativeSequenceToTable, defaultSeqenceAtNextValue, defaultSequence, endDelimiter, platformOperators, sequences, sequencesLock, startDelimiter, tableQualifier, timestampQuery

Constructor Summary

Constructors

Constructor	Description
PervasivePlatform()

Method Summary

Modifier and Type	Method	Description
protected Map<String,Class>	buildClassTypes()	Return the mapping of class types to database types for the schema framework.
protected Hashtable	buildFieldTypes()	Return the mapping of class types to database types for the schema framework.
ValueReadQuery	buildSelectQueryForIdentity()	INTERNAL: Build the identity query for native sequencing.
protected ExpressionOperator	dateToStringOperator()	Cloned from MySQLPlatform.java
protected String	getCreateTempTableSqlPrefix()	INTERNAL:
String	getInOutputProcedureToken()	Pervasive uses the INOUT keyword, as opposed to "IN OUT".
String	getInputProcedureToken()	Pervasive uses IN prefix for INPUT parameters.
String	getProcedureArgumentString()	Pervasive uses ":" as prefix for procedure arguments.
String	getProcedureBeginString()	Pervasive requires BEGIN in a procedure statement.
String	getProcedureCallHeader()	Pervasive uses CALL or EXECUTE not CALL PROCEDURE or EXECUTE PROCEDURE
String	getProcedureEndString()	Pervasive requires END in a procedure statement.
String	getSelectForUpdateString()	Temporary workaround to avoid joined queries with FOR UPDATE in them
String	getStoredProcedureParameterPrefix()	Pervasive uses ":" as prefix for procedure parameters.
DatabaseTable	getTempTableForTable(DatabaseTable table)	INTERNAL:
protected void	initializePlatformOperators()	Initialize any platform-specific operators
boolean	isForUpdateCompatibleWithDistinct()	INTERNAL: Indicates whether SELECT DISTINCT ...
boolean	isPervasive()	Answers whether platform is Pervasive
void	printFieldIdentityClause(Writer writer)	Append the receiver's field 'identity' constraint clause to a writer.
void	printFieldTypeSize(Writer writer, FieldDefinition field, FieldTypeDefinition fieldType, boolean shouldPrintFieldIdentityClause)	Taken from org.eclipse.persistence\foundation\org.eclipse.persistence.core\src\org\eclipse\persistence\platform\database\AccessPlatform.java
boolean	requiresProcedureBrackets()	In CREATE PROCEDURE, Pervasive requires brackets after the procedure name, even if there are no arguments.
boolean	requiresProcedureCallOuputToken()	Pervasive requires the OUTPUT keyword for output parameters
boolean	shouldPrintLockingClauseAfterWhereClause()	Attempts to remove FOR UPDATE from queries
boolean	shouldPrintStoredProcedureArgumentNameInCall()	INTERNAL: Pervasive SQL stored procedure calls do not require the argument name be printed in the call string e.g.
boolean	shouldUseJDBCOuterJoinSyntax()	JDBC defines an outer join syntax which many drivers do not support.
ExpressionOperator	singleArgumentSubstringOperator()	Override the default SubstringSingleArg operator.
boolean	supportsDeleteOnCascade()	Setting this to false (cf.
boolean	supportsGlobalTempTables()	INTERNAL: Indicates whether the platform supports global temporary tables.
boolean	supportsIdentity()	Indicates whether the platform supports identity.
boolean	supportsLocalTempTables()	INTERNAL:
boolean	supportsLockingQueriesWithMultipleTables()	INTERNAL: Indicates whether locking clause could be applied to the query that has more than one table
protected ExpressionOperator	toCharOperator()	Cloned from MySQLPlatform.java
protected ExpressionOperator	toDateOperator()	Cloned from MySQLPlatform.java
protected ExpressionOperator	toNumberOperator()

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

addBatch, addStructConverter, allowsSizeInProcedureArguments, appendBoolean, appendByteArray, appendCalendar, appendDate, appendLiteralToCall, appendLiteralToCallWithBinding, appendNumber, appendParameter, appendParameterInternal, appendString, appendTime, appendTimestamp, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, checkTableExists, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, copyInto, createArray, createArray, createPlatformDefaultSequence, createStruct, createStruct, createStruct, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConnectionUserName, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateTempTableSqlBodyForTable, getCreateTempTableSqlSuffix, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getDriverSupportsNVarChar, getDropCascadeString, getDropDatabaseSchemaString, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIndexNamePrefix, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxFieldNameSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getOutputProcedureToken, getParameterValueFromDatabaseCall, getParameterValueFromDatabaseCall, getPartitioningCallback, getPingSQL, getProcedureArgument, getProcedureAsString, getProcedureCallTail, getProcedureOptionList, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTableExistsQuery, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getUseNationalCharacterVaryingTypeForString, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, initializeConnectionData, isAlterSequenceObjectSupported, isCastRequired, isDynamicSQLRequiredForFunctions, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isNullAllowedInSelectClause, isOutputAllowWithResultSet, isRowCountOutputParameterRequired, isXDBDocument, maximumNumericValues, minimumNumericValues, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printFieldUnique, printSQLSelectStatement, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, registerOutputParameter, registerOutputParameter, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureCallBrackets, 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, shouldPrintForUpdateClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsConnectionUserName, supportsCountDistinctWithMultipleFields, supportsForeignKeyConstraints, supportsIndexes, supportsIndividualTableLocking, supportsNestingOuterJoins, supportsOrderByParameters, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsStoredFunctions, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, supportsVPD, supportsWaitForUpdate, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, wasFailureCommunicationBased, writeAddColumnClause, writeAutoAssignmentSetClause, writeAutoJoinWhereClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeFields, writeFieldsAutoClause, writeFieldsList, writeInsertIntoTableSql, writeJoinWhereClause, writeLOB, writeParameterMarker, writeTableCreationSuffix, writeUpdateOriginalFromTempTableSql

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

addOperator, addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, createExpressionFor, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultNativeSequenceToTable, getDefaultSeqenceAtNextValue, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getINClauseLimit, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getTimestampQuery, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, initIdentitySequences, isAccess, isAttunity, isCloudscape, isDB2, isDB2Z, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle12, isOracle9, 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, supportsSequenceObjects, toString, usesPlatformDefaultSequence

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_CHAR_SIZE

public static final int DEFAULT_CHAR_SIZE

See Also:

Constant Field Values

Constructor Detail

PervasivePlatform

public PervasivePlatform()

Method Detail

buildClassTypes

protected Map<String,Class> buildClassTypes()

Description copied from class: DatabasePlatform

Return the mapping of class types to database types for the schema framework.

Overrides:

buildClassTypes in class DatabasePlatform

buildFieldTypes

protected Hashtable buildFieldTypes()

Description copied from class: DatabasePlatform

Return the mapping of class types to database types for the schema framework.

Overrides:

buildFieldTypes in class DatabasePlatform

getInOutputProcedureToken

public String getInOutputProcedureToken()

Pervasive uses the INOUT keyword, as opposed to "IN OUT".

Overrides:

getInOutputProcedureToken in class DatabasePlatform

getInputProcedureToken

public String getInputProcedureToken()

Pervasive uses IN prefix for INPUT parameters.

Overrides:

getInputProcedureToken in class DatabasePlatform

getProcedureArgumentString

public String getProcedureArgumentString()

Pervasive uses ":" as prefix for procedure arguments.

Overrides:

getProcedureArgumentString in class DatabasePlatform

getProcedureBeginString

public String getProcedureBeginString()

Pervasive requires BEGIN in a procedure statement.

Overrides:

getProcedureBeginString in class DatabasePlatform

requiresProcedureBrackets

public boolean requiresProcedureBrackets()

In CREATE PROCEDURE, Pervasive requires brackets after the procedure name, even if there are no arguments.

Overrides:

requiresProcedureBrackets in class DatabasePlatform

getProcedureCallHeader

public String getProcedureCallHeader()

Pervasive uses CALL or EXECUTE not CALL PROCEDURE or EXECUTE PROCEDURE

Overrides:

getProcedureCallHeader in class DatabasePlatform

getProcedureEndString

public String getProcedureEndString()

Pervasive requires END in a procedure statement.

Overrides:

getProcedureEndString in class DatabasePlatform

getStoredProcedureParameterPrefix

public String getStoredProcedureParameterPrefix()

Pervasive uses ":" as prefix for procedure parameters.

Overrides:

getStoredProcedureParameterPrefix in class DatabasePlatform

requiresProcedureCallOuputToken

public boolean requiresProcedureCallOuputToken()

Pervasive requires the OUTPUT keyword for output parameters

Overrides:

requiresProcedureCallOuputToken in class DatabasePlatform

initializePlatformOperators

protected void initializePlatformOperators()

Description copied from class: DatasourcePlatform

Initialize any platform-specific operators

Overrides:

initializePlatformOperators in class DatasourcePlatform

shouldPrintStoredProcedureArgumentNameInCall

public boolean shouldPrintStoredProcedureArgumentNameInCall()

INTERNAL: Pervasive SQL stored procedure calls do not require the argument name be printed in the call string e.g. call MyStoredProc(?) instead of call MyStoredProc(myvariable = ?)

Overrides:

shouldPrintStoredProcedureArgumentNameInCall in class DatabasePlatform

toNumberOperator

protected ExpressionOperator toNumberOperator()

toDateOperator

protected ExpressionOperator toDateOperator()

Cloned from MySQLPlatform.java

toCharOperator

protected ExpressionOperator toCharOperator()

Cloned from MySQLPlatform.java

dateToStringOperator

protected ExpressionOperator dateToStringOperator()

Cloned from MySQLPlatform.java

isPervasive

public boolean isPervasive()

Answers whether platform is Pervasive

Overrides:

isPervasive in class DatasourcePlatform

shouldUseJDBCOuterJoinSyntax

public boolean shouldUseJDBCOuterJoinSyntax()

JDBC defines an outer join syntax which many drivers do not support. So we normally avoid it.

Overrides:

shouldUseJDBCOuterJoinSyntax in class DatabasePlatform

printFieldIdentityClause

public void printFieldIdentityClause(Writer writer)
                              throws ValidationException

Append the receiver's field 'identity' constraint clause to a writer. Taken from org.eclipse.persistence\foundation\org.eclipse.persistence.core\src\org\eclipse\persistence\platform\database\AccessPlatform.java

Overrides:

printFieldIdentityClause in class DatabasePlatform

Throws:

ValidationException

singleArgumentSubstringOperator

public ExpressionOperator singleArgumentSubstringOperator()

Override the default SubstringSingleArg operator. Cloned from SybasePlatform.java

supportsIdentity

public boolean supportsIdentity()

Indicates whether the platform supports identity.

Overrides:

supportsIdentity in class DatasourcePlatform

supportsLocalTempTables

public boolean supportsLocalTempTables()

INTERNAL:

Overrides:

supportsLocalTempTables in class DatabasePlatform

supportsGlobalTempTables

public boolean supportsGlobalTempTables()

Description copied from class: 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 DatabasePlatform

getCreateTempTableSqlPrefix

protected String getCreateTempTableSqlPrefix()

INTERNAL:

Overrides:

getCreateTempTableSqlPrefix in class DatabasePlatform

getTempTableForTable

public DatabaseTable getTempTableForTable(DatabaseTable table)

INTERNAL:

Overrides:

getTempTableForTable in class DatabasePlatform

Parameters:

table - is original table for which temp table is created.

Returns:

temporary table

printFieldTypeSize

public void printFieldTypeSize(Writer writer,
                               FieldDefinition field,
                               FieldTypeDefinition fieldType,
                               boolean shouldPrintFieldIdentityClause)
                        throws IOException

Taken from org.eclipse.persistence\foundation\org.eclipse.persistence.core\src\org\eclipse\persistence\platform\database\AccessPlatform.java

Overrides:

printFieldTypeSize in class DatabasePlatform

Throws:

IOException

buildSelectQueryForIdentity

public ValueReadQuery buildSelectQueryForIdentity()

INTERNAL: Build the identity query for native sequencing. Taken verbatim from org.eclipse.persistence\foundation\org.eclipse.persistence.core\src\org\eclipse\persistence\platform\database\SQLServerPlatform.java

Overrides:

buildSelectQueryForIdentity in class DatasourcePlatform

getSelectForUpdateString

public String getSelectForUpdateString()

Temporary workaround to avoid joined queries with FOR UPDATE in them

Overrides:

getSelectForUpdateString in class DatabasePlatform

isForUpdateCompatibleWithDistinct

public boolean isForUpdateCompatibleWithDistinct()

INTERNAL: Indicates whether SELECT DISTINCT ... FOR UPDATE is allowed by the platform (Oracle doesn't allow this).

Overrides:

isForUpdateCompatibleWithDistinct in class DatabasePlatform

supportsDeleteOnCascade

public boolean supportsDeleteOnCascade()

Setting this to false (cf. Sybase) to work around problem that unspecified default delete rule is RESTRICT, even when not allowed due to self-referencing table.

Overrides:

supportsDeleteOnCascade in class DatabasePlatform

shouldPrintLockingClauseAfterWhereClause

public boolean shouldPrintLockingClauseAfterWhereClause()

Attempts to remove FOR UPDATE from queries

Overrides:

shouldPrintLockingClauseAfterWhereClause in class DatabasePlatform

supportsLockingQueriesWithMultipleTables

public boolean supportsLockingQueriesWithMultipleTables()

INTERNAL: Indicates whether locking clause could be applied to the query that has more than one table

Overrides:

supportsLockingQueriesWithMultipleTables in class DatabasePlatform