SpyAttributes
- Last Updated: October 22, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Enables DataDirect Spy to log detailed information about calls 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 |
|---|---|
|
|
Sets the maximum number of characters that DataDirect Spy logs on a single line. The default is 0 (no maximum limit). |
|
|
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: |
|
|
Directs logging to a file prefixed by file_prefix. The log file is named file_prefixX. where: X is an integer that increments by 1 for each connection on which the prefix is specified. For example, if the attribute
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: |
|
|
Directs logging to the Java output standard, |
|
|
Specifies whether DataDirect Spy logs activity on When The default is |
|
|
Specifies whether DataDirect Spy logs activity on BLOB and CLOB objects. |
|
|
Specifies whether DataDirect Spy logs the name of the current thread. The default is |
|
|
Specifies whether a timestamp is included on each line of the DataDirect Spy log. The default is |
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)
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
.logextension, the driver automatically appends it. For example, a file namedspy.jspis renamed tospy.jsp.logby the driver. -
Refer to Tracking JDBC Calls with DataDirect Spy in the Progress DataDirect for JDBC Drivers Reference for a list of supported attributes.
Default
None
Data Type
String