Re: How to turn on/enable sql logging

Russ Burkert wrote:

> using this driver:
> weblogic.jdbcx.oracle.OracleDataSource
> 
> So, how can we add the spyAttribute property

In the properties panel for the datasource,
add this property:

spyAttributes=(log=(file)spy.log;timestamp=yes;logTName=yes)

This will cause the driver to generate the file 'spy.log'
in the main domain directory.

You may have to edit your start-weblogic script to add the
wlspy.jar to the classpath created by the script. The wlspy.jar
is in the domain's server\lib directory.