The JDBC API lets you see warnings and exceptions generated by the database and by the JDBC driver. A SQLException object contains a description of the error, the X/Open SQLState, and the driver vendor's error code number. To see exceptions, you can use a catch block to print them.
Warnings are a subclass of SQLException that deal with database access warnings. Warnings do not stop the execution of an application; they simply alert the user that something did not happen as planned, such as a privilege that was not revoked as requested. Warnings can be reported on a Connection object, a Statement object (including PreparedStatement and CallableStatement objects), and a ResultSet object. Warnings can be retrieved on these objects using the getWarnings method.
DataDirect makes it easy to debug and troubleshoot your JDBC applications by offering a JDBC Software Developer's Kit (SDK) that provides the following tools:
- DataDirect Test for JDBC is a graphical, menu-driven component that helps developers debug JDBC applications. It works by displaying the results of all JDBC function calls with sample Java JDBC code (including comments). DataDirect Test makes troubleshooting easy, shortening the application development cycle.
- DataDirect Spy for JDBC traces JDBC calls in running applications. This utility passes calls issued by an application to the underlying DataDirect Technologies' JDBC driver and logs detailed information about those calls. The results passed back from the database to the application are also logged. DataDirect Spy differs from DataDirect Test in that DataDirect Spy is used with running applications to trace the JDBC calls made by that application, while DataDirect Test allows a developer to test their applications and experiment with the JDBC API during development.
These tools are only available with DataDirect's JDBC drivers.