public class SQLAnywherePlatform extends SybasePlatform
typeStringsDEFAULT_VARCHAR_SIZEbatchWritingMechanism, 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, usesStringBindingconversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultNativeSequenceToTable, defaultSeqenceAtNextValue, defaultSequence, endDelimiter, platformOperators, sequences, sequencesLock, startDelimiter, tableQualifier, timestampQuery| Constructor and Description |
|---|
SQLAnywherePlatform() |
| Modifier and Type | Method and Description |
|---|---|
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.
|
static ExpressionOperator |
createConcatOperator() |
static ExpressionOperator |
createCurrentDateOperator() |
static ExpressionOperator |
createCurrentTimeOperator() |
static ExpressionOperator |
createLocate2Operator() |
static ExpressionOperator |
createLocateOperator() |
String |
getBatchBeginString()
Used for batch writing and sp defs.
|
String |
getBatchDelimiterString()
Used for batch writing and sp defs.
|
String |
getBatchEndString()
Used for batch writing and sp defs.
|
protected String |
getCreateTempTableSqlPrefix()
INTERNAL:
|
String |
getCreationOutputProcedureToken()
This method is used to print the required output parameter token for the
specific platform.
|
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()
INTERNAL:
returns the maximum number of characters that can be used in a field
name on this platform.
|
String |
getOutputProcedureToken()
This method is used to print the output parameter token when stored
procedures are called
|
String |
getProcedureArgumentString()
Used for sp defs.
|
String |
getProcedureAsString()
Used for stored procedure defs.
|
String |
getProcedureBeginString()
Used for stored procedure defs.
|
String |
getProcedureCallHeader()
Used for sp calls.
|
String |
getProcedureEndString()
Used for stored procedure defs.
|
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(Writer writer)
Append the receiver's field 'identity' constraint clause to a writer.
|
void |
printFieldNullClause(Writer writer)
Append the receiver's field 'NULL' constraint clause to a writer.
|
boolean |
requiresProcedureBrackets()
Used for stored procedure creation: Some platforms need brackets around arguments declaration even if no arguments exist.
|
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()
This is required in the construction of the stored procedures with
output parameters
|
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()
INTERNAL:
Should the variable name of a stored procedure call be printed as part of the procedure call
e.g.
|
boolean |
shouldPrintStoredProcedureVariablesAfterBeginString()
Used for stored procedure creation: Some platforms declare variables AFTER the procedure body's BEGIN string.
|
boolean |
supportsDeleteOnCascade()
SQL Anywhere does support cascade on delete, unlike Sybase.
|
boolean |
supportsIdentity()
INTERNAL:
Indicates whether the platform supports identity.
|
boolean |
supportsLocalTempTables()
INTERNAL:
Indicates whether the platform supports local temporary tables.
|
boolean |
supportsStoredFunctions() |
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, registerOutputParameter, requiresProcedureCallOuputToken, shouldPrintLockingClauseAfterWhereClause, shouldUseJDBCOuterJoinSyntax, singleArgumentSubstringOperator, supportsGlobalTempTables, trim2Operator, trimOperator, useJDBCStoredProcedureSyntax, writeUpdateOriginalFromTempTableSqladdBatch, 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, checkTableExists, 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, getIndexNamePrefix, getJDBCOuterJoinString, getJDBCType, getJDBCTypeForSetNull, getMaxBatchWritingSize, getMaxForeignKeyNameSize, getMaxIndexNameSize, getMaxUniqueKeyNameSize, getNoWaitString, getObjectFromResultSet, getParameterValueFromDatabaseCall, getParameterValueFromDatabaseCall, getPartitioningCallback, getPingSQL, getProcedureArgument, 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, isAlterSequenceObjectSupported, isCastRequired, isDynamicSQLRequiredForFunctions, isForUpdateCompatibleWithDistinct, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isNullAllowedInSelectClause, isRowCountOutputParameterRequired, isXDBDocument, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldTypeSize, printFieldTypeSize, printFieldUnique, printFieldUnique, printSQLSelectStatement, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresTableInIndexDropDDL, 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, shouldPrintOuterJoinInWhereClause, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsConnectionUserName, supportsCountDistinctWithMultipleFields, supportsForeignKeyConstraints, supportsIndexes, supportsIndividualTableLocking, supportsLockingQueriesWithMultipleTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, 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, writeTableCreationSuffixaddOperator, 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, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, initIdentitySequences, isAccess, isAttunity, isCloudscape, isDB2, isDB2Z, 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, setDefaultSeqenceAtNextValue, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, supportsSequenceObjects, toString, usesPlatformDefaultSequenceprotected Hashtable buildFieldTypes()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformbuildFieldTypes in class SybasePlatformpublic ValueReadQuery buildSelectQueryForIdentity()
buildSelectQueryForIdentity in class SybasePlatformpublic static ExpressionOperator createCurrentDateOperator()
public static ExpressionOperator createCurrentTimeOperator()
public static ExpressionOperator createLocate2Operator()
public static ExpressionOperator createConcatOperator()
public static ExpressionOperator createLocateOperator()
protected String getCreateTempTableSqlPrefix()
SybasePlatformgetCreateTempTableSqlPrefix in class SybasePlatformpublic String getInputProcedureToken()
getInputProcedureToken in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getInOutputProcedureToken()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetInOutputProcedureToken in class SybasePlatformpublic String getCreationOutputProcedureToken()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetCreationOutputProcedureToken in class SybasePlatformpublic String getOutputProcedureToken()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetOutputProcedureToken in class SybasePlatformpublic int getMaxFieldNameSize()
SybasePlatformgetMaxFieldNameSize in class SybasePlatformpublic String getProcedureArgumentString()
getProcedureArgumentString in class SybasePlatformpublic String getStoredProcedureParameterPrefix()
getStoredProcedureParameterPrefix in class SybasePlatformpublic String getProcedureAsString()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetProcedureAsString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getProcedureBeginString()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetProcedureBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getProcedureEndString()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformgetProcedureEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getBatchBeginString()
getBatchBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getBatchEndString()
getBatchEndString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic String getBatchDelimiterString()
getBatchDelimiterString in class SybasePlatformpublic String getProcedureCallHeader()
getProcedureCallHeader in class SybasePlatformpublic org.eclipse.persistence.internal.helper.DatabaseTable getTempTableForTable(org.eclipse.persistence.internal.helper.DatabaseTable table)
getTempTableForTable in class SybasePlatformtable - is original table for which temp table is created.protected void initializePlatformOperators()
SybasePlatforminitializePlatformOperators in class SybasePlatformpublic boolean isSQLAnywhere()
isSQLAnywhere in interface org.eclipse.persistence.internal.databaseaccess.PlatformisSQLAnywhere in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatformpublic boolean isSybase()
isSybase in interface org.eclipse.persistence.internal.databaseaccess.PlatformisSybase in class SybasePlatformpublic boolean requiresProcedureBrackets()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformrequiresProcedureBrackets in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean requiresProcedureCallBrackets()
SybasePlatformrequiresProcedureCallBrackets in class SybasePlatformpublic boolean requiresTypeNameToRegisterOutputParameter()
requiresTypeNameToRegisterOutputParameter in class SybasePlatformpublic void printFieldIdentityClause(Writer writer) throws ValidationException
SybasePlatformprintFieldIdentityClause in class SybasePlatformValidationExceptionpublic void printFieldNullClause(Writer writer) throws ValidationException
SybasePlatformprintFieldNullClause in class SybasePlatformValidationExceptionpublic boolean shouldPrintInputTokenAtStart()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintInputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean shouldPrintInOutputTokenBeforeType()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintInOutputTokenBeforeType in class SybasePlatformpublic boolean shouldPrintOutputTokenAtStart()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintOutputTokenAtStart in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean shouldPrintOutputTokenBeforeType()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintOutputTokenBeforeType in class SybasePlatformpublic boolean shouldPrintStoredProcedureArgumentNameInCall()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintStoredProcedureArgumentNameInCall in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean shouldPrintStoredProcedureVariablesAfterBeginString()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformshouldPrintStoredProcedureVariablesAfterBeginString in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean supportsIdentity()
SybasePlatformsupportsIdentity in class SybasePlatformpublic boolean supportsLocalTempTables()
org.eclipse.persistence.internal.databaseaccess.DatabasePlatformsupportsLocalTempTables in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean supportsStoredFunctions()
supportsStoredFunctions in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatformpublic boolean supportsDeleteOnCascade()
supportsDeleteOnCascade in class SybasePlatformCopyright © 2007–2021 Eclipse.org - EclipseLink Project. All rights reserved.