Kbase P115402: How to enable JDBC tracing for DataSource based connections ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/27/2011 |
|
Status: Verified
GOAL:
How to enable JDBC tracing for DataSource based connections ?
GOAL:
Is there any function similar to DriverManager.setLogStream() for tracing DataSource based connection ?
GOAL:
How to track JDBC calls when using JDBC Data Sources ?
FACT(s) (Environment):
OpenEdge Category: SQL
OpenEdge SQL Category: JDBC Drivers
Progress/OpenEdge Product Family
All Supported Operating Systems
FIX:
You need to use DataDirect Spy in order to generate a JDBC trace file when using DataSource based connections.
The details on how to configure the DataDirect Spy log can be found in the Appendix H of the DataDirect Connect for JDBC User's Guide and Reference at the following URL:
http://media.datadirect.com/download/docs/jdbc/alljdbc/wwhelp/wwhimpl/js/html/wwhelp.htm.
For convenience, a direct link to Appendix H is also included:
http://media.datadirect.com/download/docs/jdbc/alljdbc/reference/spy2.html#wp77831 .
The DataDirect Spy JAR archive is available for download as part of the DataDirect Connect for JDBC product at:
http://www.datadirect.com/products/jdbc/index.ssp .
You can download an evaluation version which contains the required spy.jar archive.