How do you enable Tibco Data Virtualization (TDV) JDBC tracing?
Article ID: KB0082272
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
How do you enable Tibco Data Virtualization (TDV) JDBC tracing?
Issue/Introduction
This document describes useful Java Database Connectivity (JDBC) URL parameters that you can use to enable JDBC tracing when you are connected to the Tibco Data Virtualization (TDV) from a JDBC client.
Resolution
How do you enable Tibco Data Virtualization (TDV) JDBC tracing?
URL Parameters
In order to perform JDBC client tracing, see the URL parameters here:
Option 1
Perform a JDBC client trace and append &traceFolder=<foldername> &traceLevel=all. In this case, the tracefile is named CsJdbcDebug.txt to the URL parameters in this article.
Generic Format with Trace:
jdbc:compositesw:dbapi@:?domain=&dataSource=
&traceFolder=<Full_path_to_folder>&traceLevel=all
Example:
jdbc:compositesw:dbapi@localhost:9491?domain=composite&dataSource=
examples&traceFolder=C:\temp&traceLevel=all
Option 2
In order to specify the tracefile name, by specify the full file path. Use &traceFile=Full_path_to_filename>&traceLevel=all and do not use the traceFolder parameter.
Generic Format with Trace:
jdbc:compositesw:dbapi@:?domain=&dataSource=&traceFile=<Full_path_to_filename>&traceLevel=all
Example:
jdbc:compositesw:dbapi@localhost:9491?domain=composite&dataSource=examples&traceFile=
C:\\tempjdbctracefile.log&traceLevel=all
URL Parameters
In order to perform JDBC client tracing, see the URL parameters here:
- Original JDBC URL Generic: jdbc:compositesw:dbapi@<Hostname>:<Port>?domain=<domain>&dataSource=<datasource>
- Original JDBC URL Example: jdbc:compositesw:dbapi@localhost:9491?domain=composite&dataSource=examples
Option 1
Perform a JDBC client trace and append &traceFolder=<foldername> &traceLevel=all. In this case, the tracefile is named CsJdbcDebug.txt to the URL parameters in this article.
Generic Format with Trace:
jdbc:compositesw:dbapi@:?domain=&dataSource=
&traceFolder=<Full_path_to_folder>&traceLevel=all
Example:
jdbc:compositesw:dbapi@localhost:9491?domain=composite&dataSource=
examples&traceFolder=C:\temp&traceLevel=all
Note: In this option, the trace file is automatically named CsJdbcDebug.txt and created in the specified folder.
Option 2
In order to specify the tracefile name, by specify the full file path. Use &traceFile=Full_path_to_filename>&traceLevel=all and do not use the traceFolder parameter.
Generic Format with Trace:
jdbc:compositesw:dbapi@:?domain=&dataSource=&traceFile=<Full_path_to_filename>&traceLevel=all
Example:
jdbc:compositesw:dbapi@localhost:9491?domain=composite&dataSource=examples&traceFile=
C:\\tempjdbctracefile.log&traceLevel=all
Feedback
Yes
No
Powered by
