Re: Display the sql statements with ojdbc14_g.jar

On 28 nov, 19:51, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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.

thanks for the info.

I could filter however the amount of info showed by the driver in debug mode is huge so the application is nearly on the knees. Received on Wed Nov 28 2007 - 13:25:28 CST