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

    Turning off Hibernate log.INFO msgs (Jboss 6)

    rsearls Newbie

      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_ 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"


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

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

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




      Here is my log4j.properties file


      # STDOUT appender



      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