com.atlassian.bamboo.utils.db

Interface PreparedStatementProvider

public interface PreparedStatementProvider

Used to provide proper PreparedStatement for a gived DB engine.

See Also:

DbmsBean#

Method Summary

Methods

Modifier and Type	Method and Description
PreparedStatement	prepareDefaultStatement(Connection connection)
PreparedStatement	prepareHsqlStatement(Connection connection)
PreparedStatement	prepareMsSqlStatement(Connection connection)
PreparedStatement	prepareMySqlStatement(Connection connection)
PreparedStatement	prepareOracleStatement(Connection connection)
PreparedStatement	preparePostgreSqlStatement(Connection connection)

Method Detail

prepareDefaultStatement

@NotNull
PreparedStatement prepareDefaultStatement(@NotNull
                                                Connection connection)
                                          throws SQLException

Returns:

default SQL query

Throws:

SQLException

prepareHsqlStatement

@NotNull
PreparedStatement prepareHsqlStatement(@NotNull
                                             Connection connection)
                                       throws SQLException

Returns:

specialized/optimised SQL query for HSQL engine

Throws:

SQLException

prepareMsSqlStatement

@NotNull
PreparedStatement prepareMsSqlStatement(@NotNull
                                              Connection connection)
                                        throws SQLException

Returns:

specialized/optimised SQL query for SQL Server engine

Throws:

SQLException

prepareMySqlStatement

@NotNull
PreparedStatement prepareMySqlStatement(@NotNull
                                              Connection connection)
                                        throws SQLException

Returns:

specialized/optimised SQL query for MySQL engine

Throws:

SQLException

prepareOracleStatement

@NotNull
PreparedStatement prepareOracleStatement(@NotNull
                                               Connection connection)
                                         throws SQLException

Returns:

specialized/optimised SQL query for Oracle engine

Throws:

SQLException

preparePostgreSqlStatement

@NotNull
PreparedStatement preparePostgreSqlStatement(@NotNull
                                                   Connection connection)
                                             throws SQLException

Returns:

specialized/optimised SQL query for PostgreSQL engine

Throws:

SQLException