logging the sql statements issued by activiti engine.

[sapra]

I tried the following configuration in my log4j.xml, but, not getting the sql logs .
<logger name="java.sql.Connection">
      <level value="DEBUG" />
   </logger>

   <logger name="java.sql.PreparedStatement">
      <level value="DEBUG" />
   </logger>

   <logger name="java.sql.ResultSet">
      <level value="DEBUG" />
   </logger>

I use spring and hibernate for the main application. there is a property in hibernate configuration which dumps the sql logs.
is there similar thing for Ibatis ?

thanks
Saprar

[heymjo]

i just set the root logger to DEBUG and it shows the ibatis SQL statements, then i filter out the categories i don't need with logger categories.