Enabling JDBC Logging

The Denodo JDBC driver can generate logging information that may help you troubleshoot issues when connecting to Virtual DataPort with the JDBC driver.

To store the log messages to a file, add these system properties to the application that loads the Denodo JDBC driver:

-DDENODO_LOGGING=true -DDENODO_LOG_LEVEL=FINEST -DDENODO_LOG_FILE=C:/Denodo/denodo_jdbc_my_application.log

To redirect the log messages to the console (standard output), add these system properties to the application that loads the Denodo JDBC driver:

-DDENODO_LOGGING=true -DDENODO_LOG_LEVEL=FINEST -DDENODO_LOG_CONSOLE=true

In both cases, the possible values of the system property DENODO_LOG_LEVEL are:

  • SEVERE (only log severe errors)

  • WARNING

  • INFO

  • CONFIG

  • FINE

  • FINER

  • FINEST (log all events)