com.atlassian.bamboo.utils.db
Class MsSqlDbmsBean

java.lang.Object
  com.atlassian.bamboo.utils.db.AbstractDbmsBean
      com.atlassian.bamboo.utils.db.MsSqlDbmsBean

All Implemented Interfaces:

DbmsBean

public class MsSqlDbmsBean
extends AbstractDbmsBean

Constructor Summary

MsSqlDbmsBean()

Method Summary

protected void	dropConstraints(java.sql.Statement statement, java.lang.String tableName, java.lang.String columnName, java.util.List<java.lang.String> defaultConstraintNames)
protected void	dropIndex(java.sql.Statement statement, java.lang.String indexName)
java.lang.String	getQuery(SqlQueryProvider sqlQueryProvider) Provide a different SQL query depending on SQL engine used.
boolean	isMsSqlServer()
java.sql.PreparedStatement	prepareStatement(java.sql.Connection connection, PreparedStatementProvider preparedStatementProvider) Provide a different PreparedStatement depending on SQL engine used.

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

dropColumn, dropColumn, isColumnPresent, isColumnPresent, isHsqldb, isMySql, isOracle, isPostgreSql, isTablePresent, isTablePresent

Methods inherited from class java.lang.Object

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

Constructor Detail

MsSqlDbmsBean

public MsSqlDbmsBean()

Method Detail

getQuery

@NotNull
public java.lang.String getQuery(@NotNull
                                         SqlQueryProvider sqlQueryProvider)

Description copied from interface: DbmsBean

Provide a different SQL query depending on SQL engine used.

Returns:

prepareStatement

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

Description copied from interface: DbmsBean

Provide a different PreparedStatement depending on SQL engine used.

Returns:

Throws:

java.sql.SQLException

isMsSqlServer

public boolean isMsSqlServer()

Specified by:

isMsSqlServer in interface DbmsBean

Overrides:

isMsSqlServer in class AbstractDbmsBean

Returns:

true if db configured in Hibernate is Microsoft SQL Server

dropIndex

protected void dropIndex(java.sql.Statement statement,
                         java.lang.String indexName)
                  throws java.sql.SQLException

Overrides:

dropIndex in class AbstractDbmsBean

Throws:

java.sql.SQLException

dropConstraints

protected void dropConstraints(java.sql.Statement statement,
                               java.lang.String tableName,
                               java.lang.String columnName,
                               java.util.List<java.lang.String> defaultConstraintNames)

Overrides:

dropConstraints in class AbstractDbmsBean