Classes to Control Basic JDBC Processing and Error Handling . . . . . . . . . 70 3.3.1. Using JdbcTemplate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Updating (INSERT, UPDATE, and DELETE) with JdbcTemplate. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Other JdbcTemplate Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 JdbcTemplate Best Practices. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

case of unknown number of rows expected * JdbcTemplate logs all warnings in case of "ignoreWarnings"=true, not just the first warning in the chain * JdbcTemplate logs SQLWarnings at debug instead of warn warn logs for acceptable conditions * JdbcTemplate uses "PreparedStatement.setObject(index, null)" for null values with unknown SQL type on Informix * JdbcTemplate by default uses "PreparedStatement.setString" (including String and StringBuilder) * JdbcTemplate does not check static SQL for bind parameters anymore, to avoid overhead of double parsing * JdbcTemplate's "queryForObject" uses "requiredSingleResult"

failed (for Hibernate 3.1) * turned JdbcTemplate's "query(PreparedStatementCreator,PreparedStatementSetter,ResultSetExtractor rse)" method public * improved JdbcTemplate's logging of ignored SQLWarnings SQLWarnings, including SQL state and error code in the log output * JdbcTemplate's "queryForObject"/"queryForInt"/etc methods correctly detect incorrect result sizes even for null values * added "allowsUnusedParameters()" TransactionAwareDataSourceProxy works correctly in combination with JdbcTemplate and transaction suspend/resume now * fixed JdbcTemplate to extract the JDBC Connection for CallableStatementCreators if a

TransactionAwareDataSourceProxy works correctly in combination with JdbcTemplate and transaction suspend/resume now * fixed JdbcTemplate to extract the JDBC Connection for CallableStatementCreators if a * factored out protected "getColumnMapRowMapper" and "getSingleColumnRowMapper" hooks within JdbcTemplate * SingleColumnRowMapper explicitly calls "ResultSet.getBigDecimal()" if the required type is Connections (e.g. from SUPPORTS) * JdbcTemplate applies "fetchSize" and "maxRows" settings to all created Statements, not just to "query" operations * JdbcTemplate exposes Connection proxy to ConnectionCallbacks

Connections (e.g. from SUPPORTS) * JdbcTemplate applies "fetchSize" and "maxRows" settings to all created Statements, not just to "query" operations * JdbcTemplate exposes Connection proxy to ConnectionCallbacks value is null and type unknown * JdbcTemplate's "update" version with a KeyHolder argument explicitly closes the generated keys ResultSet, if any * removed JdbcTemplate's fetchSize/maxRows check to allow transaction synchronization to correctly handle suspension even from beforeCompletion/afterCompletion * JdbcTemplate releases Connection early, to avoid potential connection pool deadlock due to SQLException translation

value is null and type unknown * JdbcTemplate's "update" version with a KeyHolder argument explicitly closes the generated keys ResultSet, if any * removed JdbcTemplate's fetchSize/maxRows check to allow transaction synchronization to correctly handle suspension even from beforeCompletion/afterCompletion * JdbcTemplate releases Connection early, to avoid potential connection pool deadlock due to SQLException translation added "queryForRowSet" methods to JdbcTemplate, returning a SqlRowSet as generic representation of the result rows * added "queryForObject" convenience methods to JdbcTemplate, taking a RowMapper argument

value is null and type unknown * JdbcTemplate's "update" version with a KeyHolder argument explicitly closes the generated keys ResultSet, if any * removed JdbcTemplate's fetchSize/maxRows check to allow transaction synchronization to correctly handle suspension even from beforeCompletion/afterCompletion * JdbcTemplate releases Connection early, to avoid potential connection pool deadlock due to SQLException translation added "queryForRowSet" methods to JdbcTemplate, returning a SqlRowSet as generic representation of the result rows * added "queryForObject" convenience methods to JdbcTemplate, taking a RowMapper argument

transaction synchronization to correctly handle suspension even from beforeCompletion/afterCompletion * JdbcTemplate releases Connection early, to avoid potential connection pool deadlock due to SQLException translation added "queryForRowSet" methods to JdbcTemplate, returning a SqlRowSet as generic representation of the result rows * added "queryForObject" convenience methods to JdbcTemplate, taking a RowMapper argument argument to JdbcTemplate, for extracting values from a single column * added "queryForMap" methods to JdbcTemplate, creating a Map representation for the columns of a single row * refined JdbcTemplate's "q

added "queryForRowSet" methods to JdbcTemplate, returning a SqlRowSet as generic representation of the result rows * added "queryForObject" convenience methods to JdbcTemplate, taking a RowMapper argument argument to JdbcTemplate, for extracting values from a single column * added "queryForMap" methods to JdbcTemplate, creating a Map representation for the columns of a single row * refined JdbcTemplate's "q "jdbc.core" * factored out protected "createJdbcTemplate" in JdbcDaoSupport, allowing to override JdbcTemplate creation Package org.springframework.jmx * added JMX support, for registration of Spring-managed

added "queryForRowSet" methods to JdbcTemplate, returning a SqlRowSet as generic representation of the result rows * added "queryForObject" convenience methods to JdbcTemplate, taking a RowMapper argument argument to JdbcTemplate, for extracting values from a single column * added "queryForMap" methods to JdbcTemplate, creating a Map representation for the columns of a single row * refined JdbcTemplate's "q "jdbc.core" * factored out protected "createJdbcTemplate" in JdbcDaoSupport, allowing to override JdbcTemplate creation Package org.springframework.jmx * added JMX support, for registration of Spring-managed