# How to print sql statements in flowable logs

**URL:** https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198
**Category:** Flowable Engine
**Created:** [November 15, 2017, 5:03am UTC](https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198 "2017-11-15T05:03:22Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![MallaReddy\_Ch](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mallareddy_ch/32/301_2.png) [@MallaReddy\_Ch](https://forum.flowable.org/u/MallaReddy_Ch)
#### Post date: [November 15, 2017, 5:03am UTC](https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198/1 "2017-11-15T05:03:22Z")

</div>

How to enable debug logs to print SQL statements

---

<div class="post-metadata">

### Author: ![tijs](https://avatars.discourse-cdn.com/v4/letter/t/bc79bd/32.png) [@tijs](https://forum.flowable.org/u/tijs)
#### Post date: [November 16, 2017, 1:25pm UTC](https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198/2 "2017-11-16T13:25:12Z")

</div>

Hi,

You can adapt the log4j.properties and change to DEBUG log level.

Best regards,

Tijs

---

<div class="post-metadata">

### Author: ![MallaReddy\_Ch](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mallareddy_ch/32/301_2.png) [@MallaReddy\_Ch](https://forum.flowable.org/u/MallaReddy_Ch)
#### Post date: [December 8, 2017, 12:05pm UTC](https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198/3 "2017-12-08T12:05:33Z")

</div>

Thanks Tijis, by setting the logger org.flowable to DEBUG I could see sql statements in the logs…

---

<div class="post-metadata">

### Author: ![snalabothu](https://avatars.discourse-cdn.com/v4/letter/s/e99b99/32.png) [@snalabothu](https://forum.flowable.org/u/snalabothu)
#### Post date: [February 5, 2019, 2:54am UTC](https://forum.flowable.org/t/how-to-print-sql-statements-in-flowable-logs/1198/4 "2019-02-05T02:54:23Z")

</div>

I am completely new to flowable i am just going through the documentation to understand how flowable is working. I wanted to see what SQL statements are going for a corresponding REST API method. During this process i tried a couple of ways

1. I downloaded the flowable wars and copied them to webapps folder of tomcat and changed flowable-default.properties to connect MySql database and log4j.properties file (i am new to log4j and java so just changed INFO to DEBUG). Even though everything is working fine like creating task, getting the task list, But i am not able to see any SQl statements in DEBUG logs
2. I cloned flowable repository and build flowable using ant but still facing the same problem.

Please let me know if there is something wrong in what i am doing. Thanks in advance.