logging hibernate sql statement with parameters
samwun9988 Oct 21, 2011 3:45 AMHi,
With jboss as7.1A, how to log hibernate sql statment with parameters display on console?
I have the log4j.xml file in-placed under java/resources/META-INF folder, shown as below:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"
debug="false">
<appender name="DAILY-ASYNC" class="org.apache.log4j.AsyncAppender">
<param name="LocationInfo" value="false" />
<appender-ref ref="DAILY-TOMCAT-FILE" />
</appender>
<appender name="DAILY-TOMCAT-FILE" class="org.apache.log4j.DailyRollingFileAppender">
<param name="DatePattern" value="'.'yyyy-MM-dd" />
<param name="File" value="../standalone/log/category6-ws-ejb.log" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{ISO8601} [%-5p] [%t] %c - %m%n" />
</layout>
<filter class="org.apache.log4j.varia.LevelRangeFilter">
<param name="LevelMin" value="DEBUG" />
<param name="LevelMax" value="FATAL" />
</filter>
</appender>
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{ISO8601} [%-5p] [%t] %c - %m%n" />
</layout>
</appender>
<category name="org.hibernate.SQL">
<priority value="TRACE"/>
<appender-ref ref="CONSOLE"/>
</category>
<category name="org.hibernate.type">
<priority value="TRACE"/>
<appender-ref ref="CONSOLE"/>
</category>
<logger name="ix.houseware.category">
<level value="DEBUG" />
</logger>
<logger name="org.springframework.web.portlet">
<level value="DEBUG" />
</logger>
<logger name="org.springframework.web.servlet.ViewRendererServlet">
<level value="DEBUG" />
</logger>
<root>
<level value="DEBUG" />
<appender-ref ref="DAILY-ASYNC" />
<!-- appender-ref ref="CONSOLE" /-->
</root>
</log4j:configuration>
But it doesn't show the parameter that come with the hibernat sql logging.
Any suggestion would be very appreciated.
Thanks
Sam