Display the sql statements with ojdbc14

From: blured75 <75blured_at_gmail.com>
Date: Wed, 28 Nov 2007 10:44:13 -0800 (PST)
Message-ID: <789ec12f-0e90-4cf9-837c-2ed5b5752998@e67g2000hsc.googlegroups.com>

Hi,

I'd like to display the sql statements with ojdbc14_g.jar. So I've followed the documentation and set an OracleLog.properties file which is linked to my java program. The problem is the trace generated is huge and I only need the SQL requests wich are made with the arguments but I don't know how to configure that.
Have you got a sample file which handle that ?

I've tried that :
oracle.jdbc.handlers=java.util.logging.ConsoleHandler java.util.logging.ConsoleHandler.level=CONFIG java.util.logging.ConsoleHandler.formatter=java.util.logging.SimpleFormatter

oracle.level=INFO
oracle.jdbc.driver.level=OFF
oracle.jdbc.driver.OraclePreparedStatement.level=OFF
oracle.jdbc.pool.level=OFF
oracle.jdbc.util.level=OFF
oracle.sql.level=INFO

But that doesn't display only the SQL and args. Have you got a solution for that ?

Regards.
75blured. Received on Wed Nov 28 2007 - 12:44:13 CST

Display the sql statements with ojdbc14_g.jar