2 Replies Latest reply on Apr 1, 2010 4:37 AM by Tej jbpm

    JBPM Hibernate logging

    Tej jbpm Novice

      Hi All,

       

      I have implemented JBPM successfully on Apache Tomcat 6.0.20. But I have an annoying problem with the hibernate logs.

       

      The following lines are written to the my Apache log files repeatedly even when the system is not in use( but the Apache is still running).

      Can anybody suggest how to turn off logging or reduce it to write only INFO messages.

       

      My hibernate.cfg file looks like this. Can I add some line here or where is the log4j.properties file which these uses.Thanks a lot for your help.

      --------------------------------

       

      <hibernate-configuration>

      <session-factory>


      <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

       

      <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

          <property name="hibernate.connection.url">jdbc:mysql://localhost/project</property>

          <property name="hibernate.connection.username">root</property>

          <property name="hibernate.connection.password">root</property>

        <!--

      <property name="connection.datasource">java:comp/env/jdbc/hsbc</property>

      <property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>

      <property name="jta.UserTransaction">java:comp/UserTransaction</property> -->


          <property name="hibernate.format_sql">true</property>

         

          <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>


      <mapping resource="jbpm.repository.hbm.xml" />

      <mapping resource="jbpm.execution.hbm.xml" />

      <mapping resource="jbpm.history.hbm.xml" />

      <mapping resource="jbpm.task.hbm.xml" />

      <mapping resource="jbpm.identity.hbm.xml" />


      </session-factory>

      </hibernate-configuration>

       

      LOG FILE

      --------------

       

      2010-03-31 13:36:47,399 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- beginning hibernate tx 13474557 --------------------------------------------------------
      2010-03-31 13:36:47,399 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- committing hibernate tx 23728357 -------------------------------------------------------
      2010-03-31 13:36:47,399 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- beginning hibernate tx 3151278 --------------------------------------------------------
      2010-03-31 13:36:47,399 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- committing hibernate tx 29278373 -------------------------------------------------------
      2010-03-31 13:36:47,915 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- beginning hibernate tx 24882950 --------------------------------------------------------
      2010-03-31 13:36:47,915 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- committing hibernate tx 28170956 -------------------------------------------------------
      2010-03-31 13:36:47,915 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- beginning hibernate tx 27296167 --------------------------------------------------------
      2010-03-31 13:36:47,915 [DispatcherThread] DEBUG (Log4jLog.java:60) - ----- committing hibernate tx 30551235 -----------------------