SpyAttributes
- Last Updated: October 23, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Apache Spark SQL 6.0
- 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 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
See also
Refer to Tracking JDBC Calls with DataDirect Spy in the Progress DataDirect for JDBC Drivers Reference for more information about using DataDirect Spy.