Query of DB node recorded in log file

[JaeHwanChoi]

Hello.

I want to see the query statements used by the DB node in the log file.

Is there any way to see it?

Thank you.

[AlexanderFillbrunn]

Hi,
In the database connector under “Advanced” you can turn on JDBC logging. Make sure to set the log level to “INFO” in the preferences and you will see the query in the KNIME log and the console:

INFO  DB Reader            3:62       19. Statement.executeQuery(sql=<SQL>): SELECT * FROM "test" ;

Kind regards,
Alexander

[JaeHwanChoi]

Thanks for the quick response.

It was just what I was looking for.

Kind regards,
Choi