# How to get the log on flowable engine?

**URL:** https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347
**Category:** Flowable Engine
**Created:** [September 2, 2021, 1:49am UTC](https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347 "2021-09-02T01:49:49Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![kennychwk](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/kennychwk/32/2554_2.png) [@kennychwk](https://forum.flowable.org/u/kennychwk)
#### Post date: [September 2, 2021, 1:49am UTC](https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347/1 "2021-09-02T01:49:50Z")

</div>

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](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

---

<div class="post-metadata">

### Author: ![tjmac44](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/tjmac44/32/1716_2.png) [@tjmac44](https://forum.flowable.org/u/tjmac44)
#### Post date: [September 3, 2021, 11:53am UTC](https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347/2 "2021-09-03T11:53:42Z")

</div>

Try  
org.flowable=debug

Cheers

---

<div class="post-metadata">

### Author: ![kennychwk](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/kennychwk/32/2554_2.png) [@kennychwk](https://forum.flowable.org/u/kennychwk)
#### Post date: [September 6, 2021, 7:53am UTC](https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347/3 "2021-09-06T07:53:58Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![filiphr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/filiphr/32/315_2.png) [@filiphr](https://forum.flowable.org/u/filiphr)
#### Post date: [September 21, 2021, 9:29am UTC](https://forum.flowable.org/t/how-to-get-the-log-on-flowable-engine/8347/4 "2021-09-21T09:29:55Z")

</div>

Hey @kennychwk,

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

Cheers,  
Filip