org.eclipse.persistence.platform.database
Class SymfowarePlatform

java.lang.Object
  extended by org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
      extended by org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
          extended by org.eclipse.persistence.platform.database.DatabasePlatform
              extended by org.eclipse.persistence.platform.database.SymfowarePlatform
All Implemented Interfaces:
Serializable, Cloneable, org.eclipse.persistence.internal.databaseaccess.Platform

public class SymfowarePlatform
extends DatabasePlatform

Symfoware Server
http://wiki.eclipse.org/EclipseLink/Development/Incubator/Extensions/SymfowarePlatform
Test results: http://wiki.eclipse.org/EclipseLink/Development/DatabasePlatform/SymfowarePlatform/TestResults
Contributed by: Fujitsu Ltd.
Contributed under bug: 288715

Developed on Symfoware Server V10
Initial SRG Passes on Symfoware Server V10

Feature Testing
----------------------


Limitations
----------------

Additional Notes
----------------

Since:
EclipseLink 2.1
Author:
Dies Koper, Wu Jie
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, Types_NCLOB
 
Constructor Summary
SymfowarePlatform()
           
 
Method Summary
 String buildCreateIndex(String fullTableName, String indexName, String... columnNames)
          Return the CREATE INDEX string for this platform.
 String buildDropIndex(String fullTableName, String indexName)
          Return the DROP INDEX string for this platform.
 ValueReadQuery buildSelectQueryForSequenceObject(String seqName, Integer size)
          Produce a DataReadQuery which updates(!) the sequence number in the DB and returns it.
 int computeMaxRowsForSQL(int firstResultIndex, int maxResults)
          Use the JDBC maxResults and firstResultIndex setting to compute a value to use when limiting the results of a query in SQL.
 String getCreateTempTableSqlPrefix()
          Returns the beginning of the SQL string to create a temporary table.
 String getDefaultSequenceTableName()
          Returns the table name used by TableSequence by default.
 String getInOutputProcedureToken()
          This method is used to print the output parameter token when stored procedures are called.
 String getInputProcedureToken()
          Used for stored procedure creation: Prefix for INPUT parameters.
 int getMaxFieldNameSize()
          Returns the maximum number of single byte characters that can be used in a field name on this platform, assuming DEFAULT_DSI_NAME=CODE is specified in Symfoware's operating environment file for the system (see Symfoware manual).
 String getProcedureAsString()
          Symfoware does not use the AS token.
 String getProcedureBeginString()
          Used for stored procedure definitions.
 String getProcedureCallHeader()
          Used for stored procedure calls.
 String getProcedureCallTail()
          Used for stored procedure calls.
 String getProcedureEndString()
          Used for stored procedure definitions.
 String getSelectForUpdateString()
          Symfoware supports "for update" for row locking.
 ValueReadQuery getTimestampQuery()
          This method returns the query to select the timestamp from the database.
 boolean isDynamicSQLRequiredForFunctions()
          Symfoware does not support the use of multiple parameters in certain functions.
This allows statements to disable binding only in these cases.
 boolean isForUpdateCompatibleWithDistinct()
          Indicates whether SELECT DISTINCT ...
 boolean isSymfoware()
          Identifies this database platform as Symfoware's.
 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 Symfoware syntax " WITH OPTION LIMIT ()".
 boolean requiresProcedureBrackets()
          Used for stored procedure creation: Symfoware needs brackets around arguments declaration even if no arguments exist, and so returns true.
 boolean requiresUniqueConstraintCreationOnTableCreate()
          Used for table creation.
 boolean shouldAlwaysUseTempStorageForModifyAll()
          Symfoware does not support the default syntax generated for update-all and delete-all queries as they can include the same table in the FROM clause of the main and the sub-queries.
 boolean shouldBindLiterals()
          Allows platform to choose whether to bind literals in SQL statements or not.
Literal binding is enabled for Symfoware in general.
 boolean shouldCreateIndicesForPrimaryKeys()
          Used for table creation.
 boolean shouldCreateIndicesOnUniqueKeys()
          Used for table creation.
 boolean shouldPrintInputTokenAtStart()
          Used for stored procedure creation: Some platforms want to print prefix for INPUT arguments BEFORE NAME.
 boolean shouldPrintOutputTokenAtStart()
          This is required in the construction of the stored procedures with output parameters
 boolean shouldPrintOutputTokenBeforeType()
          This is required in the construction of the stored procedures with output parameters
 boolean shouldPrintStoredProcedureArgumentNameInCall()
          Symfoware stored procedure calls do not require the argument name be printed in the call string.
E.g.
 boolean shouldPrintStoredProcedureVariablesAfterBeginString()
          Used for stored procedure creation: Symfoware declares variables AFTER the procedure body's BEGIN string.
 boolean supportsANSIInnerJoinSyntax()
          Indicates whether the ANSI syntax for inner joins (e.g.
 boolean supportsForeignKeyConstraints()
          Symfoware does not support foreign key constraint syntax, so returns false.
 boolean supportsGlobalTempTables()
          Indicates whether the platform supports global temporary tables.
 boolean supportsIndividualTableLocking()
          Indicates whether locking clause could be selectively applied only to some tables in a ReadQuery.
Symfoware platform currently only supports FOR UPDATE locking, which cannot be applied to queries that select from multiple tables.
 boolean supportsLockingQueriesWithMultipleTables()
          Indicates whether locking clause could be applied to the query that has more than one table.
Symfoware platform currently only supports FOR UPDATE locking, which cannot be applied to queries that select from multiple tables.
 boolean supportsSequenceObjects()
          Indicates whether the platform supports sequence objects.
Symfoware does through global sequence objects.
 boolean supportsStoredFunctions()
          Indicates whether the platform supports stored functions.
Symfoware does.
 boolean supportsUniqueKeyConstraints()
          Symfoware supports unique key constraints, so returns true.
Do note that unique constraints cannot be added/removed using "ALTER TABLE ADD/DROP CONSTRAINT" syntax.
 boolean wasFailureCommunicationBased(SQLException exception, Connection connection, org.eclipse.persistence.internal.sessions.AbstractSession sessionForProfile)
          Fail-over is not implemented on platform.
 
Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendLiteralToCall, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildCallWithReturning, buildProcedureCallString, buildSelectQueryForIdentity, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, commitTransaction, convertToDatabaseType, copyInto, createArray, createArray, createStruct, createStruct, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConstraintDeletionString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJdbcTypeName, getMaxBatchWritingSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getOutputProcedureToken, getPingSQL, getProcedureArgumentSetter, getProcedureArgumentString, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTempTableForTable, getTransactionIsolation, getTypeConverters, initialize, isAlterSequenceObjectSupported, isCastRequired, isInformixOuterJoin, isLockTimeoutException, isNullAllowedInSelectClause, isXDBDocument, maximumNumericValues, minimumNumericValues, prepareBatchStatement, printFieldIdentityClause, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTypeNameToRegisterOutputParameter, rollbackTransaction, setCastSizeForVarcharParameter, setCursorCode, setIsCastRequired, setMaxBatchWritingSize, setParameterValueInDatabaseCall, setPingSQL, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldCacheAllStatements, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setShouldUseRownumFiltering, setStatementCacheSize, setStringBindingSize, setSupportsAutoCommit, setTransactionIsolation, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldBindAllParameters, shouldCacheAllStatements, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldNativeSequenceUseTransaction, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInOutputTokenBeforeType, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseJDBCOuterJoinSyntax, shouldUseRownumFiltering, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsIdentity, supportsLocalTempTables, supportsNativeSequenceNumbers, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsTempTables, supportsUniqueColumns, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeInsertIntoTableSql, writeLOB, writeParameterMarker, writeUpdateOriginalFromTempTableSql
 
Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
addSequence, clone, convertObject, createConnectionCustomizer, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isFirebird, isH2, isHSQL, isInformix, isMySQL, isODBC, isOracle, isOracle9, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, setConversionManager, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, toString, usesPlatformDefaultSequence
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

SymfowarePlatform

public SymfowarePlatform()
Method Detail

isDynamicSQLRequiredForFunctions

public boolean isDynamicSQLRequiredForFunctions()
Symfoware does not support the use of multiple parameters in certain functions.
This allows statements to disable binding only in these cases.

Overrides:
isDynamicSQLRequiredForFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

isForUpdateCompatibleWithDistinct

public boolean isForUpdateCompatibleWithDistinct()
Indicates whether SELECT DISTINCT ... FOR UPDATE is allowed by the platform. (Symfoware doesn't allow this).

Overrides:
isForUpdateCompatibleWithDistinct in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

isSymfoware

public boolean isSymfoware()
Identifies this database platform as Symfoware's.

Specified by:
isSymfoware in interface org.eclipse.persistence.internal.databaseaccess.Platform
Overrides:
isSymfoware in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

computeMaxRowsForSQL

public int computeMaxRowsForSQL(int firstResultIndex,
                                int maxResults)
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
 
Symfoware 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

buildSelectQueryForSequenceObject

public ValueReadQuery buildSelectQueryForSequenceObject(String seqName,
                                                        Integer size)
Produce a DataReadQuery which updates(!) the sequence number in the DB and returns it.

Overrides:
buildSelectQueryForSequenceObject in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Parameters:
seqName - known by Symfoware to be a defined sequence
size - size of sequence
Returns:
ValueReadQuery class to perform a read of a single data value.

buildCreateIndex

public String buildCreateIndex(String fullTableName,
                               String indexName,
                               String... columnNames)
Return the CREATE INDEX string for this platform.

Overrides:
buildCreateIndex in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Parameters:
fullTableName - qualified name of the table the index is to be created on
indexName - name of the index
columnNames - list of columns the index is created for

buildDropIndex

public String buildDropIndex(String fullTableName,
                             String indexName)
Return the DROP INDEX string for this platform.

Overrides:
buildDropIndex in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Parameters:
fullTableName - qualified name of the table the index is to be created on
indexName - name of the index

getCreateTempTableSqlPrefix

public String getCreateTempTableSqlPrefix()
Returns the beginning of the SQL string to create a temporary table.

Overrides:
getCreateTempTableSqlPrefix in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
See Also:
shouldAlwaysUseTempStorageForModifyAll()

getDefaultSequenceTableName

public String getDefaultSequenceTableName()
Returns the table name used by TableSequence by default. Symfoware does not allow reserved keyword 'SEQUENCE' as table name, so returns "SEQUENCE" (with double-quotes) instead.

Overrides:
getDefaultSequenceTableName in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getInOutputProcedureToken

public String getInOutputProcedureToken()
This method is used to print the output parameter token when stored procedures are called.

Overrides:
getInOutputProcedureToken in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getInputProcedureToken

public String getInputProcedureToken()
Used for stored procedure creation: Prefix for INPUT parameters.

Overrides:
getInputProcedureToken in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getMaxFieldNameSize

public int getMaxFieldNameSize()
Returns the maximum number of single byte characters that can be used in a field name on this platform, assuming DEFAULT_DSI_NAME=CODE is specified in Symfoware's operating environment file for the system (see Symfoware manual).

Overrides:
getMaxFieldNameSize in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getProcedureAsString

public String getProcedureAsString()
Symfoware does not use the AS token.

Overrides:
getProcedureAsString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getProcedureCallHeader

public String getProcedureCallHeader()
Used for stored procedure calls.

Overrides:
getProcedureCallHeader in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getProcedureCallTail

public String getProcedureCallTail()
Used for stored procedure calls.

Overrides:
getProcedureCallTail in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getProcedureBeginString

public String getProcedureBeginString()
Used for stored procedure definitions.

Overrides:
getProcedureBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getProcedureEndString

public String getProcedureEndString()
Used for stored procedure definitions.

Overrides:
getProcedureEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getSelectForUpdateString

public String getSelectForUpdateString()
Symfoware supports "for update" for row locking.

Overrides:
getSelectForUpdateString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Returns:
the string of "for update".

getTimestampQuery

public ValueReadQuery getTimestampQuery()
This method returns the query to select the timestamp from the database.

Specified by:
getTimestampQuery in interface org.eclipse.persistence.internal.databaseaccess.Platform
Overrides:
getTimestampQuery in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

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 Symfoware syntax " WITH OPTION LIMIT ()". There is no equivalent to 'OFFSET'.
Even though most performance benefit comes from including the offset in the SQL statement, for this platform the benefit of including LIMIT is that it allows pagination with result sets with scrollable cursors too (which the Symfoware JDBC driver's setMaxRows method does not support).

Overrides:
printSQLSelectStatement in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

requiresProcedureBrackets

public boolean requiresProcedureBrackets()
Used for stored procedure creation: Symfoware needs brackets around arguments declaration even if no arguments exist, and so returns true.

Overrides:
requiresProcedureBrackets in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

requiresUniqueConstraintCreationOnTableCreate

public boolean requiresUniqueConstraintCreationOnTableCreate()
Used for table creation. Symfoware does not support the ALTER TABLE syntax to add/drop unique constraints, but it does allow declaration of (single and multi-column) unique constraints as part of the CREATE TABLE statement.

Overrides:
requiresUniqueConstraintCreationOnTableCreate in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Returns:
whether unique constraints should be declared as part of the CREATE TABLE statement instead of in separate ALTER TABLE ADD/DROP statements.

shouldAlwaysUseTempStorageForModifyAll

public boolean shouldAlwaysUseTempStorageForModifyAll()
Symfoware does not support the default syntax generated for update-all and delete-all queries as they can include the same table in the FROM clause of the main and the sub-queries. However, the alternative of using global temporary tables leads to table locking issues, so returns false to prevent the use of global temporary tables.

Overrides:
shouldAlwaysUseTempStorageForModifyAll in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldBindLiterals

public boolean shouldBindLiterals()
Allows platform to choose whether to bind literals in SQL statements or not.
Literal binding is enabled for Symfoware in general. As a number of functions and operators have restrictions on the use of input parameters, it is disabled for those.

Overrides:
shouldBindLiterals in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
See Also:
isDynamicSQLRequiredForFunctions()

shouldCreateIndicesForPrimaryKeys

public boolean shouldCreateIndicesForPrimaryKeys()
Used for table creation. Symfoware needs an index to be created explicitly for columns with a primary key constraint.

Overrides:
shouldCreateIndicesForPrimaryKeys in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Returns:
true: indices should be created during table generation

shouldCreateIndicesOnUniqueKeys

public boolean shouldCreateIndicesOnUniqueKeys()
Used for table creation. Symfoware needs an index to be created explicitly for columns with a unique constraint.

Overrides:
shouldCreateIndicesOnUniqueKeys in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
Returns:
true: indices should be created during table generation

shouldPrintInputTokenAtStart

public boolean shouldPrintInputTokenAtStart()
Used for stored procedure creation: Some platforms want to print prefix for INPUT arguments BEFORE NAME. If wanted, override and return true.

Overrides:
shouldPrintInputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldPrintOutputTokenBeforeType

public boolean shouldPrintOutputTokenBeforeType()
This is required in the construction of the stored procedures with output parameters

Overrides:
shouldPrintOutputTokenBeforeType in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldPrintOutputTokenAtStart

public boolean shouldPrintOutputTokenAtStart()
This is required in the construction of the stored procedures with output parameters

Overrides:
shouldPrintOutputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldPrintStoredProcedureArgumentNameInCall

public boolean shouldPrintStoredProcedureArgumentNameInCall()
Symfoware 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 org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldPrintStoredProcedureVariablesAfterBeginString

public boolean shouldPrintStoredProcedureVariablesAfterBeginString()
Used for stored procedure creation: Symfoware declares variables AFTER the procedure body's BEGIN string.

Overrides:
shouldPrintStoredProcedureVariablesAfterBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsANSIInnerJoinSyntax

public boolean supportsANSIInnerJoinSyntax()
Indicates whether the ANSI syntax for inner joins (e.g. SELECT FROM t1 JOIN t2 ON t1.pk = t2.fk) is supported by this platform. Symfoware does not.

Overrides:
supportsANSIInnerJoinSyntax in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsForeignKeyConstraints

public boolean supportsForeignKeyConstraints()
Symfoware does not support foreign key constraint syntax, so returns false.

Overrides:
supportsForeignKeyConstraints in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsGlobalTempTables

public boolean supportsGlobalTempTables()
Indicates whether the platform supports global temporary tables. Although Symfoware does, it leads to table locking issues when used from EclipseLink.

Overrides:
supportsGlobalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
See Also:
shouldAlwaysUseTempStorageForModifyAll()

supportsIndividualTableLocking

public boolean supportsIndividualTableLocking()
Indicates whether locking clause could be selectively applied only to some tables in a ReadQuery.
Symfoware platform currently only supports FOR UPDATE locking, which cannot be applied to queries that select from multiple tables. Use of other locking strategies (LOCK_MODE) are yet to be explored.

Overrides:
supportsIndividualTableLocking in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsLockingQueriesWithMultipleTables

public boolean supportsLockingQueriesWithMultipleTables()
Indicates whether locking clause could be applied to the query that has more than one table.
Symfoware platform currently only supports FOR UPDATE locking, which cannot be applied to queries that select from multiple tables. Use of other locking strategies (LOCK_MODE) are yet to be explored.

Overrides:
supportsLockingQueriesWithMultipleTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsSequenceObjects

public boolean supportsSequenceObjects()
Indicates whether the platform supports sequence objects.
Symfoware does through global sequence objects.

Overrides:
supportsSequenceObjects in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsStoredFunctions

public boolean supportsStoredFunctions()
Indicates whether the platform supports stored functions.
Symfoware does.

Overrides:
supportsStoredFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsUniqueKeyConstraints

public boolean supportsUniqueKeyConstraints()
Symfoware supports unique key constraints, so returns true.
Do note that unique constraints cannot be added/removed using "ALTER TABLE ADD/DROP CONSTRAINT" syntax.

Overrides:
supportsUniqueKeyConstraints in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
See Also:
requiresUniqueConstraintCreationOnTableCreate()

wasFailureCommunicationBased

public boolean wasFailureCommunicationBased(SQLException exception,
                                            Connection connection,
                                            org.eclipse.persistence.internal.sessions.AbstractSession sessionForProfile)
Fail-over is not implemented on platform. This method returns false no matter what caused the failure.

Overrides:
wasFailureCommunicationBased in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform