How to enable Oracle JDBC Driver tracing with WebSphere Application Server v7

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

Symptom

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

Resolving the problem

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