Re: JDBC thin driver and sql_trace

Hello Thomas,

Did you do something like:

Statement stmt = conn.createStatement(); stmt.execute ("alter session set events sql_trace = true");

or

stmt.execute ("alter session set events '10046 trace name context forever, level 8'");

If not, please post the code snippet.

Rgds.

"Thomas Kellerer" <spam_eater_at_gmx.net> wrote in message news:bpu0t3$cec$1_at_svr7.m-online.net...
> Hello all,
>
> I'm trying to get sql_trace enabled from a Java based front end, which
> connects through the JDBC thin driver to a 8.1.7 database.
>
> When I fire up SQL*Plus and issue ALTER SESSION SET sql_trace = true; I
get
> my trace files written to disk.
>
> When I do the same through JDBC (same user, same server, same instance)
the
> trace files are not written. I tried it also with a small test program but
> still no trace file were generated.
>
> Am I missing something? Do I need to pass additional parameters when
> connecting in order to get sql_trace enabled?
>
> I tried this with the 8.1.7 driver (classes12.zip) and the new 9.2 driver
> (ojdbc14.jar) - no difference. JDK was 1.4.2
>
> Any help is greatly appreciated.
>
> Thanks in advance
> Thomas
>
Received on Mon Nov 24 2003 - 17:39:40 CST