com.atlassian.bamboo.utils.db

Interface PreparedStatementProvider

All Known Implementing Classes:

AbstractPreparedStatementProvider

public interface PreparedStatementProvider

Used to provide proper PreparedStatement for a gived DB engine.

See Also:

DbmsBean

Method Summary

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