topic logging the sql statements issued by activiti engine. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/logging-the-sql-statements-issued-by-activiti-engine/m-p/84848#M57162 <HTML><HEAD></HEAD><BODY><SPAN>I tried the following configuration in my log4j.xml, but, not getting the sql logs .</SPAN><BR /><SPAN>&lt;logger name="java.sql.Connection"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;level value="DEBUG" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/logger&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;logger name="java.sql.PreparedStatement"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;level value="DEBUG" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/logger&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;logger name="java.sql.ResultSet"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;level value="DEBUG" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/logger&gt;</SPAN><BR /><BR /><SPAN>I use spring and hibernate for the main application. there is a property in hibernate configuration which dumps the sql logs.</SPAN><BR /><SPAN>is there similar thing for Ibatis ?</SPAN><BR /><BR /><SPAN>thanks</SPAN><BR /><SPAN>Saprar</SPAN></BODY></HTML> Fri, 02 Mar 2012 02:26:28 GMT sapra 2012-03-02T02:26:28Z logging the sql statements issued by activiti engine. https://connect.hyland.com/t5/alfresco-archive/logging-the-sql-statements-issued-by-activiti-engine/m-p/84848#M57162 I tried the following configuration in my log4j.xml, but, not getting the sql logs .&lt;logger name="java.sql.Connection"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;level value="DEBUG" /&gt;&nbsp;&nbsp;&nbsp;&lt;/logger&gt;&nbsp;&nbsp;&nbsp;&lt;logger name="java.sql.PreparedStatement"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;level value="DEBUG" /&gt;&nbsp;&nbsp;&nbsp;&lt;/logger&gt;&nbsp;&nbsp;&nbsp;&lt;logger name Fri, 02 Mar 2012 02:26:28 GMT https://connect.hyland.com/t5/alfresco-archive/logging-the-sql-statements-issued-by-activiti-engine/m-p/84848#M57162 sapra 2012-03-02T02:26:28Z Re: logging the sql statements issued by activiti engine. https://connect.hyland.com/t5/alfresco-archive/logging-the-sql-statements-issued-by-activiti-engine/m-p/84849#M57163 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Fri, 02 Mar 2012 06:18:04 GMT https://connect.hyland.com/t5/alfresco-archive/logging-the-sql-statements-issued-by-activiti-engine/m-p/84849#M57163 heymjo 2012-03-02T06:18:04Z