title: Stop Hibernate SQL logs coming on catalina.out
body: <p>I was making a log4j.xml for one of my projects in netbeans .
  Here is its contents :
  
  </p>
  
  <pre><code>&lt;log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"&gt;
  
      &lt;appender name="FILE" class="org.apache.log4j.DailyRollingFileAppender"&gt;
              &lt;param name="file" value="${catalina.home}/logs/MyLogs.log" /&gt;
              &lt;param name="DatePattern" value="'.'yyyy-MM-dd" /&gt;
              &lt;param name="Threshold" value="INFO" /&gt;
              &lt;layout class="org.apache.log4j.PatternLayout"&gt;
                  &lt;param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m #]%n" /&gt;
              &lt;/layout&gt;
          &lt;/appender&gt;
  
      &lt;appender name="sqlLogs" class="org.apache.log4j.DailyRollingFileAppender"&gt;
              &lt;param name="file" value="${catalina.home}/logs/MySqlLogs.log" /&gt;
              &lt;param name="DatePattern" value="'.'yyyy-MM-dd" /&gt;
              &lt;param name="Threshold" value="TRACE" /&gt;
              &lt;layout class="org.apache.log4j.PatternLayout"&gt;
                  &lt;param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n" /&gt;
              &lt;/layout&gt;
          &lt;/appender&gt;    
  
      &lt;root&gt;
              &lt;level value ="INFO" /&gt;    
              &lt;appender-ref ref="FILE" /&gt;
      &lt;/root&gt;
  
      &lt;logger name="org.hibernate.SQL" additivity="false" &gt;
              &lt;level value="DEBUG" /&gt;
              &lt;appender-ref ref="sqlLogs" /&gt;
      &lt;/logger&gt;
  
  
  &lt;/log4j:configuration&gt;
  </code></pre>
  
  <p>Now i want sql logs to go only to MySqlLogs.log but they are appearing on both MySqlLogs.log and catalina.out .
  The format of logs in catalina.out is</p>
  
  <pre><code>Hibernate : select ....
  Hibernate : insert into ....
  </code></pre>
  
  <p>Can anyone help me out on this please .</p>