Module org.eclipse.persistence.core
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:

  • Field Details

  • Constructor Details

    • PervasivePlatform

      public PervasivePlatform()
      Default constructor.

  • Method Details

    • 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<Class<?>,FieldTypeDefinition> 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