linelimit=numberofchars

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

The default is 0 (no maximum limit).

load=classname

Loads the driver specified by classname.

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 yes.