Groups > Weblogic > WebLogic Enterprise JavaBeans > How to turn on/enable sql logging




How to turn on/enable sql logging

How to turn on/enable sql logging
Thu, 10 Apr 2008 13:34:32 -070
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 loggi
Post Reply
about | contact