SQL Exceptions and Error Messages

When errors occur, the JDBC driver throws SQLExceptions. When this happens, check the log files for additional information. The log locations are specified in the jdelog.properties file. If the logs do not help to resolve the issue, enable the debug logs for more information.

It is especially helpful to inspect entire exception stack traces, because traces include exception messages, class names, and line numbers. Exception stack traces cause exceptions that result in SQLExceptions.

When you evaluate a series of exceptions in a trace, you should concentrate on the first exception, since it is often the cause of subsequent exceptions.

Following are some exception examples, with recommendations on how to resolve them.