public class SQLAnywherePlatform extends SybasePlatform
DEFAULT_VARCHAR_SIZE
DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, IS_VALID_TIMEOUT, shouldIgnoreCaseOnFieldComparisons, Types_NCLOB, Types_SQLXML
Constructor and Description |
---|
SQLAnywherePlatform() |
Modifier and Type | Method and Description |
---|---|
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.
|
java.lang.String |
getCreationOutputProcedureToken()
This method is used to print the required output parameter token for the
specific platform.
|
java.lang.String |
getInOutputProcedureToken()
This method is used to print the output parameter token when stored
procedures are called
|
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()
This method is used to print the output parameter token when stored
procedures are called
|
java.lang.String |
getProcedureArgumentString()
Used for sp defs.
|
java.lang.String |
getProcedureAsString()
Used for stored procedure defs.
|
java.lang.String |
getProcedureBeginString()
Used for stored procedure defs.
|
java.lang.String |
getProcedureCallHeader()
Used for sp calls.
|
java.lang.String |
getProcedureEndString()
Used for stored procedure defs.
|
java.lang.String |
getStoredProcedureParameterPrefix() |
DatabaseTable |
getTempTableForTable(DatabaseTable table)
Used for sp calls.
|
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()
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() |
atan2Operator, extractOperator, getCreationInOutputProcedureToken, getJDBCType, getJdbcTypeName, getNativeTableInfo, getProcedureCallTail, getSelectForUpdateString, getTimestampQuery, initializeConnectionData, isOutputAllowWithResultSet, maximumNumericValues, minimumNumericValues, modOperator, registerOutputParameter, requiresProcedureCallOuputToken, shouldPrintLockingClauseAfterWhereClause, shouldUseJDBCOuterJoinSyntax, singleArgumentSubstringOperator, supportsGlobalTempTables, trim2Operator, trimOperator, useJDBCStoredProcedureSyntax, writeUpdateOriginalFromTempTableSql
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendLiteralToCall, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildProcedureCallString, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, copyInto, createArray, createArray, createStruct, createStruct, dontBindUpdateAllQueryUsingTempTables, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConnectionUserName, getConstraintDeletionString, getCreateDatabaseSchemaString, 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, printFieldUnique, printSQLSelectStatement, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, requiresNamedPrimaryKeyConstraints, requiresTableInIndexDropDDL, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setCursorCode, setDriverName, setDriverSupportsNVarChar, setIsCastRequired, setMaxBatchWritingSize, 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, 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, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeInsertIntoTableSql, writeLOB, writeParameterMarker, writeTableCreationSuffix
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, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle9, isPervasive, isPointBase, isPostgreSQL, isSQLServer, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, setConversionManager, setDefaultNativeSequenceToTable, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, supportsSequenceObjects, toString, usesPlatformDefaultSequence
public ValueReadQuery buildSelectQueryForIdentity()
buildSelectQueryForIdentity
in class SybasePlatform
public static ExpressionOperator createCurrentDateOperator()
public static ExpressionOperator createCurrentTimeOperator()
public static ExpressionOperator createLocate2Operator()
public static ExpressionOperator createConcatOperator()
public static ExpressionOperator createLocateOperator()
public java.lang.String getInputProcedureToken()
getInputProcedureToken
in class DatabasePlatform
public java.lang.String getInOutputProcedureToken()
DatabasePlatform
getInOutputProcedureToken
in class SybasePlatform
public java.lang.String getCreationOutputProcedureToken()
DatabasePlatform
getCreationOutputProcedureToken
in class SybasePlatform
public java.lang.String getOutputProcedureToken()
DatabasePlatform
getOutputProcedureToken
in class SybasePlatform
public int getMaxFieldNameSize()
SybasePlatform
getMaxFieldNameSize
in class SybasePlatform
public java.lang.String getProcedureArgumentString()
getProcedureArgumentString
in class SybasePlatform
public java.lang.String getStoredProcedureParameterPrefix()
getStoredProcedureParameterPrefix
in class SybasePlatform
public java.lang.String getProcedureAsString()
DatabasePlatform
getProcedureAsString
in class DatabasePlatform
public java.lang.String getProcedureBeginString()
DatabasePlatform
getProcedureBeginString
in class DatabasePlatform
public java.lang.String getProcedureEndString()
DatabasePlatform
getProcedureEndString
in class DatabasePlatform
public java.lang.String getBatchBeginString()
getBatchBeginString
in class DatabasePlatform
public java.lang.String getBatchEndString()
getBatchEndString
in class DatabasePlatform
public java.lang.String getBatchDelimiterString()
getBatchDelimiterString
in class SybasePlatform
public java.lang.String getProcedureCallHeader()
getProcedureCallHeader
in class SybasePlatform
public DatabaseTable getTempTableForTable(DatabaseTable table)
getTempTableForTable
in class SybasePlatform
public boolean isSQLAnywhere()
isSQLAnywhere
in interface Platform
isSQLAnywhere
in class DatasourcePlatform
public boolean isSybase()
isSybase
in interface Platform
isSybase
in class SybasePlatform
public boolean requiresProcedureBrackets()
DatabasePlatform
requiresProcedureBrackets
in class DatabasePlatform
public boolean requiresProcedureCallBrackets()
SybasePlatform
requiresProcedureCallBrackets
in class SybasePlatform
public boolean requiresTypeNameToRegisterOutputParameter()
requiresTypeNameToRegisterOutputParameter
in class SybasePlatform
public void printFieldIdentityClause(java.io.Writer writer) throws ValidationException
SybasePlatform
printFieldIdentityClause
in class SybasePlatform
ValidationException
public void printFieldNullClause(java.io.Writer writer) throws ValidationException
SybasePlatform
printFieldNullClause
in class SybasePlatform
ValidationException
public boolean shouldPrintInputTokenAtStart()
DatabasePlatform
shouldPrintInputTokenAtStart
in class DatabasePlatform
public boolean shouldPrintInOutputTokenBeforeType()
DatabasePlatform
shouldPrintInOutputTokenBeforeType
in class SybasePlatform
public boolean shouldPrintOutputTokenAtStart()
DatabasePlatform
shouldPrintOutputTokenAtStart
in class DatabasePlatform
public boolean shouldPrintOutputTokenBeforeType()
DatabasePlatform
shouldPrintOutputTokenBeforeType
in class SybasePlatform
public boolean shouldPrintStoredProcedureArgumentNameInCall()
DatabasePlatform
shouldPrintStoredProcedureArgumentNameInCall
in class DatabasePlatform
public boolean shouldPrintStoredProcedureVariablesAfterBeginString()
DatabasePlatform
shouldPrintStoredProcedureVariablesAfterBeginString
in class DatabasePlatform
public boolean supportsIdentity()
SybasePlatform
supportsIdentity
in class SybasePlatform
public boolean supportsLocalTempTables()
DatabasePlatform
supportsLocalTempTables
in class DatabasePlatform
public boolean supportsStoredFunctions()
supportsStoredFunctions
in class DatabasePlatform
public boolean supportsDeleteOnCascade()
supportsDeleteOnCascade
in class SybasePlatform
EclipseLink 2.6.3, "build v20160428-59c81c5" API Reference