<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to print ibatis sql log on original REST API application ? in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187391#M140521</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I use original rest-war in my&amp;nbsp; web application, I want to print the SQL statement log when invoke rest api.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I can print it successufully on non rest API application, but I don't know how to config it for original rest API application.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Who know that&amp;nbsp; how to config log4j.properties to print SQL statement for original REST API application ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;As we know, activiti use ibatis to do persistence, for REST API application, I tried to modify lots of times, it can not work.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My log4j.properties file like below:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;log4j.rootLogger=debug, CA&lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&lt;BR /&gt;# ConsoleAppender&lt;BR /&gt;log4j.appender.CA=org.apache.log4j.ConsoleAppender&lt;BR /&gt;log4j.appender.CA.layout=org.apache.log4j.PatternLayout&lt;BR /&gt;log4j.appender.CA.layout.ConversionPattern= %d{hh:mm:ss,SSS} [%t] %-5p %c %x - %m%n&lt;BR /&gt;#The following configuration which i look up on web site that support print ibatis log in non rest API activiti system&lt;BR /&gt;org.activiti.engine.impl.persistence.entity=DEBUG &lt;BR /&gt;org.activiti.engine.impl=DEBUG&lt;BR /&gt;log4j.logger.org.activiti.engine.impl=DEBUG&lt;BR /&gt;&lt;BR /&gt;log4j.logger.com.ibatis=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.java.sql.Connection=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.java.sql.Statement=debug&amp;nbsp; &lt;BR /&gt;log4j.logger.java.sql.PreparedStatement=debug,stdout&amp;nbsp; &lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;When I debug in eclipse and change the value "org.slf4j.impl.JDK14LoggerAdapter.isDebugEnabled" = true&amp;nbsp; manually,&amp;nbsp; it will print ibatis sql log. How can i config it ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Any feedback will be much appreciated. Thanks in advance.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Regards,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Frank&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 16 Jul 2015 08:43:04 GMT</pubDate>
    <dc:creator>youtianhong</dc:creator>
    <dc:date>2015-07-16T08:43:04Z</dc:date>
    <item>
      <title>How to print ibatis sql log on original REST API application ?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187391#M140521</link>
      <description>I use original rest-war in my&amp;nbsp; web application, I want to print the SQL statement log when invoke rest api.I can print it successufully on non rest API application, but I don't know how to config it for original rest API application.Who know that&amp;nbsp; how to config log4j.properties to print SQL statemen</description>
      <pubDate>Thu, 16 Jul 2015 08:43:04 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187391#M140521</guid>
      <dc:creator>youtianhong</dc:creator>
      <dc:date>2015-07-16T08:43:04Z</dc:date>
    </item>
    <item>
      <title>Re: How to print ibatis sql log on original REST API application ?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187392#M140522</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;We use &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;log4j.logger.org.apache.ibatis.level=DEBUG&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;(see &lt;/SPAN&gt;&lt;A href="https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/test/resources/log4j.properties#L9" rel="nofollow noopener noreferrer"&gt;https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/test/resources/log4j.properties#L9&lt;/A&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 Jul 2015 09:02:24 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187392#M140522</guid>
      <dc:creator>jbarrez</dc:creator>
      <dc:date>2015-07-23T09:02:24Z</dc:date>
    </item>
    <item>
      <title>Re: How to print ibatis sql log on original REST API application ?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187393#M140523</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;This does not work for me. I have log4j.properties in my test resources, but I can't see any SQL logs. Is there anything else we need to do? &lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 23 Sep 2016 15:25:59 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/how-to-print-ibatis-sql-log-on-original-rest-api-application/m-p/187393#M140523</guid>
      <dc:creator>snigdha_girdhar</dc:creator>
      <dc:date>2016-09-23T15:25:59Z</dc:date>
    </item>
  </channel>
</rss>

