How to generate a JDBC driver log when using Oracle native drivers?
Article ID: KB0093697
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
This article describes the steps to capture JDBC driver logs while using BW with Oracle native drivers.
Resolution
1). Download OJDBC JARs ending with "_g" e.g. ojdbc6_g.jar,ojdbc7_g.jar but not ojdbc6.jar or ojdbc7.jar, inside the TPCL_HOME/jdbc folder. Make sure you only have this JAR and no other versions present.
2). Copy the attached (Filename: OracleJDBC.properties) to any location. Change the path of "java.util.logging.FileHandler.pattern" inside the property depending on the location where you want to generate the log.
3). Add the following lines in your deployed application.tra or designer.tra if testing from Designer:
>>>>>>>>>>>>>
java.extended.properties=-Djava.util.logging.config.file=<path mentioned in step 2>/OracleJDBC.properties -Doracle.jdbc.Trace=true
>>>>>>>>>>>>>
4). Restart the application. Your driver logs will be generated in the path present in "java.util.logging.FileHandler.pattern" inside the myConfig.properties.
To change the granularity of the log, refer the following: https://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm
Issue/Introduction
How to generate a JDBC driver log when using Oracle native drivers?
Additional Information
https://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm
Feedback
Yes
No
Powered by
