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?
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
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.
Feedback
Yes
No
Powered by
