Enable logging for SQL statements

[Torsten Geise]

Dear all,

how can I see the SQL statements which are executed when using the Java API, e.g. when performing "historyService.createHistoricTaskInstanceQuery.list();"

Thanks,

Torsten

[webcyberrob]

One thought which comes to mind is depending on your database, you may see them logged in the database itsself...

regards

Rob

[Torsten Geise]

Hi Rob,

that's not what I'm looking for. Actually, I'm looking for something similar to the hibernate property "hibernate.show_sql" which I can set in the camunda.cfg.xml. 

I also tried setting the org.apache.ibatis log level to "FINE" which was not working.

Thanks,

Torsten

[Ingo Richtsmeier]

Hi Torsten,

in our process application archetype we prepared these metod calls in the JUnit-test class to show the database logging:

  static {
    LogUtil.readJavaUtilLoggingConfigFromClasspath(); // process engine
    LogFactory.useJdkLogging(); // MyBatis
  }

Maybe you have to call the methods in your process application.

The log levels have to be configured in logging.properties:

org.apache.ibatis.level=FINE
org.camunda.bpm.engine.impl.persistence.level=FINER

The second line shows the result set.

Hope this helps,

Ingo