How to get the log on flowable engine?

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~
Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.


#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



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?