Purpose

Enables DataDirect Spy to log detailed information about calls that are issued by the driver on behalf of the application. DataDirect Spy is not enabled by default.

Valid Values

( spy_attribute [; spy_attribute ]...)

where:

spy_attribute
is any valid DataDirect Spy attribute.

Behavior

Attribute

Description

linelimit=numberofchars

Sets the maximum number of characters that DataDirect Spy logs on a single line.

The default is 0 (no maximum limit).

log=(file)filename

Directs logging to the file specified by filename.

For Windows, if coding a path to the log file in a Java string, the backslash character (\) must be preceded by the Java escape character, a backslash. For example: log=(file)C:\\temp\\spy.log;logIS=yes;logTName=yes.

log=(filePrefix)file_prefix

Directs logging to a file prefixed by file_prefix. The log file is named file_prefixX.log

where:

X is an integer that increments by 1 for each connection on which the prefix is specified.

For example, if the attribute log=(filePrefix)C:\\temp\\spy_ is specified on multiple connections, the following logs are created:

C:\temp\spy_1.log

C:\temp\spy_2.log

C:\temp\spy_3.log

...

If coding a path 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_;logIS=yes;logTName=yes.

log=System.out

Directs logging to the Java output standard, System.out.

logIS= { yes | no | nosingleread }

Specifies whether DataDirect Spy logs activity on InputStream and Reader objects.

When logIS=nosingleread, logging on InputStream and Reader objects is active; however, logging of the single-byte read InputStream.read or single-character Reader.read is suppressed to prevent generating large log files that contain single-byte or single character read messages.

The default is no.

logLobs= { yes | no }

Specifies whether DataDirect Spy logs activity on BLOB and CLOB objects.

logTName= { yes | no }

Specifies whether DataDirect Spy logs the name of the current thread.

The default is no.

timestamp= { yes | no }

Specifies whether a timestamp is included on each line of the DataDirect Spy log.

The default is no.

Notes

  • 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=(file)C:\\temp\\spy.log.
  • If a log file name does not include the .log extension, the driver automatically appends it. For example, a file named spy.jsp is renamed to spy.jsp.log by the driver.
  • Refer to Tracking JDBC Calls with DataDirect Spy in the Progress DataDirect for JDBC Drivers Reference for a list of supported attributes.

Example

The following value instructs the driver to log all JDBC activity to a file using a maximum of 80 characters for each line.

(log=(file)/tmp/spy.log;linelimit=80)  

Default

None

Data Type

String