11. Understanding JDBC Connectivity : JDBC Tracing
 
Share this page                  
JDBC Tracing
The JDBC Driver supports both DriverManager and DataSource tracing as documented in the JDBC 3.0 API specification. Trace information consists of JDBC API method entry and exit points with corresponding parameter and return values.
Enable internal JDBC Driver tracing by defining system properties on the java command line (-D flag) or by including the properties in the driver properties file.
DBMS trace messages are written to the internal trace log and can be directed to a separate trace log specified by a driver property.
The following properties are supported:
Property
Value
Description
ingres.jdbc.trace.log
log
Path and file name of the JDBC Driver trace log
ingres.jdbc.trace.drv
0 - 5
Tracing level for the JDBC Driver
ingres.jdbc.trace.ds
0 - 5
Tracing level for the Ingres JDBC DataSources
ingres.jdbc.trace.msg
0 - 5
Tracing level for Messaging I/O
ingres.jdbc.trace.msg.tl
0 - 5
Tracing level for Transport Layer I/O
ingres.jdbc.trace.msg.nl
0 - 5
Tracing level for Network Layer I/O
ingres.jdbc.trace.timestamp
true
Include timestamp in trace log
ingres.jdbc.dbms.trace.log
log
Path and file name of the DBMS trace log
edbc.trace.log
log
Path and file name of the EDBC JDBC Driver trace log
edbc.trace.id
level
Tracing level for the EDBC JDBC Driver
edbc.trace.timestamp
true
Include timestamp in EDBC trace log
Internal tracing is also enabled by the application using the following JDBC Driver methods:
Method
Parameters
Description
setTraceLog(String)
log
Log file path and name
setTraceLevel(int)
level
Tracing level for ID 'drv'
setTraceLevel(String,int)
id, level
Trace ID and numeric tracing level
Internal driver tracing permits separate tracing level settings for the following trace IDs (id):
Trace ID
Description
drv
General driver tracing
ds
Data source tracing
msg
General messaging IO tracing
msg.tl
IO tracing: transport layer
msg.nl
IO tracing: network layer