How to enable JDBC debug logging at the client side from DbVisualizer application?
Article ID: KB0070792
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported versions. |
Description
This article details the process of activating JDBC debug logging in DbVisualizer. The JDBC DEBUG log file acts as a repository for DEBUG trace logs, capturing connection details established by the TDV server with DbVisualizer as the client through the TDV JDBC driver.
Environment
All Supported Operating Systems.
Resolution
Follow the below steps to activate JDBC debug logging from the client side, to diagnose issues associated with database connections in the client application - DbVisualizer.
(1) Launch DbVisualizer and connect to the database for which you want to enable JDBC debug logging.
(2) Navigate to the Tools -> Debug Window.
The checkboxes located at the top of the Debug tab allow you to control which aspects of DbVisualizer should undergo debugging.
(3) Enable the checkboxes "Debug DbVisualizer" and "Debug JDBC Driver"
The Debug JDBC Drivers option will enable debugging of the current JDBC driver. Note that the amount of output is determined by the JDBC driver.
(4) The log window displays the end of the log files generated by DbVisualizer. The Debug Log tab shows the debug log file, and the Error Log tab displays the error log file. The toolbar provides the following functions:
(5) DbVisualizer writes these log files to a log directory accessible through the "Open Log Directory" link at the top right.
To manage file size, DbVisualizer maintains the log directory content, and the log tabs are automatically truncated to preserve memory.
Pass the Debug files generated on to TIBCO Support as needed, for detailed troubleshooting investigation of any issues encountered with the TDV JDBC driver from DbVisualizer.
(1) Launch DbVisualizer and connect to the database for which you want to enable JDBC debug logging.
(2) Navigate to the Tools -> Debug Window.
The checkboxes located at the top of the Debug tab allow you to control which aspects of DbVisualizer should undergo debugging.
(3) Enable the checkboxes "Debug DbVisualizer" and "Debug JDBC Driver"
The Debug JDBC Drivers option will enable debugging of the current JDBC driver. Note that the amount of output is determined by the JDBC driver.
(4) The log window displays the end of the log files generated by DbVisualizer. The Debug Log tab shows the debug log file, and the Error Log tab displays the error log file. The toolbar provides the following functions:
- Save: Saves the content of the visible log tab to a file.
- Copy: Copies any selection to the clipboard.
- Clear: Clears the content of the log tab.
- Start: Initiates monitoring of the corresponding log file (disabled if monitoring is already started).
- Stop: Halts the monitoring of the log files (if already started).
(5) DbVisualizer writes these log files to a log directory accessible through the "Open Log Directory" link at the top right.
To manage file size, DbVisualizer maintains the log directory content, and the log tabs are automatically truncated to preserve memory.
Pass the Debug files generated on to TIBCO Support as needed, for detailed troubleshooting investigation of any issues encountered with the TDV JDBC driver from DbVisualizer.
Issue/Introduction
This article provides instructions on enabling JDBC debug logging in the DbVisualizer application.
Feedback
Yes
No
Powered by
