Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Display the sql statements with ojdbc14_g.jar

Re: Display the sql statements with ojdbc14_g.jar

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 28 Nov 2007 10:51:43 -0800 (PST)
Message-ID: <2dcfc5cd-fe8e-408f-b43a-fa3c5415af9f@g30g2000hsb.googlegroups.com>


On Nov 28, 1:44 pm, blured75 <75blu..._at_gmail.com> wrote:
> 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.SimpleFormatte-r
>
> 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.

There's a large jdbc support group over on the oracle forums ... that's one place to maybe ask this.

In the meantime maybe you can just filter out from the log file you are currently getting what you want to see. Received on Wed Nov 28 2007 - 12:51:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US