Java Database Toolbox

The Java ecosystem includes myriad tools and libraries to help you work with databases. This covers a selection. Spring JdbcTemplate Spring JdbcTemplate makes JDBC coding easier by taking care of resource management and providing methods for many common tasks. Ant JDBC Script your build to create and populate your test schema automatically. DbUnit DbUnit is useful for testing Java code that accesses the database, but it's also helpful for testing the views and procedures in your project. SchemaSpy A little gem of a tool, you can use this to generate really useful schema documentation automatically. JDBC Loggers P6Spy was the mainstay in this area for years, but hasn't been updated for a long time. We'll look at several current JDBC loggers and see what they can do for diagnosing SQL issues in Java database applications.