How do you enable Tibco Data Virtualization (TDV) JDBC tracing?

How do you enable Tibco Data Virtualization (TDV) JDBC tracing?

book

Article ID: KB0082272

calendar_today

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:
  • 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
Refer to the "JDBC Driver Connection URL Properties" section in the documentation for "Client Interfaces Guide". If you have additional parameters like &unsupportedMode=silent, you can leave those parameters as is.
 
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.