How to get the log on flowable engine?

Flowable Engine
1

Hi,
I am touching the flowable on this current few month, my dev environment is WebSphere 7.x /w Marven on eclipse, in current day I am trying to get the sql(or specifically is the hibernate sql) that on the flowable log, I’ve read the doc on the web and some stack overflow answer, but still don’t know how, let say I don’t know where is the key, some say log4j.protities needs modify, and also I got on the flowable open doc descript that I need to add jar, but I find it on the dependency… I am confuse that I dont know what I am missing, I wish can get some help…

thx for every one help~
pom.xml:
https://1drv.ms/u/s!Ag6nmxO68hUfr5R6eV0n4ixqOim_iQ?e=7t9Qzu
log4j.propeties:

#log4j.rootLogger=DEBUG,console
log4j.rootLogger=ALL,console

log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
#log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%n
log4j.appender.console.layout.ConversionPattern=[%c]-[%p] %m%n

#log4j.logger.org.hibernate=ERROR
log4j.logger.org.hibernate=DEBUG
log4j.logger.org.quartz=ERROR

log4j.logger.org.flowable.idm.engine=DEBUG
log4j.logger.org.apache.ibatis=DEBUG

2

Try
org.flowable=debug

Cheers

3

thx for your comment~ and I’ve try to be set TRACE for “org.flowable”, in some cases, it can be loged the “normal” searching, but the HistoricProcessInstanceQuery’s log I still can be loged, would you have any solution on that?

4

Hey @kennychwk,

When you set the logging level as proposed by @tjmac44 then the HistoricProcessInstanceQuery should also be logged.

Cheers,
Filip