My Oracle Support Banner

How To Log SQL Statement/PreparedStatement of Oracle SQL Driver in WebLogic Server (Doc ID 1352042.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Oracle WebLogic Server - Version 10.3.1 and later
Information in this document applies to any platform.

Goal

Sometimes we need to print SQL statements sent from applications or WebLogic Server internals to the database. When the Oracle JDBC Driver is used, it can be done with its logging feature.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 1) Download the debug version of the JDBC driver.
 2) Put the debug version of the JDBC driver to the WLS classpath.
 3) Create an Oracle JDBC driver logging configuration file.
 4) Enable Oracle JDBC logging.
 5) Restart WebLogic Server.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.