Check for ODBC, JDBC, OCI, Pro*C, and PL/SQL Application Errors

Check for the following types of errors:

  • ODBC errors returned by the SQLError function

  • JDBC errors returned by the SQLException class

TimesTen OCI and Pro*C applications, and those that use PL/SQL, report errors using Oracle database error codes instead of TimesTen error codes. The error messages that accompany the error codes may come from the TimesTen error catalog or the Oracle database error catalog.

By default, TimesTen messages and diagnostic information are stored in:

  • A user error log that contains error message information. Generally, these messages contain information on actions you may need to take. The default file is timesten_home/diag/tterrors.log. For more information on modifying the location of the user error log, see Error, Warning, and Informational Messages in the Oracle TimesTen In-Memory Database Operations Guide.

  • A support log containing everything in the user error log plus information of use by TimesTen Customer Support. The default file is timesten_home/diag/ttmesg.log. For more information on modifying the location of the user error log, see Error, Warning, and Informational Messages in the Oracle TimesTen In-Memory Database Operations Guide.

  • An invalidation file containing diagnostic information when TimesTen invalidates a database. This file provides useful troubleshooting information for TimesTen Customer Support. The invalidation file is created and named based on the value specified by the DataStore connection attribute. This connection attribute is not a file name. For example on Linux and UNIX systems, if the DataStore connection attribute is /home/ttuser/AdminData, the actual invalidation file name has a suffix, .inval, /home/ttuser/AdminData.inval. For more information on the DataStore connection attribute, see DataStore in the Oracle TimesTen In-Memory Database Reference.

It may be helpful to use ttTraceMon to generate a level 4 ERR trace for the application and review all of the errors messages that are pushed in the TimesTen direct driver. See ERR Tracing for details.