. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 @Sql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112 3.5.10. Executing SQL Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Executing SQL scripts programmatically . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Executing SQL scripts declaratively with @Sql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

and Data Value Handling. . . . . . . . . . . . . . . . . . . . . . . . . . . 126 3.8.1. Providing SQL Type Information for Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . does what? Action Spring You Define connection parameters. X Open the connection. X Specify the SQL statement. X Declare parameters and provide parameter values X Prepare and run the statement. X This approach provides better documentation and ease of use when you have multiple parameters for an SQL statement. • SimpleJdbcInsert and SimpleJdbcCall optimize database metadata to limit the amount of

@TestPropertySource @DirtiesContext @TestExecutionListeners @Commit @Rollback @BeforeTransaction @AfterTransaction @Sql @SqlConfig @SqlGroup Standard Annotation Support Spring JUnit 4 Testing Annotations @IfProfileValue Demonstration of all transaction-related annotations Executing SQL scripts Executing SQL scripts programmatically Executing SQL scripts declaratively with @Sql TestContext Framework support classes Spring JUnit MappingSqlQuery SqlUpdate StoredProcedure Common problems with parameter and data value handling Providing SQL type information for parameters Handling BLOB and CLOB objects Passing in lists of values for IN clause

@TestPropertySource @DirtiesContext @TestExecutionListeners @Commit @Rollback @BeforeTransaction @AfterTransaction @Sql @SqlConfig @SqlGroup Standard Annotation Support Spring JUnit 4 Testing Annotations @IfProfileValue Demonstration of all transaction-related annotations Executing SQL scripts Executing SQL scripts programmatically Executing SQL scripts declaratively with @Sql TestContext Framework support classes Spring JUnit MappingSqlQuery SqlUpdate StoredProcedure Common problems with parameter and data value handling Providing SQL type information for parameters Handling BLOB and CLOB objects Passing in lists of values for IN clause

@AfterTransaction .................................................................................. 297 @Sql .................................................................................................. .......................... 332 Executing SQL scripts .................................................................................... 333 Executing SQL scripts programmatically ................. ................................. 333 Executing SQL scripts declaratively with @Sql ......................................... 334 TestContext Framework support classes ..............................

@AfterTransaction .................................................................................. 304 @Sql .................................................................................................. .......................... 339 Executing SQL scripts .................................................................................... 340 Executing SQL scripts programmatically ................. ................................. 341 Executing SQL scripts declaratively with @Sql ......................................... 341 TestContext Framework support classes ..............................

Connection proxy implements "equals" and "hashCode" based on proxy equality * worked around "oracle.sql.DATE" problem on certain Oracle driver versions, extracting it as timestamp when appropriate * Ro with unknown SQL type on Informix * JdbcTemplate by default uses "PreparedStatement.setString" for any CharSequence (including String and StringBuilder) * JdbcTemplate does not check static SQL for bind parameters building correct relative paths for them Package org.springframework.jdbc * added further default SQL error codes for DB2 and HSQLDB * refined NativeJdbcExtractorAdapter to retry with DatabaseMetaData

building correct relative paths for them Package org.springframework.jdbc * added further default SQL error codes for DB2 and HSQLDB * refined NativeJdbcExtractorAdapter to retry with DatabaseMetaData ResultSetExtractor rse)" method public * improved JdbcTemplate's logging of ignored SQLWarnings, including SQL state and error code in the log output * JdbcTemplate's "queryForObject"/"queryForInt"/etc methods correct exception (DataAccessException) * fixed BlobStringType for Hibernate2/3 to correctly handle SQL NULL Package org.springframework.remoting * RmiClientInterceptorUtils throws clearer exception message

"messageSource" bean even through an alias Package org.springframework.jdbc * added further default SQL error codes for MS SQL, MySQL, and Oracle * OracleLobHandler lazily initializes Oracle driver classes, always SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential

SqlFunction's constructors that expect a SQL return type, in favor of specifying a result type Class * added overloaded constructor to SqlCall, with DataSource and SQL arguments (for consistency with SqlFunction SQLState/SQLErrorCodeSQLExceptionTranslator always include SQL in message, even for generic DataAccessExceptions * UncategorizedSQLException includes SQL state and error code in message, to indicate potential to replace existing properties, also replacing defaults * added support for reports with embedded SQL statements to AbstractJasperReportsView, via the "jdbcDataSource" property Changes in version 1.2