skip to main content
About the Driver : Using the driver : Troubleshooting : Troubleshooting your application : Turning on and off DataDirect Spy logging
  

Try DataDirect Drivers Now
Turning on and off DataDirect Spy logging
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");

((ExtLogControl) con).setEnableLogging(false);
...
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.