How to print sql log with springboot+flowable application?

1

How to print sql log with springboot+flowable application ?

2

Try set logging property:
log4j.logger.org.apache.ibatis=DEBUG

For more extensive logging you can try set-up p6spy which logs all JDBC transactions for any Java application.

3

Thanks you.I try to log “org.flowable” and it works.

4

I’m using slf4j, and I want to print all SQL statements of flowable tables in logs,

  • log4j.logger.org.apache.ibatis=DEBUG
    any suggestions?
5

Hello,
Creating below bean in spring boot application enabled me to get all the flowable related logs,

@Bean
    public EngineConfigurationConfigurer<SpringProcessEngineConfiguration> configurer() {
        return engineConfiguration -> {            
            engineConfiguration.setEnableDatabaseEventLogging(true);
            engineConfiguration.setEnableVerboseExecutionTreeLogging(true);
        };
    }
6

@aashi : do note that this is customized logging and won’t be capturing all.

Configuring your logging subsystem (e.g. log4j) to log mybatis statemetns will capture all SQL statements.