Re: How to turn on/enable sql logging

Russ Burkert wrote:

> Our environment is Java EE 5, JPA, Weblogic 10, KODO 4.1.2, and our DB is
Oracle 10gr2.  We are trying to figure out what to do/what has to be set up in
order to see the actual SQL going to the database.  I have the following in the
persistence.xml:
> <properties>
>             <property name="kodo.Log"
value="DefaultLevel=WARN, Runtime=INFO, Tool=INFO, SQL=TRACE"/>
>         </properties>
> which I found posted somewhere while trying to resolve this, but it does
nothing.  There is no sql syntax whatsoever in any weblogic log or on the
weblogic console.  For what it's worth, we have tried both XA and the thin
drivers, but that has no effect either.  We have tweaked the logging options in
the WL console as well, but nothing seems to have any impact on SQL logging. 
Any help would be greatly appreciated.

Hi. If you can configure WebLogic to use
the BEA-branded driver for Oracle, we can
then add the spyAttribute property to have
the driver generate a spy log that will show
every single JDBC call with every argument,
including the SQL.