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

java.sql.PreparedStatement	prepareDefaultStatement(java.sql.Connection connection)
java.sql.PreparedStatement	prepareHsqlStatement(java.sql.Connection connection)
java.sql.PreparedStatement	prepareMsSqlStatement(java.sql.Connection connection)
java.sql.PreparedStatement	prepareMySqlStatement(java.sql.Connection connection)
java.sql.PreparedStatement	prepareOracleStatement(java.sql.Connection connection)
java.sql.PreparedStatement	preparePostgreSqlStatement(java.sql.Connection connection)

Method Detail

prepareDefaultStatement

@NotNull
java.sql.PreparedStatement prepareDefaultStatement(@NotNull
                                                           java.sql.Connection connection)
                                                   throws java.sql.SQLException

Returns:

default SQL query

Throws:

java.sql.SQLException

prepareHsqlStatement

@NotNull
java.sql.PreparedStatement prepareHsqlStatement(@NotNull
                                                        java.sql.Connection connection)
                                                throws java.sql.SQLException

Returns:

specialized/optimised SQL query for HSQL engine

Throws:

java.sql.SQLException

prepareMsSqlStatement

@NotNull
java.sql.PreparedStatement prepareMsSqlStatement(@NotNull
                                                         java.sql.Connection connection)
                                                 throws java.sql.SQLException

Returns:

specialized/optimised SQL query for SQL Server engine

Throws:

java.sql.SQLException

prepareMySqlStatement

@NotNull
java.sql.PreparedStatement prepareMySqlStatement(@NotNull
                                                         java.sql.Connection connection)
                                                 throws java.sql.SQLException

Returns:

specialized/optimised SQL query for MySQL engine

Throws:

java.sql.SQLException

prepareOracleStatement

@NotNull
java.sql.PreparedStatement prepareOracleStatement(@NotNull
                                                          java.sql.Connection connection)
                                                  throws java.sql.SQLException

Returns:

specialized/optimised SQL query for Oracle engine

Throws:

java.sql.SQLException

preparePostgreSqlStatement

@NotNull
java.sql.PreparedStatement preparePostgreSqlStatement(@NotNull
                                                              java.sql.Connection connection)
                                                      throws java.sql.SQLException

Returns:

specialized/optimised SQL query for PostgreSQL engine

Throws:

java.sql.SQLException