How to enable Oracle JDBC Driver tracing with WebSphere Application Server

Technote (troubleshooting)


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


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\

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 file instead of

Related information

A simplified Chinese translation is available

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 #:


Modified date:


Translate my page

Content navigation