Once DataDirect Spy logging is enabled for a connection, you can turn on and off the logging at runtime using the setEnableLogging() method in the com.ddtek.jdbc.extensions.ExtLogControl interface. When DataDirect Spy logging is enabled, all Connection objects returned to an application provide an implementation of the ExtLogControl interface.
The following code example is drawn from a Microsoft SQL Server use case but informs the use of logging with DataDirect Spy with most Progress DataDirect drivers. The code shows how to turn off logging using setEnableLogging(false).
import com.ddtek.jdbc.extensions.*
// Get Database Connection
Connection con = DriverManager.getConnection
("jdbc:datadirect:sqlserver://server1:1433;User=TEST;Password=secret;
SpyAttributes=(log=(file)/tmp/spy.log");
The setEnableLogging() method only turns on and off logging if DataDirect Spy logging has already been enabled for a connection; it does not set or change DataDirect Spy attributes. See Enabling DataDirect Spy for information about enabling and customizing DataDirect Spy logging.
