Enabling Logging

Use the logs to debug a JDBC application issue. By default, JDBC logging is disabled. Enable it to get the logs.

For enabling JDBC logging, add the following properties to the JDBC connection string:

• LogLevel: It can have one of these values: 1, 2, 3, 4, 5, 6 where

  • 1 implies LOG_OFF that disables all logging.
  • 2 implies LOG_FATAL that logs very severe error events that might lead the driver to abort.
  • 3 implies LOG_ERROR that logs error events that might still allow the driver to continue running.
  • 4 implies LOG_WARNING that logs potentially harmful situations.
  • 5 implies LOG_INFO that logs general information that describes the driver’s progress.
  • 6 implies LOG_DEBUG that logs a detailed information that is useful for debugging the driver.
  • 7 implies LOG_TRACE that logs a more detailed information than the LOG_DEBUG level.

• LogPath: It is the log file location to which you must have write access.

  For example, this is a log path: jdbc:qubole://hive/default?LogLevel=6;LogPath=C:\\Users\\User\\Desktop

Note

Increasing the verbosity of LogLevel creates a larger log file. For example, LogLevel=6 for a long-running session can generate a 2GB-size log file.

Logs are printed in a file named QuboleJDBC_Driver.log.