org.eclipse.persistence.platform.database

Class SQLAnywherePlatform

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

org.eclipse.persistence.platform.database.SQLAnywherePlatform

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

public class SQLAnywherePlatform
extends SybasePlatform

Provides SQL Anywhere specific behaviour.

See Also:

Serialized Form

Author:

Markus KARG ([email protected])

Field Summary

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

typeStrings

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
SQLAnywherePlatform()

Method Summary

Modifier and Type	Method and Description
protected java.util.Hashtable	buildFieldTypes()
ValueReadQuery	buildSelectQueryForIdentity() INTERNAL: Build the identity query for native sequencing.
static ExpressionOperator	createConcatOperator()
static ExpressionOperator	createCurrentDateOperator()
static ExpressionOperator	createCurrentTimeOperator()
static ExpressionOperator	createLocate2Operator()
static ExpressionOperator	createLocateOperator()
java.lang.String	getBatchBeginString() Used for batch writing and sp defs.
java.lang.String	getBatchDelimiterString() Used for batch writing and sp defs.
java.lang.String	getBatchEndString() Used for batch writing and sp defs.
protected java.lang.String	getCreateTempTableSqlPrefix() INTERNAL:
java.lang.String	getCreationOutputProcedureToken()
java.lang.String	getInOutputProcedureToken()
java.lang.String	getInputProcedureToken() Used for stored procedure creation: Prefix for INPUT parameters.
int	getMaxFieldNameSize() INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.
java.lang.String	getOutputProcedureToken()
java.lang.String	getProcedureArgumentString() Used for sp defs.
java.lang.String	getProcedureAsString()
java.lang.String	getProcedureBeginString()
java.lang.String	getProcedureCallHeader() Used for sp calls.
java.lang.String	getProcedureEndString()
java.lang.String	getStoredProcedureParameterPrefix()
org.eclipse.persistence.internal.helper.DatabaseTable	getTempTableForTable(org.eclipse.persistence.internal.helper.DatabaseTable table) Used for sp calls.
protected void	initializePlatformOperators() Initialize any platform-specific operators
boolean	isSQLAnywhere()
boolean	isSybase()
void	printFieldIdentityClause(java.io.Writer writer) Append the receiver's field 'identity' constraint clause to a writer.
void	printFieldNullClause(java.io.Writer writer) Append the receiver's field 'NULL' constraint clause to a writer.
boolean	requiresProcedureBrackets()
boolean	requiresProcedureCallBrackets() USed for sp calls.
boolean	requiresTypeNameToRegisterOutputParameter() INTERNAL: Indicates whether the version of CallableStatement.registerOutputParameter method that takes type name should be used.
boolean	shouldPrintInOutputTokenBeforeType()
boolean	shouldPrintInputTokenAtStart()
boolean	shouldPrintOutputTokenAtStart()
boolean	shouldPrintOutputTokenBeforeType()
boolean	shouldPrintStoredProcedureArgumentNameInCall()
boolean	shouldPrintStoredProcedureVariablesAfterBeginString()
boolean	supportsDeleteOnCascade() SQL Anywhere does support cascade on delete, unlike Sybase.
boolean	supportsIdentity() INTERNAL: Indicates whether the platform supports identity.
boolean	supportsLocalTempTables()
boolean	supportsStoredFunctions()

Methods inherited from class org.eclipse.persistence.platform.database.SybasePlatform

appendByteArray, appendCalendar, appendDate, appendSybaseCalendar, appendSybaseTimestamp, appendTime, appendTimestamp, atan2Operator, extractOperator, getCreationInOutputProcedureToken, getJDBCType, getJdbcTypeName, getNativeTableInfo, getProcedureCallTail, getSelectForUpdateString, getTimestampQuery, getTypeStrings, initializeConnectionData, initializeTypeStrings, isOutputAllowWithResultSet, maximumNumericValues, minimumNumericValues, modOperator, operatorOuterJoin, registerOutputParameter, requiresProcedureCallOuputToken, shouldPrintLockingClauseAfterWhereClause, shouldUseJDBCOuterJoinSyntax, singleArgumentSubstringOperator, supportsGlobalTempTables, trim2Operator, trimOperator, useJDBCStoredProcedureSyntax, writeUpdateOriginalFromTempTableSql

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, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConnectionUserName, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateTempTableSqlBodyForTable, getCreateTempTableSqlSuffix, getCreateViewString, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getDriverSupportsNVarChar, getDropCascadeString, getDropDatabaseSchemaString, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getIndexNamePrefix, getJDBCOuterJoinString, getJDBCType, getJDBCTypeForSetNull, getMaxBatchWritingSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getPartitioningCallback, getPingSQL, getProcedureArgumentSetter, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableCreationSuffix, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getUseNationalCharacterVaryingTypeForString, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, isAlterSequenceObjectSupported, isCastRequired, isDynamicSQLRequiredForFunctions, isForUpdateCompatibleWithDistinct, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isNullAllowedInSelectClause, isRowCountOutputParameterRequired, isXDBDocument, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldTypeSize, printFieldTypeSize, printFieldUnique, printFieldUnique, printSQLSelectStatement, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, requiresNamedPrimaryKeyConstraints, requiresTableInIndexDropDDL, 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, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintForUpdateClause, shouldPrintInnerJoinInWhereClause, shouldPrintOuterJoinInWhereClause, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsConnectionUserName, supportsCountDistinctWithMultipleFields, supportsForeignKeyConstraints, supportsIndexes, supportsIndividualTableLocking, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, 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, writeParameterMarker, writeTableCreationSuffix

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

addOperator, addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultNativeSequenceToTable, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, initIdentitySequences, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle12, isOracle9, isPervasive, isPointBase, isPostgreSQL, isSQLServer, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeIdentitySequences, removeSequence, sequencesAfterCloneCleanup, setConversionManager, setDefaultNativeSequenceToTable, 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

Constructor Detail

SQLAnywherePlatform

public SQLAnywherePlatform()

Method Detail

buildFieldTypes

protected java.util.Hashtable buildFieldTypes()

Overrides:

buildFieldTypes in class SybasePlatform

buildSelectQueryForIdentity

public ValueReadQuery buildSelectQueryForIdentity()

INTERNAL: Build the identity query for native sequencing.

Overrides:

buildSelectQueryForIdentity in class SybasePlatform

createCurrentDateOperator

public static ExpressionOperator createCurrentDateOperator()

createCurrentTimeOperator

public static ExpressionOperator createCurrentTimeOperator()

createLocate2Operator

public static ExpressionOperator createLocate2Operator()

createConcatOperator

public static ExpressionOperator createConcatOperator()

createLocateOperator

public static ExpressionOperator createLocateOperator()

getCreateTempTableSqlPrefix

protected java.lang.String getCreateTempTableSqlPrefix()

Description copied from class: SybasePlatform

INTERNAL:

Overrides:

getCreateTempTableSqlPrefix in class SybasePlatform

getInputProcedureToken

public java.lang.String getInputProcedureToken()

Used for stored procedure creation: Prefix for INPUT parameters. Not required on most platforms.

Overrides:

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

getInOutputProcedureToken

public java.lang.String getInOutputProcedureToken()

Overrides:

getInOutputProcedureToken in class SybasePlatform

getCreationOutputProcedureToken

public java.lang.String getCreationOutputProcedureToken()

Overrides:

getCreationOutputProcedureToken in class SybasePlatform

getOutputProcedureToken

public java.lang.String getOutputProcedureToken()

Overrides:

getOutputProcedureToken in class SybasePlatform

getMaxFieldNameSize

public int getMaxFieldNameSize()

Description copied from class: SybasePlatform

INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.

Overrides:

getMaxFieldNameSize in class SybasePlatform

getProcedureArgumentString

public java.lang.String getProcedureArgumentString()

Used for sp defs.

Overrides:

getProcedureArgumentString in class SybasePlatform

getStoredProcedureParameterPrefix

public java.lang.String getStoredProcedureParameterPrefix()

Overrides:

getStoredProcedureParameterPrefix in class SybasePlatform

getProcedureAsString

public java.lang.String getProcedureAsString()

Overrides:

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

getProcedureBeginString

public java.lang.String getProcedureBeginString()

Overrides:

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

getProcedureEndString

public java.lang.String getProcedureEndString()

Overrides:

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

getBatchBeginString

public java.lang.String getBatchBeginString()

Used for batch writing and sp defs.

Overrides:

getBatchBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getBatchEndString

public java.lang.String getBatchEndString()

Used for batch writing and sp defs.

Overrides:

getBatchEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

getBatchDelimiterString

public java.lang.String getBatchDelimiterString()

Used for batch writing and sp defs.

Overrides:

getBatchDelimiterString in class SybasePlatform

getProcedureCallHeader

public java.lang.String getProcedureCallHeader()

Used for sp calls.

Overrides:

getProcedureCallHeader in class SybasePlatform

getTempTableForTable

public org.eclipse.persistence.internal.helper.DatabaseTable getTempTableForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)

Used for sp calls.

Overrides:

getTempTableForTable in class SybasePlatform

initializePlatformOperators

protected void initializePlatformOperators()

Description copied from class: SybasePlatform

Initialize any platform-specific operators

Overrides:

initializePlatformOperators in class SybasePlatform

isSQLAnywhere

public boolean isSQLAnywhere()

Specified by:

isSQLAnywhere in interface org.eclipse.persistence.internal.databaseaccess.Platform

Overrides:

isSQLAnywhere in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform

isSybase

public boolean isSybase()

Specified by:

isSybase in interface org.eclipse.persistence.internal.databaseaccess.Platform

Overrides:

isSybase in class SybasePlatform

requiresProcedureBrackets

public boolean requiresProcedureBrackets()

Overrides:

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

requiresProcedureCallBrackets

public boolean requiresProcedureCallBrackets()

Description copied from class: SybasePlatform

USed for sp calls.

Overrides:

requiresProcedureCallBrackets in class SybasePlatform

requiresTypeNameToRegisterOutputParameter

public boolean requiresTypeNameToRegisterOutputParameter()

INTERNAL: Indicates whether the version of CallableStatement.registerOutputParameter method that takes type name should be used.

Overrides:

requiresTypeNameToRegisterOutputParameter in class SybasePlatform

printFieldIdentityClause

public void printFieldIdentityClause(java.io.Writer writer)
                              throws ValidationException

Description copied from class: SybasePlatform

Append the receiver's field 'identity' constraint clause to a writer.

Overrides:

printFieldIdentityClause in class SybasePlatform

Throws:

ValidationException

printFieldNullClause

public void printFieldNullClause(java.io.Writer writer)
                          throws ValidationException

Description copied from class: SybasePlatform

Append the receiver's field 'NULL' constraint clause to a writer.

Overrides:

printFieldNullClause in class SybasePlatform

Throws:

ValidationException

shouldPrintInputTokenAtStart

public boolean shouldPrintInputTokenAtStart()

Overrides:

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

shouldPrintInOutputTokenBeforeType

public boolean shouldPrintInOutputTokenBeforeType()

Overrides:

shouldPrintInOutputTokenBeforeType in class SybasePlatform

shouldPrintOutputTokenAtStart

public boolean shouldPrintOutputTokenAtStart()

Overrides:

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

shouldPrintOutputTokenBeforeType

public boolean shouldPrintOutputTokenBeforeType()

Overrides:

shouldPrintOutputTokenBeforeType in class SybasePlatform

shouldPrintStoredProcedureArgumentNameInCall

public boolean shouldPrintStoredProcedureArgumentNameInCall()

Overrides:

shouldPrintStoredProcedureArgumentNameInCall in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

shouldPrintStoredProcedureVariablesAfterBeginString

public boolean shouldPrintStoredProcedureVariablesAfterBeginString()

Overrides:

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

supportsIdentity

public boolean supportsIdentity()

Description copied from class: SybasePlatform

INTERNAL: Indicates whether the platform supports identity. Sybase does through IDENTITY field types. This method is to be used *ONLY* by sequencing classes

Overrides:

supportsIdentity in class SybasePlatform

supportsLocalTempTables

public boolean supportsLocalTempTables()

Overrides:

supportsLocalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform

supportsStoredFunctions

public boolean supportsStoredFunctions()

Overrides:

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

supportsDeleteOnCascade

public boolean supportsDeleteOnCascade()

SQL Anywhere does support cascade on delete, unlike Sybase.

Overrides:

supportsDeleteOnCascade in class SybasePlatform