|
|
|
The Ingres 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 Ingres 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 Ingres JDBC Driver trace log |
ingres.jdbc.trace.drv |
0 - 5 |
Tracing level for the Ingres 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 |
Internal tracing is also enabled by the application using the following Ingres 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 |
|
|
|
The tracing level determines the type of information that is logged. The following levels are currently defined:
1 – Errors and exceptions
2 – High level method invocation
3 – High level method details
4 – Low level method invocation
5 – Low level method details