skip to main content
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 shows how to turn off logging using setEnableLogging(false).
import com.ddtek.jdbc.extensions.*

// Get Database Connection
Connection con = DriverManager.getConnection
("jdbc:datadirect:sqlserver://MyServer: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.