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.
  • For more information, refer to "Tracking JDBC calls with DataDirect Spy" in the Progress DataDirect for JDBC Drivers Reference.

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)

Data Source Method

setSpyAttributes

Default

Empty string

Data Type

String