Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

How to generate the JDBC trace file for PostgreSQL connector in IICS Cloud Data Integration.
Solution
In certain scenarios we need to capture the trace file to debug the issue further below steps needs to be carried and in native connectors we dont have trace capture option,will achive it doing through the JDBC Connector:

Enable logging by using connection properties
The driver provides a facility to enable logging using connection properties, 
The properties are loggerLevel and loggerFile:

loggerLevel: Logger level of the driver. Allowed values: OFF, DEBUG or TRACE.

This option enable the java.util.logging.Logger Level of the driver based on the following mapping:


The following is an example of how to use connection properties to enable logging:

jdbc:postgresql://localhost:5432/mydb?loggerLevel=DEBUG
jdbc:postgresql://localhost:5432/mydb?loggerLevel=TRACE&loggerFile=pgjdbc.log

Logs would be generated in the temp location by default and if your not able to find the tarce file you can verify to locate the file on the secure agent machine as in certain time if we are not able to locate in temp location.




More Information
Reference
Applies To
Product: Cloud Data Integration
Problem Type: Connectivity; Configuration
User Type: Developer; Administrator
Project Phase: Onboard
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:6/2/2020 5:00 PMID:622658
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)