1 Reply Latest reply on Jan 20, 2012 11:12 PM by jaikiran

    Turning off Hibernate log.INFO msgs (Jboss 6)

    rsearls
    rsearls Jan 19, 2012 9:49 AM

      I'm running JBoss-6.1.0.Final, the "default" server.  My app is using

      Spring 3.  In the bean def I've set show_sql=false and my log4j.properties

      has no references to the hibernate log categories. The default setting

      of category="org.hibernate" in default/deploy/jboss-logging.xml was

      not active because it was commented out.  I uncommented the code and

      set the value to WARN;  upon restart no change to the msg output.

       

      Where, how to turn this off, "INFO  [STDOUT] Hibernate:" messages?

       

      16:44:33,548 INFO  [STDOUT] Hibernate: select cluseranci0_.ID as ID59_,

      cluseranci0_.COHORT_ID as COHORT4_59_, cluseranci0_.ROLE_ID as ROLE5_59_,

      cluseranci0_.USER_ID as USER6_59_, cluseranci0_.UPDATED_BY as UPDATED2_59_,

      cluseranci0_.UPDATED_DATE as UPDATED3_59_ from HMM_OWNER.CL_USER_ANCILLARY

      cluseranci0_ where cluseranci0_.USER_ID=? order by cluseranci0_.ROLE_ID

       

      I am using a stnd (unaltered) "default" server.

       

      Here is my bean definition.

       

      <bean id="mmt_qa_HBP_Oracel_DataSourceJPAVendorAdapter"

            class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">

                  <property name="showSql" value="false" />

                  <property name="generateDdl" value="false" />

                  <property name="databasePlatform" value="org.hibernate.dialect.Oracle9iDialect" />

      </bean>

       

       

      Here is my log4j.properties file

       

      # STDOUT appender

      log4j.appender.STDOUT=org.apache.log4j.ConsoleAppender

      log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout

      log4j.appender.STDOUT.layout.ConversionPattern=%d %p [%t] %C{1} - %m\n

       

      # use the STDOUT appender. set the level to ERROR.

      log4j.rootLogger=INFO, STDOUT

      log4j.category.atomikos=ERROR, STDOUT

      log4j.category.org.springframework=ERROR, STDOUT