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:
These tools are only available with DataDirect's JDBC drivers.