SpyAttributes
- Last Updated: October 16, 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 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.
Refer to Tracking JDBC Calls with DataDirect Spy in the Progress DataDirect for JDBC Drivers Reference for a list of supported attributes.
|
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 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 where:
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 |
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.
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