Package liquibase.database.core

Class SybaseASADatabase

java.lang.Object

liquibase.database.AbstractJdbcDatabase

liquibase.database.core.SybaseASADatabase

All Implemented Interfaces:

AutoCloseable, Database, PrioritizedService

public class SybaseASADatabase
extends AbstractJdbcDatabase

Support for SAP (formerly: Sybase) AS (Adapter Server) Anywhere embedded/mobile database.

Field Summary

Fields inherited from class liquibase.database.AbstractJdbcDatabase

caseSensitive, currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercased

Fields inherited from interface liquibase.database.Database

COMPLETE_SQL_SCOPE_KEY, IGNORE_MISSING_REFERENCES_KEY

Fields inherited from interface liquibase.servicelocator.PrioritizedService

COMPARATOR, PRIORITY_DATABASE, PRIORITY_DEFAULT

Constructor Summary

Constructors

Constructor	Description
SybaseASADatabase()

Method Summary

Modifier and Type	Method	Description
void	afterUpdate()	Allows the database to perform actions after an update is finished, i.e. after the last change of a changelog was applied.
String	escapeIndexName(String catalogName, String schemaName, String indexName)
protected boolean	generateAutoIncrementBy(BigInteger incrementBy)
protected boolean	generateAutoIncrementStartWith(BigInteger startWith)
protected String	getAutoIncrementClause()
protected String	getConnectionSchemaName()	Overwrite this method to get the default schema name for the connection.
String	getDefaultCatalogName()
protected String	getDefaultDatabaseProductName()
String	getDefaultDriver(String url)	If this database understands the given url, return the default driver class name.
Integer	getDefaultPort()
String	getJdbcCatalogName(CatalogAndSchema schema)
int	getMaxFractionalDigitsForTimestamp()	Most relational databases support 9 fractional digits, and subclasses must overwrite this method if they support less than that.
int	getPriority()
String	getShortName()	Returns an all-lower-case short name of the product.
Set<String>	getSystemViews()	Returns system (undroppable) views.
String	getViewDefinition(CatalogAndSchema schema, String viewName)
boolean	isCorrectDatabaseImplementation(DatabaseConnection conn)	Is this AbstractDatabase subclass the correct one to use for the given connection.
boolean	requiresExplicitNullForColumns()	Does the database require explicit NULL for nullable columns?
void	setAutoCommit(boolean b)
void	setConnection(DatabaseConnection conn)
boolean	supportsDropTableCascadeConstraints()
boolean	supportsInitiallyDeferrableColumns()	Returns whether this database support initially deferrable columns.
boolean	supportsSequences()	Does the database type support sequence.
boolean	supportsTablespaces()

Methods inherited from class liquibase.database.AbstractJdbcDatabase

addReservedWords, canCreateChangeLogTable, close, commit, correctObjectName, correctSchema, correctSchema, createsIndexesForForeignKeys, dataTypeIsNotModifiable, disableForeignKeyChecks, doesTagExist, dropDatabaseObjects, enableForeignKeyChecks, equals, escapeColumnName, escapeColumnName, escapeColumnNameList, escapeConstraintName, escapeDataTypeName, escapeObjectName, escapeObjectName, escapeSequenceName, escapeStringForDatabase, escapeTableName, escapeViewName, execute, executeRollbackStatements, executeRollbackStatements, executeStatements, filterRollbackVisitors, generateDatabaseFunctionValue, generatePrimaryKeyName, get, getAutoCommitMode, getAutoIncrementByClause, getAutoIncrementClause, getAutoIncrementClause, getAutoIncrementClosing, getAutoIncrementOpening, getAutoIncrementStartWithClause, getConcatSql, getConnection, getConnectionCatalogName, getConnectionSchemaNameCallStatement, getContainingObjects, getCurrentDateTimeFunction, getDatabaseChangeLogLockTableName, getDatabaseChangeLogTableName, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataTypeMaxParameters, getDateFunctions, getDateLiteral, getDateLiteral, getDateLiteral, getDateTimeLiteral, getDefaultFractionalDigitsForTimestamp, getDefaultScaleForNativeDataType, getDefaultSchema, getDefaultSchemaName, getFetchSize, getJdbcCatalogName, getJdbcSchemaName, getJdbcSchemaName, getLineComment, getLiquibaseCatalogName, getLiquibaseSchemaName, getLiquibaseTablespaceName, getName, getObjectQuotingStrategy, getOutputDefaultCatalog, getOutputDefaultSchema, getQuotingEndCharacter, getQuotingEndReplacement, getQuotingStartCharacter, getRanChangeSet, getRanChangeSetList, getRanDate, getRawDatabaseChangeLogLockTableName, getRawDatabaseChangeLogTableName, getRunStatus, getSchemaAndCatalogCase, getSchemaFromJdbcInfo, getSystemSchema, getSystemTables, getTimeLiteral, hashCode, isAutoCommit, isCaseSensitive, isCatalogOrSchemaType, isCurrentTimeFunction, isDateOnly, isDateTime, isDefaultCatalog, isDefaultSchema, isFunction, isLiquibaseObject, isReservedWord, isSafeToRunUpdate, isSystemObject, isSystemView, isTimeOnly, isTimestamp, jdbcCallsCatalogsSchemas, markChangeSetExecStatus, mustQuoteObjectName, parseDate, quoteObject, removeRanStatus, requiresPassword, requiresUsername, resetInternalState, rollback, saveRollbackStatement, saveStatements, set, setCanCacheLiquibaseTableInfo, setCaseSensitive, setCurrentDateTimeFunction, setDatabaseChangeLogLockTableName, setDatabaseChangeLogTableName, setDefaultCatalogName, setDefaultSchemaName, setLiquibaseCatalogName, setLiquibaseSchemaName, setLiquibaseTablespaceName, setObjectQuotingStrategy, setOutputDefaultCatalog, setOutputDefaultSchema, setPreviousAutoCommit, startsWithNumeric, supportsAutoIncrement, supportsBatchUpdates, supportsCatalogInObjectName, supportsCatalogs, supportsDDLInTransaction, supportsForeignKeyDisable, supportsNotNullConstraintNames, supportsPrimaryKeyNames, supportsRestrictForeignKeys, supportsSchemas, tag, toString, unescapeDataTypeName, unescapeDataTypeString, validate

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface liquibase.database.Database

addCompleteSqlToScope, checkDatabaseConnection, dropDatabaseObjects, escapeForLike, failOnDefferable, generateConnectCommandSuccessMessage, getDisplayName, supports, supportsCreateIfNotExists, supportsDatabaseChangeLogHistory, temporarilySetObjectQuotingStrategy

Constructor Details

SybaseASADatabase

public SybaseASADatabase()

Method Details

getPriority

public int getPriority()

getDefaultDriver

public String getDefaultDriver(String url)

Description copied from interface: Database

If this database understands the given url, return the default driver class name. Otherwise return null.

getDefaultPort

public Integer getDefaultPort()

getDefaultDatabaseProductName

protected String getDefaultDatabaseProductName()

Specified by:

getDefaultDatabaseProductName in class AbstractJdbcDatabase

getShortName

public String getShortName()

Description copied from interface: Database

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

isCorrectDatabaseImplementation

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn)
                                        throws DatabaseException

Description copied from interface: Database

Is this AbstractDatabase subclass the correct one to use for the given connection.

Throws:

DatabaseException

getDefaultCatalogName

public String getDefaultCatalogName()

Specified by:

getDefaultCatalogName in interface Database

Overrides:

getDefaultCatalogName in class AbstractJdbcDatabase

getConnectionSchemaName

protected String getConnectionSchemaName()

Description copied from class: AbstractJdbcDatabase

Overwrite this method to get the default schema name for the connection. If you only need to change the statement that obtains the current schema then override

Overrides:

getConnectionSchemaName in class AbstractJdbcDatabase

See Also:

• AbstractJdbcDatabase.getConnectionSchemaNameCallStatement()

getViewDefinition

public String getViewDefinition(CatalogAndSchema schema,
 String viewName)
                         throws DatabaseException

Specified by:

getViewDefinition in interface Database

Overrides:

getViewDefinition in class AbstractJdbcDatabase

Throws:

DatabaseException

supportsInitiallyDeferrableColumns

public boolean supportsInitiallyDeferrableColumns()

Description copied from interface: Database

Returns whether this database support initially deferrable columns.

supportsDropTableCascadeConstraints

public boolean supportsDropTableCascadeConstraints()

Specified by:

supportsDropTableCascadeConstraints in interface Database

Overrides:

supportsDropTableCascadeConstraints in class AbstractJdbcDatabase

supportsTablespaces

public boolean supportsTablespaces()

getSystemViews

public Set<String> getSystemViews()

Description copied from class: AbstractJdbcDatabase

Returns system (undroppable) views.

Overrides:

getSystemViews in class AbstractJdbcDatabase

supportsSequences

public boolean supportsSequences()

Description copied from class: AbstractJdbcDatabase

Does the database type support sequence.

Specified by:

supportsSequences in interface Database

Overrides:

supportsSequences in class AbstractJdbcDatabase

getAutoIncrementClause

protected String getAutoIncrementClause()

Overrides:

getAutoIncrementClause in class AbstractJdbcDatabase

generateAutoIncrementStartWith

protected boolean generateAutoIncrementStartWith(BigInteger startWith)

Overrides:

generateAutoIncrementStartWith in class AbstractJdbcDatabase

generateAutoIncrementBy

protected boolean generateAutoIncrementBy(BigInteger incrementBy)

Overrides:

generateAutoIncrementBy in class AbstractJdbcDatabase

setAutoCommit

public void setAutoCommit(boolean b)
                   throws DatabaseException

Specified by:

setAutoCommit in interface Database

Overrides:

setAutoCommit in class AbstractJdbcDatabase

Throws:

DatabaseException

getJdbcCatalogName

public String getJdbcCatalogName(CatalogAndSchema schema)

Overrides:

getJdbcCatalogName in class AbstractJdbcDatabase

escapeIndexName

public String escapeIndexName(String catalogName,
 String schemaName,
 String indexName)

Specified by:

escapeIndexName in interface Database

Overrides:

escapeIndexName in class AbstractJdbcDatabase

setConnection

public void setConnection(DatabaseConnection conn)

Specified by:

setConnection in interface Database

Overrides:

setConnection in class AbstractJdbcDatabase

requiresExplicitNullForColumns

public boolean requiresExplicitNullForColumns()

Description copied from interface: Database

Does the database require explicit NULL for nullable columns?

Specified by:

requiresExplicitNullForColumns in interface Database

Overrides:

requiresExplicitNullForColumns in class AbstractJdbcDatabase

Returns:

true if the database behaves incorrectly if NULL is not explicitly specified, false if it behaves like any good RDBMS should.

getMaxFractionalDigitsForTimestamp

public int getMaxFractionalDigitsForTimestamp()

Description copied from class: AbstractJdbcDatabase

Most relational databases support 9 fractional digits, and subclasses must overwrite this method if they support less than that.

Specified by:

getMaxFractionalDigitsForTimestamp in interface Database

Overrides:

getMaxFractionalDigitsForTimestamp in class AbstractJdbcDatabase

Returns:

the maximum number of supported fractional digits in TIMESTAMP columns

afterUpdate

public void afterUpdate()
                 throws LiquibaseException

Description copied from interface: Database

Allows the database to perform actions after an update is finished, i.e. after the last change of a changelog was applied.

Throws:

LiquibaseException