How to debug problems related to the JDBC API ?

A good way to find out what JDBC calls are doing is to enable JDBC tracing.

The JDBC trace contains a detailed listing of the activity occurring in the system that is related to JDBC operations.

If you use the DriverManager facility to establish your database connection, you use the DriverManager.setLogWriter method to enable tracing of JDBC operations.

If you use a DataSource object to get a connection, you use the DataSource.setLogWriter method to enable tracing.

(For pooled connections, you use the ConnectionPoolDataSource.setLogWriter method, and for connections that can participate in distributed transactions, you use the XADataSource.setLogWriter method.)