• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to supress SQL Queries in log file

 
shyam sunder prasad
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<appender name="console" class="org.apache.log4j.ConsoleAppender">
<param name="Threshold" value="info"/>
<param name="Target" value="System.out"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{ABSOLUTE} [%t] %-5p %c{1} - %m%n"/>
</layout>
<filter class="org.apache.log4j.filter.ExpressionFilter">
<param name="Expression" value="EXCEPTION ~= org.hibernate.LazyInitializationException"/>
<param name="AcceptOnMatch" value="false"/>
</filter>
</appender>
<root>
<priority value ="warn" />
<appender-ref ref="console" />
<!--<appender-ref ref="rolling-file" />
--></root>
</log4j:configuration>


this is my log4j.xml file,
can you help me out how to supress sql statements in log4j and i am getting some warnings like log4j is not initialized properly.

 
Suresh Vadivel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope you are using Hibernate and getting SQL queries also printed in log file.
If this is the case, Please make the show_sql property as false in hibernate config file. This will turn off the feature of sql getting printed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic