Interface StatementCallback

public interface StatementCallback

Generic callback interface for code that operates on a JDBC Statement. Allows to execute any number of operations on a single Statement, for example a single executeUpdate call or repeated executeUpdate calls with varying SQL.

Used internally by JdbcTemplate, but also useful for application code.

Juergen Hoeller
See Also:

Method Summary
 Object doInStatement(Statement stmt)
          Gets called by JdbcTemplate.execute with an active JDBC Statement.

Method Detail


public Object doInStatement(Statement stmt)
                     throws SQLException,
Gets called by JdbcTemplate.execute with an active JDBC Statement. Does not need to care about activating or closing the Connection, or handling transactions.

If called without a thread-bound JDBC transaction (initiated by DataSourceTransactionManager), the code will simply get executed on the JDBC connection with its transactional semantics. If JdbcTemplate is configured to use a JTA-aware DataSource, the JDBC connection and thus the callback code will be transactional if a JTA transaction is active.

Allows for returning a result object created within the callback, i.e. a domain object or a collection of domain objects. Note that there's special support for single step actions: see JdbcTemplate.queryForObject etc. A thrown RuntimeException is treated as application exception, it gets propagated to the caller of the template.

stmt - active JDBC Statement
a result object, or null if none
SQLException - if thrown by a JDBC method, to be auto-converted to a DataAccessException by a SQLExceptionTranslator
DataAccessException - in case of custom exceptions
See Also:
JdbcTemplate.queryForObject(String, Class), JdbcTemplate.queryForList(String)

Copyright (C) 2003-2004 The Spring Framework Project.