# Enable SQL log for tables in flowable engine

**URL:** <https://forum.flowable.org/t/enable-sql-log-for-tables-in-flowable-engine/9147>\
**Category:** Flowable Engine\
**Created:** [March 25, 2022, 3:25pm UTC](https://forum.flowable.org/t/enable-sql-log-for-tables-in-flowable-engine/9147 "2022-03-25T15:25:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lagatanegra](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/lagatanegra/32/1358_2.png) [@lagatanegra](https://forum.flowable.org/u/lagatanegra)\
**Post date:** [March 25, 2022, 3:25pm UTC](https://forum.flowable.org/t/enable-sql-log-for-tables-in-flowable-engine/9147/1 "2022-03-25T15:25:44Z")

</div>

Hi, we have integrated flowable 6.4.2 into our web application, which allow user to submit an application form and used flowable to handle the approval process.  
Our web application used hibernate for OR mapping and log4j for console log.  
We would like to enable SQL log for flowable database tables (ACT\_\*) but failed.  
Our project’s dependency:

```auto
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>4.2.21.Final</version>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.17</version>
		</dependency>

		<dependency>
			<groupId>org.flowable</groupId>
			<artifactId>flowable-engine</artifactId>
			<version>6.4.2</version>
		</dependency>
		<dependency>
		    <groupId>org.flowable</groupId>
		    <artifactId>flowable-job-service</artifactId>
		    <version>6.4.2</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.flowable/flowable-spring -->
		<dependency>
		    <groupId>org.flowable</groupId>
		    <artifactId>flowable-spring</artifactId>
			<version>6.4.2</version>
		</dependency>

```

our log4j properties file:

```auto
log4j.rootLogger=DEBUG,console

log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-[%p] %m%n

log4j.logger.org.flowable=DEBUG
log4j.logger.org.hibernate=info

```

Under this configuration, the application server is not able to catch any SQL logs from flowable.

In the same workspace, i created a standalone java project with the same log4j and flowable config and i was able to grab the SQL logs .

Any additional configuration that was missing in the web application?

---

<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:** [August 17, 2022, 8:29am UTC](https://forum.flowable.org/t/enable-sql-log-for-tables-in-flowable-engine/9147/2 "2022-08-17T08:29:12Z")

</div>

Hey @lagatanegra,

What do you mean by “it is not able to catch any SQL logs from flowable”

When `org.flowable` is set to DEBUG we do print SQL logging.

Cheers,  
Filip