com.atlassian.bamboo.utils.db

Class H2DbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

com.atlassian.bamboo.utils.db.H2DbmsBean

All Implemented Interfaces:

DbmsBean

public class H2DbmsBean
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
H2DbmsBean()

Method Summary

Modifier and Type	Method and Description
void	dropIndex(Connection c, String table, String index)
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.
protected List<DbmsBean.ConstraintDefinition>	getConstraintDefinitions(Connection connection, String query, String column) Finds all constraints affecting given column.
Collection<DbmsBean.ConstraintDefinition>	getConstraints(Connection connection, String table, String column) Fetch information about constraints
protected DbmsBean.ConstraintDefinition.ConstraintType	getConstraintType(String typeName)
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 void	handleException(Connection connection, String table, org.h2.jdbc.JdbcSQLException e, BambooRunnables.Throwing<SQLException> command) Attempts to handle an SQL exception, performing command after properly fixing the state of the database if the cause of the problem is known.
boolean	isH2()
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, clobEquals, createColumn, createIndex, createPrimaryKey, createUniqueConstraint, dropColumn, dropConstraint, dropConstraints, dropForeignKeyConstraint, dropIndexIfExists, dropTable, getColumnDefinition, getColumns, getConstraintDefinitions, getIndexNames, getLargeTextTypeName, getSchema, getSchemaUncached, getSqlTypeName, getTables, isColumnPresent, isColumnPresent, isColumnPresent, isHsqldb, isMsSqlServer, isMySql, isOracle, isPostgreSql, isTable, isTablePresent, migrateColumnType, newColumnDefinition, quote, quoteIfNeeded, toLowerCase

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

H2DbmsBean

public H2DbmsBean()

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,
                                                                         String table,
                                                                         @Nullable
                                                                         String column)
                                                                  throws SQLException

Description copied from interface: DbmsBean

Fetch information about constraints

Throws:

SQLException

getConstraintDefinitions

protected List<DbmsBean.ConstraintDefinition> getConstraintDefinitions(Connection connection,
                                                                       String query,
                                                                       @Nullable
                                                                       String column)
                                                                throws SQLException

Finds all constraints affecting given column. Constraints affecting more than one column will be included.

Throws:

SQLException

getConstraintType

protected DbmsBean.ConstraintDefinition.ConstraintType getConstraintType(String typeName)

Overrides:

getConstraintType in class AbstractDbmsBean

resizeVarcharColumn

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

Throws:

SQLException

getDatabaseType

public DatabaseType getDatabaseType()

Description copied from interface: DbmsBean

Detect used database type

Returns:

database type

isH2

public boolean isH2()

Specified by:

isH2 in interface DbmsBean

Overrides:

isH2 in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is H2

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

dropIndex

public void dropIndex(Connection c,
                      String table,
                      String index)
               throws SQLException

Specified by:

dropIndex in interface DbmsBean

Overrides:

dropIndex in class AbstractDbmsBean

Throws:

SQLException

handleException

protected void handleException(@NotNull
                               Connection connection,
                               @NotNull
                               String table,
                               @NotNull
                               org.h2.jdbc.JdbcSQLException e,
                               @NotNull
                               BambooRunnables.Throwing<SQLException> command)
                        throws SQLException

Attempts to handle an SQL exception, performing command after properly fixing the state of the database if the cause of the problem is known. Re-throws the exception if the cause is unknown.

Parameters:

connection - database connection

table - table to which the problem is related

e - exception thrown

command - command to execute after properly addressing the issue

Throws:

SQLException - if thrown by command, or if exception could not be handled and e is rethrown

getIndices

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

Specified by:

getIndices in interface DbmsBean

Overrides:

getIndices in class AbstractDbmsBean

Throws:

SQLException