Enabling Oracle JDBC Driver Debug capabilities

Troubleshooting problems with the webMethods JDBC Adapter in combination with the Oracle Thin Driver (ojdbc) can be cumbersome process. Needless to say that a specific issue might be caused by another problem such as intermittent network latency, packet loss etc.

A help in times of trouble is the fact that Oracle has a “debug” version of the JDBC Driver providing an interesting source of debugging information. This blog post will provide more information on how activate the “debug” version of the Oracle JDBC Driver within the webMethods IntegrationServer version 7.1.2 :

1. Download following files from the Oracle website :

  • “_g” version of the appropriate JDBC Driver (for example ojdbc5_g.jar)
  • demo.zip which contains a sample of the “OracleLog.properties” file

2. Store the debug library within your webMethods IntegrationServer’s home directory <IS_HOME>/lib/jars/. Make sure to temporary back out the non debug version of the Oracle JDBC Driver

3. Update and configure “OracleLog.properties” file as per your desired logging level.

3. For ease of use store “OracleLog.properties” file in the same location as the debug library file.

4. Activate the debug library by adding 2 Java System Property parameters to your webMethods IntegrationServer’s JVM start-up arguments :

  • -Doracle.jdbc.Trace=true
  • -Djava.util.logging.config.file=/<location>/OracleLog.properties

The first –D parameter will activate the JDBC debug trace whereas the second one is used to specify the location of your choice of the debug library property file

5. Shutdown and restart your webMethods IntegrationServer instance.

Author: Johan

blogger

blogger

Curious to know more about this topic?

Working at i8c

i8c is a system integrator that strives for an informal atmosphere between its employees, who have an average age of approx 30 years old. We invest a lot of effort in the professional development of each individual, through a direct connection between the consultants and the management (no multiple layers of middle management). We are based in Kontich, near Antwerp, but our customers are mainly located in the triangle Ghent-Antwerp-Brussels and belong to the top 500 companies in Belgium (Securex, Electrabel, UCB, etc…).

Quality Assurance

i8c is committed to delivering quality services and providing customer satisfaction. That’s why we invested in the introduction of a Quality Management System, which resulted in our ISO9001:2000 certification. This guarantees that we will meet your expectations, as a reliable, efficient and mature partner for your SOA & integration projects.

i8c - ISO9001-2015

Also worth reading

Apigee Scope Validation using OpenAPI Specification

In API security and management, we often use a lot of different security mechanisms to protect the requested resource behind the API Gateway. One of these mechanisms is the validation of scopes to authorize a client on a specific sub-resource of the API. Most of

Read More »

Integrating with TIBCO CLOUD

Our experts Glenn, Jason, Jurgen, and Kevin dedicated an i8c FastTrack Day to examining the TIBCO iPaaS offering. Check out their Research & Development day report to learn what they uncovered. 👇  TIBCO CLOUD™ The TIBCO Cloud™ Integration enterprise integration platform-as-a-service (iPaaS) provides self-service integration

Read More »