Management One common issue in tests that access a real database is their effect on the state of the persistence store. Even when you use a development database, changes to the state may affect future tests. Also running within the transaction managed for the test, the transaction rolls back by default, and the database returns to its state prior to execution of the test. Transactional support is provided to a test commit (unusual, but occasionally useful when you want a particular test to populate or modify the database), you can tell the TestContext framework to cause the transaction to commit instead of roll back

19. Data access with JDBC Introduction to Spring Framework JDBC Choosing an approach for JDBC database access Package hierarchy Using the JDBC core classes to control basic JDBC processing and error SQLExceptionTranslator Executing statements Running queries Updating the database Retrieving auto-generated keys Controlling database connections DataSource DataSourceUtils SmartDataSource AbstractDataSource calls Embedded database support Why use an embedded database? Creating an embedded database using Spring XML Creating an embedded database programmatically Selecting the embedded database type Using HSQL

19. Data access with JDBC Introduction to Spring Framework JDBC Choosing an approach for JDBC database access Package hierarchy Using the JDBC core classes to control basic JDBC processing and error SQLExceptionTranslator Executing statements Running queries Updating the database Retrieving auto-generated keys Controlling database connections DataSource DataSourceUtils SmartDataSource AbstractDataSource calls Embedded database support Why use an embedded database? Creating an embedded database using Spring XML Creating an embedded database programmatically Selecting the embedded database type Using HSQL

JDBC .......................................................... 408 Choosing an approach for JDBC database access ........................................... 408 Package hierarchy ..................... ............................................................................. 418 Updating the database .................................................................................... 419 Retrieving keys ....................................................................... 419 19.3. Controlling database connections .................................................................... 419 DataSource

JDBC .......................................................... 400 Choosing an approach for JDBC database access ........................................... 400 Package hierarchy ..................... ............................................................................. 410 Updating the database .................................................................................... 411 Retrieving keys ....................................................................... 411 19.3. Controlling database connections .................................................................... 411 DataSource

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 3.1. Choosing an Approach for JDBC Database Access . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 3.2. Package . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 3.3.6. Updating the Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 3.4. Controlling Database Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

216 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216 Connection to a Production Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 228 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 Connecting to a MongoDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

159 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 Connection to a Production Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 Connecting to a MongoDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

153 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Connection to a Production Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 Connecting to a MongoDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

157 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 Connection to a Production Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 Embedded Database Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 Connecting to a MongoDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .