WebSphere Application Server Network Deployment, Version 6.1
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

JDBC trace configuration

If your application displays JDBC-related exception messages, activate the JDBC trace service. The resulting log text can help you identify the problem.

Trace strings for JDBC data sources

[AIX HP-UX Linux Solaris Windows] [i5/OS] Turn on tracing for most database JDBC implementations through the administrative console; see the article Enabling trace at server startup for instructions.

[z/OS] Turn on tracing for most database JDBC implementations through the administrative console; see the articleTracing and logging configuration for instructions.

This method activates JDBC trace for all applications that run in the server you specify. Identify your database type by selecting the trace group WAS.database and typing one of the following trace strings in the console:
  • com.ibm.ws.database.logwriter Trace string for databases that use the GenericDataStoreHelper. You can also use this trace string for unsupported databases.
  • com.ibm.ws.db2.logwriter Trace string for DB2 databases.
  • com.ibm.ws.oracle.logwriter Trace string for Oracle databases.
  • com.ibm.ws.derby.logwriter Trace string for Derby databases.
  • com.ibm.ws.informix.logwriter Trace string for Informix databases.
  • com.ibm.ws.sqlserver.logwriter Trace string for Microsoft SQL Server databases.
  • com.ibm.ws.sybase.logwriter Trace string for Sybase databases.
A few JDBC drivers require that you set trace differently, at the data source level. These drivers include: Configuring trace for these drivers through the WAS.database group results in corrupt trace information. WebSphere Application Server sets trace for the group at the server level, causing the trace service to begin only after your application establishes an initial connection. Because that first connection does not carry trace information, re-use of it is never tracked. Consequently the application cannot accurately match trace information to connection use.

Set trace for the previously mentioned JDBC drivers through data source custom properties. For example, use custom property spyAttributes to enable the JDBC trace for SequeLink or Connect JDBC drivers. Consult your driver documentation for details on the custom property that enables trace for your JDBC implementation.

Additional resources

If the JDBC tracing service cannot help you isolate and fix your problem, consult the IBM Support website for WebSphere Application Server at http://www.ibm.com/support/search.wss?rs=180&tc=SSEQTP&tc1=SSCMP9Y. Use the site search function to find current information on known problems and their resolutions. Locating the right troubleshooting tip can save time that, otherwise, you might spend on opening and tracking a PMR.

Learn about other IBM Support options in the articles Diagnosing and fixing problems: Resources for learning and Troubleshooting help from IBM.




Related tasks
[i5/OS] iSeries installation troubleshooting tips
Related reference
[AIX HP-UX Linux Solaris Windows] [z/OS] Installation problems
[AIX HP-UX Linux Solaris Windows] [i5/OS] Tracing and logging configuration
Data access problems
Data source minimum required settings, by vendor
Reference topic    

Terms of Use | Feedback

Last updated: Feb 25, 2009 9:32:38 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/rtrb_jdbccomp.html