Package com.atlassian.bamboo.utils.db

Class OracleDbmsBean

java.lang.Object

com.atlassian.bamboo.utils.db.AbstractDbmsBean

com.atlassian.bamboo.utils.db.OracleDbmsBean

All Implemented Interfaces:

BambooDatabaseTypeProvider, DbmsBean

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

Method Summary

Modifier and Type	Method	Description
void	actuallyChangeColumnToNotNull(Connection c, String tableName, String columnName)
@NotNull String	clobEquals(@NotNull String columnName)	Comparison string for CLOB column.
void	dropIndex(Connection c, String table, String index)
void	dropPrimaryKey(Connection connection, String tableName)	Drops the primary key on a table.
@NotNull String	getConcat(String... values)	Provide a different SQL concatenation operator depending on SQL engine used.
@NotNull Collection<DbmsBean.ConstraintDefinition>	getConstraints(Connection connection, @NotNull String table, @Nullable String column)	Fetch information about constraints
protected DbmsBean.ConstraintDefinition.ConstraintType	getConstraintType(String typeName)	https://docs.oracle.com/database/121/REFRN/GUID-9C96DA92-CFE0-4A3F-9061-C5ED17B43EFE.htm#REFRN20047
DatabaseType	getDatabaseType()	Detect used database type
Collection<DbmsBean.IndexDefinition>	getIndices(@NotNull Connection c, @NotNull String table)
@NotNull String	getQuery(@NotNull SqlQueryProvider sqlQueryProvider)	Provide a different SQL query depending on SQL engine used.
boolean	isOracle()
void	renameColumn(Connection c, String tableName, String oldName, String newName)	Rename columns.
void	resizeVarcharColumn(@NotNull Connection connection, String tableName, String columnName, int newSize, boolean isNullable, @Nullable String defaultValue)

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

addColumn, changeColumnDefinition, changeColumnToNotNull, changeColumnType, changeTableNameToUpperCase, createColumn, createIndex, createPrimaryKey, createUniqueConstraint, dropColumn, dropConstraint, dropConstraints, dropForeignKeyConstraint, dropIndexIfExists, dropTable, getColumnDefinition, getColumnDefinitionString, getColumns, getConstraintDefinitions, getIndexNames, getLargeTextTypeName, getSchema, getSchemaUncached, getSqlTypeName, getTables, isColumnPresent, isColumnPresent, isColumnPresent, isH2, isHsqldb, isMsSqlServer, isMySql, 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 Details

OracleDbmsBean

public OracleDbmsBean()

Method Details

getConstraints

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

Description copied from interface: DbmsBean

Fetch information about constraints

Throws:

SQLException

getConstraintType

protected DbmsBean.ConstraintDefinition.ConstraintType getConstraintType(String typeName)

https://docs.oracle.com/database/121/REFRN/GUID-9C96DA92-CFE0-4A3F-9061-C5ED17B43EFE.htm#REFRN20047

Overrides:

getConstraintType in class AbstractDbmsBean

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

getQuery

@NotNull
public @NotNull String getQuery(@NotNull
 @NotNull SqlQueryProvider sqlQueryProvider)

Description copied from interface: DbmsBean

Provide a different SQL query depending on SQL engine used.

Returns:

getConcat

@NotNull
public @NotNull 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.

resizeVarcharColumn

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

Throws:

SQLException

isOracle

public boolean isOracle()

Specified by:

isOracle in interface DbmsBean

Overrides:

isOracle in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is Oracle

getDatabaseType

public DatabaseType getDatabaseType()

Description copied from interface: BambooDatabaseTypeProvider

Detect used database type

Returns:

database type

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

actuallyChangeColumnToNotNull

public void actuallyChangeColumnToNotNull(Connection c,
 String tableName,
 String columnName)
                                   throws SQLException

Overrides:

actuallyChangeColumnToNotNull in class AbstractDbmsBean

Throws:

SQLException

getIndices

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

Specified by:

getIndices in interface DbmsBean

Overrides:

getIndices in class AbstractDbmsBean

Throws:

SQLException

clobEquals

@NotNull
public @NotNull String clobEquals(@NotNull
 @NotNull String columnName)

Description copied from interface: DbmsBean

Comparison string for CLOB column.

Specified by:

clobEquals in interface DbmsBean

Overrides:

clobEquals in class AbstractDbmsBean

Parameters:

columnName - column name

Returns:

string for prepared statement