How to enable Oracle JDBC Driver tracing with WebSphere Application Server

Technote (troubleshooting)


Problem(Abstract)

This document describes how to enable Oracle JDBC driver trace when using a datasource in WebSphere Application Server

Symptom

When debugging WAS + Oracle connection problems, it sometimes becomes necessary to enable Oracle JDBC driver tracing.


Resolving the problem

Set the following as a Generic JVM Argument on the application server (Servers > Server Types > WebSphere application servers > server_name. Then, in the Server Infrastructure section, click Java and process management > Process definition > Java virtual machine)

-Doracle.jdbc.Trace=true -Djava.util.logging.configureByLoggingPropertiesFile=true -Djava.util.logging.config.file=C:\WAS70\AppServer\profiles\AppSrvXML\logs\server1\OracleTrace\OracleTracing.properties

The Oracle document 30 Diagnosability in JDBC provides additional information on generating JDBC trace (see the section entitled Configuring Logging). The document refers to an OracleLog.properties file instead of OracleTracing.properties.


Related information

A simplified Chinese translation is available

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Application Server
DB Connections/Connection Pooling

Software version:

7.0, 8.0, 8.5, 8.5.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1598616

Modified date:

2014-05-12

Translate my page

Machine Translation

Content navigation