KBEC-00086 - Enabling and collecting voluminous JDBC logging

Description

The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases and other tabular data sources, such as spreadsheets or flat files.

This article describes how to enable additional logging for debug purposes.

Solution

Applies to Version 4.2 and newer:

  1. Edit logback-local.groovy file located in <dataDir>/conf
    Find the following section

    // Log all SQL DML statements as they are executed
    logger("org.hibernate.SQL", TRACE)
    // Log all JDBC parameters
    logger("org.hibernate.type.descriptor.sql.BasicBinder", TRACE)

        Ensure that the lines are un-commented, and the level is set to "TRACE".

    2. Restart the Flow server (This maybe required for very busy servers)

Reproduce the issue that you are trying to debug, and send all the logs from the time you turned the SQL logging on until after the issue has been reproduced.

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk