com.atlassian.bamboo.utils.db

Class HsqlDbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

com.atlassian.bamboo.utils.db.HsqlDbmsBean

All Implemented Interfaces:

DbmsBean

public class HsqlDbmsBean
extends AbstractDbmsBean

Nested Class Summary

Nested classes/interfaces inherited from interface com.atlassian.bamboo.utils.db.DbmsBean

DbmsBean.ColumnDefinition, DbmsBean.ConstraintDefinition, DbmsBean.IndexDefinition

Field Summary

Fields inherited from class com.atlassian.bamboo.utils.db.AbstractDbmsBean

LARGE_STRING_TYPE

Constructor Summary

Constructors

Constructor and Description
HsqlDbmsBean()

Method Summary

Modifier and Type	Method and Description
protected void	dropConstraints(Connection connection, String tableName, String columnName)
void	dropPrimaryKey(Connection connection, String tableName) Drops the primary key on a table.
String	getConcat(String... values) Provide a different SQL concatenation operator depending on SQL engine used.
Collection<DbmsBean.ConstraintDefinition>	getConstraints(Connection connection, String table, String column) http://hsqldb.sourcearchive.com/documentation/1.8.0.10-10/classorg_1_1hsqldb_1_1DatabaseInformationFull.html
DatabaseType	getDatabaseType() Detect used database type
Collection<DbmsBean.IndexDefinition>	getIndices(Connection c, String table)
String	getQuery(SqlQueryProvider sqlQueryProvider) Provide a different SQL query depending on SQL engine used.
protected String	getSchemaUncached(Connection c)
boolean	isHsqldb()
PreparedStatement	prepareStatement(Connection connection, PreparedStatementProvider preparedStatementProvider) Provide a different PreparedStatement depending on SQL engine used.
void	renameColumn(Connection c, String tableName, String oldName, String newName) Rename columns.
void	resizeVarcharColumn(Connection connection, String tableName, String columnName, int newSize, boolean isNullable, String defaultValue)

Methods inherited from class com.atlassian.bamboo.utils.db.AbstractDbmsBean

actuallyChangeColumnToNotNull, addColumn, changeColumnDefinition, changeColumnToNotNull, changeColumnType, changeTableNameToUpperCase, createIndex, createPrimaryKey, createUniqueConstraint, dropColumn, dropConstraint, dropForeignKeyConstraint, dropIndex, dropIndexIfExists, dropTable, getColumnDefinition, getColumns, getConstraintDefinitions, getConstraintType, getIndexNames, getSchema, getTables, isColumnPresent, isColumnPresent, isColumnPresent, isMsSqlServer, isMySql, isOracle, isPostgreSql, isTablePresent, migrateColumnType, newColumnDefinition, quote

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.atlassian.bamboo.utils.db.DbmsBean

getCatalog

Constructor Detail

HsqlDbmsBean

public HsqlDbmsBean()

Method Detail

getQuery

@NotNull
public String getQuery(@NotNull
                                SqlQueryProvider sqlQueryProvider)

Description copied from interface: DbmsBean

Provide a different SQL query depending on SQL engine used.

Returns:

getConcat

@NotNull
public String getConcat(String... values)

Description copied from interface: DbmsBean

Provide a different SQL concatenation operator depending on SQL engine used.

Parameters:

values - the values to concatenate.

Returns:

the concatenation SQL to append to a query.

getConstraints

@NotNull
public Collection<DbmsBean.ConstraintDefinition> getConstraints(Connection connection,
                                                                         @NotNull
                                                                         String table,
                                                                         @Nullable
                                                                         String column)
                                                                  throws SQLException

http://hsqldb.sourcearchive.com/documentation/1.8.0.10-10/classorg_1_1hsqldb_1_1DatabaseInformationFull.html

Throws:

SQLException

prepareStatement

@NotNull
public PreparedStatement prepareStatement(@NotNull
                                                   Connection connection,
                                                   @NotNull
                                                   PreparedStatementProvider preparedStatementProvider)
                                            throws SQLException

Description copied from interface: DbmsBean

Provide a different PreparedStatement depending on SQL engine used.

Returns:

Throws:

SQLException

resizeVarcharColumn

public void resizeVarcharColumn(@NotNull
                                Connection connection,
                                String tableName,
                                String columnName,
                                int newSize,
                                boolean isNullable,
                                @Nullable
                                String defaultValue)
                         throws SQLException

Throws:

SQLException

isHsqldb

public boolean isHsqldb()

Specified by:

isHsqldb in interface DbmsBean

Overrides:

isHsqldb in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is HSQL

getDatabaseType

public DatabaseType getDatabaseType()

Description copied from interface: DbmsBean

Detect used database type

Returns:

database type

dropConstraints

protected void dropConstraints(Connection connection,
                               String tableName,
                               String columnName)

Overrides:

dropConstraints in class AbstractDbmsBean

dropPrimaryKey

public void dropPrimaryKey(Connection connection,
                           String tableName)
                    throws SQLException

Description copied from interface: DbmsBean

Drops the primary key on a table.

Throws:

SQLException

renameColumn

public void renameColumn(Connection c,
                         String tableName,
                         String oldName,
                         String newName)
                  throws SQLException

Description copied from interface: DbmsBean

Rename columns.

Specified by:

renameColumn in interface DbmsBean

Specified by:

renameColumn in class AbstractDbmsBean

Throws:

SQLException

getIndices

public Collection<DbmsBean.IndexDefinition> getIndices(Connection c,
                                                       @NotNull
                                                       String table)
                                                throws SQLException

Specified by:

getIndices in interface DbmsBean

Overrides:

getIndices in class AbstractDbmsBean

Throws:

SQLException

getSchemaUncached

@Nullable
protected String getSchemaUncached(Connection c)
                                      throws SQLException

Overrides:

getSchemaUncached in class AbstractDbmsBean

Throws:

SQLException