Re: Display the sql statements with ojdbc14_g.jar

On 28 nov, 20:25, blured75 <75blu..._at_gmail.com> wrote:
> 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.

Are you talking about : http://forums.oracle.com/forums/forum.jspa?forumID=99 ?

Regards. Received on Wed Nov 28 2007 - 13:29:09 CST