Using the JDBC DriverManager

Using the driver : Tracking JDBC calls with DataDirect Spy : Enabling DataDirect Spy : Using the JDBC DriverManager

The SpyAttributes connection property allows you to specify a semi-colon separated list of DataDirect Spy attributes. The format for the value of the SpyAttributes property is:

(
spy_attribute
[;
spy_attribute
]...)

where spy_attribute is any valid DataDirect Spy attribute. See "DataDirect Spy Attributes" for a list of supported attributes.

Windows Example

Class.forName("com.ddtek.jdbc.sforce.SForceDriver");
Connection conn = DriverManager.getConnection
   ("jdbc:datadirect:sforce://login.salesforce.com;User=abc@defcorp.com;
Password=secret;SecurityToken=XaBARTsLZReM4Px47qPLOS;
   SpyAttributes=(log=(filePrefix)C:\\temp\\spy_;linelimit=80;logTName=yes;
   timestamp=yes)");

Note: If coding a path on Windows to the log file in a Java string, the backslash character (\) must be preceded by the Java escape character, a backslash. For example: log=(filePrefix)C:\\temp\\spy_.

DataDirect Spy loads the Salesforce driver and logs all JDBC activity to the spy_x.log file located in the C:\temp directory (log=(filePrefix)C:\\temp\\spy_), where x is an integer that increments by 1 for each connection on which the prefix is specified. The spy_x.log file logs a maximum of 80 characters on each line (linelimit=80) and includes the name of the current thread (logTName=yes) with a timestamp on each line in the log (timestamp=yes).

UNIX Example

Class.forName("com.ddtek.jdbc.sforce.SForceDriver");
Connection conn = DriverManager.getConnection
("jdbc:datadirect:sforce://login.salesforce.com;User=abc@defcorp.com;
Password=secret;SecurityToken=XaBARTsLZReM4Px47qPLOS;
SpyAttributes=(log=(filePrefix)/tmp/spy_;logTName=yes;timestamp=yes)");

DataDirect Spy loads the Salesforce driver and logs all JDBC activity to the spy_x.log file located in the /tmp directory (log=(filePrefix)/tmp/spy_), where x is an integer that increments by 1 for each connection on which the prefix is specified. The spy_x.log file includes the name of the current thread (logTName=yes) with a timestamp on each line in the log (timestamp=yes).