org.hibernate.jdbc

Interface Batcher

All Known Implementing Classes:

AbstractBatcher, BatchingBatcher, NonBatchingBatcher

public interface Batcher

Manages PreparedStatements for a session. Abstracts JDBC batching to maintain the illusion that a single logical batch exists for the whole session, even when batching is disabled. Provides transparent PreparedStatement caching.

Author:

Gavin King

See Also:

PreparedStatement, SessionImpl

Method Summary

Methods

Modifier and Type	Method and Description
void	abortBatch(java.sql.SQLException sqle) Must be called when an exception occurs
void	addToBatch(Expectation expectation) Add an insert / delete / update to the current batch (might be called multiple times for single prepareBatchStatement())
void	cancelLastQuery() Cancel the current query statement
void	closeConnection(java.sql.Connection conn) Deprecated. Obtain connections from ConnectionProvider instead
void	closeQueryStatement(java.sql.PreparedStatement ps, java.sql.ResultSet rs) Close a prepared statement opened with prepareQueryStatement()
void	closeStatement(java.sql.PreparedStatement ps) Close a prepared or callable statement opened using prepareStatement() or prepareCallableStatement()
void	closeStatements() Close any query statements that were left lying around
void	executeBatch() Execute the batch
java.sql.ResultSet	getResultSet(java.sql.CallableStatement ps, Dialect dialect) Execute the statement and return the result set from a callable statement
java.sql.ResultSet	getResultSet(java.sql.PreparedStatement ps) Execute the statement and return the result set
boolean	hasOpenResources()
java.sql.Connection	openConnection() Deprecated. Obtain connections from ConnectionProvider instead
java.lang.String	openResourceStatsAsString()
java.sql.CallableStatement	prepareBatchCallableStatement(java.lang.String sql) Get a batchable callable statement to use for inserting / deleting / updating (might be called many times before a single call to executeBatch()).
java.sql.PreparedStatement	prepareBatchStatement(java.lang.String sql) Get a batchable prepared statement to use for inserting / deleting / updating (might be called many times before a single call to executeBatch()).
java.sql.CallableStatement	prepareCallableQueryStatement(java.lang.String sql, boolean scrollable, ScrollMode scrollMode) Get a prepared statement for use in loading / querying.
java.sql.CallableStatement	prepareCallableStatement(java.lang.String sql) Get a non-batchable callable statement to use for inserting / deleting / updating.
java.sql.PreparedStatement	prepareQueryStatement(java.lang.String sql, boolean scrollable, ScrollMode scrollMode) Get a prepared statement for use in loading / querying.
java.sql.PreparedStatement	prepareSelectStatement(java.lang.String sql) Get a non-batchable prepared statement to use for selecting.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql) Get a non-batchable prepared statement to use for inserting / deleting / updating.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, boolean useGetGeneratedKeys) Get a non-batchable prepared statement to use for inserting / deleting / updating, using JDBC3 getGeneratedKeys (Connection.prepareStatement(String, int)).
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames) Get a non-batchable prepared statement to use for inserting / deleting / updating.
void	setTransactionTimeout(int seconds) Set the transaction timeout to seconds later than the current system time.
void	unsetTransactionTimeout() Unset the transaction timeout, called after the end of a transaction.

Method Detail

prepareQueryStatement

java.sql.PreparedStatement prepareQueryStatement(java.lang.String sql,
                                               boolean scrollable,
                                               ScrollMode scrollMode)
                                                 throws java.sql.SQLException,
                                                        HibernateException

Get a prepared statement for use in loading / querying. If not explicitly released by closeQueryStatement(), it will be released when the session is closed or disconnected.

Throws:

java.sql.SQLException

HibernateException

closeQueryStatement

void closeQueryStatement(java.sql.PreparedStatement ps,
                       java.sql.ResultSet rs)
                         throws java.sql.SQLException

Close a prepared statement opened with prepareQueryStatement()

Throws:

java.sql.SQLException

prepareCallableQueryStatement

java.sql.CallableStatement prepareCallableQueryStatement(java.lang.String sql,
                                                       boolean scrollable,
                                                       ScrollMode scrollMode)
                                                         throws java.sql.SQLException,
                                                                HibernateException

Get a prepared statement for use in loading / querying. If not explicitly released by closeQueryStatement(), it will be released when the session is closed or disconnected.

Throws:

java.sql.SQLException

HibernateException

prepareSelectStatement

java.sql.PreparedStatement prepareSelectStatement(java.lang.String sql)
                                                  throws java.sql.SQLException,
                                                         HibernateException

Get a non-batchable prepared statement to use for selecting. Does not result in execution of the current batch.

Throws:

java.sql.SQLException

HibernateException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                          boolean useGetGeneratedKeys)
                                            throws java.sql.SQLException,
                                                   HibernateException

Get a non-batchable prepared statement to use for inserting / deleting / updating, using JDBC3 getGeneratedKeys (Connection.prepareStatement(String, int)).

Must be explicitly released by closeStatement(java.sql.PreparedStatement) after use.

Throws:

java.sql.SQLException

HibernateException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                          java.lang.String[] columnNames)
                                            throws java.sql.SQLException,
                                                   HibernateException

Get a non-batchable prepared statement to use for inserting / deleting / updating. using JDBC3 getGeneratedKeys (Connection.prepareStatement(String, String[])).

Must be explicitly released by closeStatement(java.sql.PreparedStatement) after use.

Throws:

java.sql.SQLException

HibernateException

prepareStatement

java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException,
                                                   HibernateException

Get a non-batchable prepared statement to use for inserting / deleting / updating.

Must be explicitly released by closeStatement(java.sql.PreparedStatement) after use.

Throws:

java.sql.SQLException

HibernateException

prepareCallableStatement

java.sql.CallableStatement prepareCallableStatement(java.lang.String sql)
                                                    throws java.sql.SQLException,
                                                           HibernateException

Get a non-batchable callable statement to use for inserting / deleting / updating.

Must be explicitly released by closeStatement(java.sql.PreparedStatement) after use.

Throws:

java.sql.SQLException

HibernateException

closeStatement

void closeStatement(java.sql.PreparedStatement ps)
                    throws java.sql.SQLException

Close a prepared or callable statement opened using prepareStatement() or prepareCallableStatement()

Throws:

java.sql.SQLException

prepareBatchStatement

java.sql.PreparedStatement prepareBatchStatement(java.lang.String sql)
                                                 throws java.sql.SQLException,
                                                        HibernateException

Get a batchable prepared statement to use for inserting / deleting / updating (might be called many times before a single call to executeBatch()). After setting parameters, call addToBatch - do not execute the statement explicitly.

Throws:

java.sql.SQLException

HibernateException

See Also:

addToBatch(org.hibernate.jdbc.Expectation)

prepareBatchCallableStatement

java.sql.CallableStatement prepareBatchCallableStatement(java.lang.String sql)
                                                         throws java.sql.SQLException,
                                                                HibernateException

Get a batchable callable statement to use for inserting / deleting / updating (might be called many times before a single call to executeBatch()). After setting parameters, call addToBatch - do not execute the statement explicitly.

Throws:

java.sql.SQLException

HibernateException

See Also:

addToBatch(org.hibernate.jdbc.Expectation)

addToBatch

void addToBatch(Expectation expectation)
                throws java.sql.SQLException,
                       HibernateException

Add an insert / delete / update to the current batch (might be called multiple times for single prepareBatchStatement())

Throws:

java.sql.SQLException

HibernateException

executeBatch

void executeBatch()
                  throws HibernateException

Execute the batch

Throws:

HibernateException

closeStatements

void closeStatements()

Close any query statements that were left lying around

getResultSet

java.sql.ResultSet getResultSet(java.sql.PreparedStatement ps)
                                throws java.sql.SQLException

Execute the statement and return the result set

Throws:

java.sql.SQLException

getResultSet

java.sql.ResultSet getResultSet(java.sql.CallableStatement ps,
                              Dialect dialect)
                                throws java.sql.SQLException

Execute the statement and return the result set from a callable statement

Throws:

java.sql.SQLException

abortBatch

void abortBatch(java.sql.SQLException sqle)

Must be called when an exception occurs

Parameters:

sqle - the (not null) exception that is the reason for aborting

cancelLastQuery

void cancelLastQuery()
                     throws HibernateException

Cancel the current query statement

Throws:

HibernateException

hasOpenResources

boolean hasOpenResources()

openResourceStatsAsString

java.lang.String openResourceStatsAsString()

openConnection

java.sql.Connection openConnection()
                                   throws HibernateException

Deprecated. Obtain connections from ConnectionProvider instead

Obtain a JDBC connection

Throws:

HibernateException

closeConnection

void closeConnection(java.sql.Connection conn)
                     throws HibernateException

Deprecated. Obtain connections from ConnectionProvider instead

Dispose of the JDBC connection

Throws:

HibernateException

setTransactionTimeout

void setTransactionTimeout(int seconds)

Set the transaction timeout to seconds later than the current system time.

unsetTransactionTimeout

void unsetTransactionTimeout()

Unset the transaction timeout, called after the end of a transaction.