3 Replies Latest reply on Feb 14, 2011 6:55 PM by simonbaker

    how turn off jbpm and hibernate logging?

    simonbaker

      I cannot seem to turn off or control the jbpm and hibernate logging.  I have searched, but cannot find a solution that works.

       

      jbpm version: 3.2.GA

      Running under Tomcat 6.

       

      We deploy jbpm by putting the jbpm and hibernate jars in the web-inf\lib folder and the xml and properties files in the web-inf\classes folder.  We initialize the jbpm hibernate database by submitting the initialization script through a JDBC connection.

       

      Our jbpm application works pretty well.  But I do not know how to control the logging level.  I put "FATAL" in the log4j.properties file for the root logger and comment out the other lines or set them to "FATAL" level, but still get much detail logging in the Tomcat stdout.

       

      There is a logging.properties under the Tomcat ..conf folder, and the Java ..jre\lib folder, but no other that I'm aware of.

       

      If someone can help I would appreciate it.

       

      Here are the contents of our configuration files:

       

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

      jbpm.cfg.xml

       

      <jbpm-configuration>

        <!--
          The default configurations can be found in org/jbpm/default.jbpm.cfg.xml
          Those configurations can be overwritten by putting this file called
          jbpm.cfg.xml on the root of the classpath and put in the customized values.
        -->

      </jbpm-configuration>

       

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

      log4j.properties

       

      # Set root logger level to DEBUG and its only appender to CONSOLE.
      #log4j.rootLogger=DEBUG, CONSOLE
      log4j.rootLogger=FATAL, CONSOLE

      # CONSOLE
      log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
      log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
      log4j.appender.CONSOLE.layout.ConversionPattern=%d{HH:mm:ss,SSS} [%t] %-5p %C{1} : %m%n

      # LIMIT CATEGORIES

      #log4j.logger.org.jbpm=DEBUG
      #log4j.logger.org.jbpm.graph=DEBUG

      log4j.logger.org.jbpm=FATAL
      log4j.logger.org.jbpm.graph=FATAL

      # Hibernate debugging levels and their output
      #log4j.logger.org.hibernate=INFO
      log4j.logger.org.hibernate=FATAL
      #Log all SQL DML statements as they are executed

      #log4j.logger.org.hibernate.SQL=DEBUG
      #Log all JDBC parameters
      #log4j.logger.org.hibernate.type=DEBUG
      #Log all SQL DDL statements as they are executed
      #log4j.logger.org.hibernate.tool.hbm2ddl=DEBUG
      #Log the state of all entities (max 20 entities) associated with the session at flush time
      #log4j.logger.org.hibernate.pretty=DEBUG
      #Log all second-level cache activity
      #log4j.logger.org.hibernate.cache=DEBUG
      #Log transaction related activity
      #log4j.logger.org.hibernate.transaction=DEBUG
      #Log all JDBC resource acquisition
      ##log4j.logger.org.hibernate.jdbc=TRACE
      #Log HQL and SQL ASTs and other information about query parsing
      #log4j.logger.org.hibernate.hql.ast=DEBUG
      #Log all JAAS authorization requests
      #log4j.logger.org.hibernate.secure=DEBUG
      #Log everything (a lot of information, but very useful for troubleshooting)
      #log4j.logger.org.hibernate=DEBUG
      #log4j.logger.org.hibernate.tools=DEBUG

       

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

       

      hibernate.cfg.xml

       

      <?xml version='1.0' encoding='utf-8'?>

      <!DOCTYPE hibernate-configuration PUBLIC
                "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

      <hibernate-configuration>
        <session-factory>

          <!-- JDBC connection properties (begin) -->
      <!-- Duck
          <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
          <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
          <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.0.2:1433/Image2000hib</property>
          <property name="hibernate.connection.username">rmsadmin</property>
          <property name="hibernate.connection.password">admin</property>
      -->

      <!--
          <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
          <property name="hibernate.connection.driver_class">com.inet.ora.OraDriver</property>
          <property name="hibernate.connection.url">jdbc:inetora:HP1:1521:RMS9HP1?streamstolob=true</property>
          <property name="hibernate.connection.username">rmsadmin</property>
          <property name="hibernate.connection.password">admin</property>
      -->

      <!-- HP1 local oracle with i-net driver -->
      <!--
      -->
          <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
          <property name="hibernate.connection.driver_class">com.inet.ora.OraDriver</property>
          <property name="hibernate.connection.url">jdbc:inetora:HP1:1521:RMS9HP1?streamstolob=true</property>
          <property name="hibernate.connection.username">image2000hib</property>
          <property name="hibernate.connection.password">admin</property>

      <!-- HP1 local oracle with oracle driver -->
      <!--
          <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
          <property name="hibernate.connection.url">jdbc:oracle:thin:image2000hib/admin@//localhost:1521/rms9hp1</property>
          <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
          <property name="hibernate.connection.username">image2000hib</property>
          <property name="hibernate.connection.password">admin</property>
      -->

      <!-- Bear local sql server with i-net driver -->
      <!--
          <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
          <property name="hibernate.connection.driver_class">com.inet.tds.TdsDriver</property>
          <property name="hibernate.connection.url">jdbc:inetdae7:192.168.2.12?database=Image2000hib</property>
          <property name="hibernate.connection.username">rmsadmin</property>
          <property name="hibernate.connection.password">admin</property>
      -->

      <!-- Bear local sql server with jtds driver -->
      <!--
          <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
          <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
          <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.2.12:1433/Image2000hib</property>
          <property name="hibernate.connection.username">rmsadmin</property>
          <property name="hibernate.connection.password">admin</property>
      -->
      <!--
          <property name="hibernate.c3p0.acquire_increment">1</property>
          <property name="hibernate.c3p0.min_size">1</property>
          <property name="hibernate.c3p0.max_size">5</property>
          <property name="hibernate.c3p0.timeout">300</property>
          <property name="hibernate.c3p0.max_statements">50</property>
          <property name="hibernate.c3p0.idle_test_period">300</property>
      -->

          <!-- JDBC connection properties (end) -->
         
          <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
         

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


          <!-- logging properties (begin) -->
          <property name="hibernate.show_sql">true</property>
          <property name="hibernate.format_sql">true</property>
          <property name="hibernate.use_sql_comments">true</property>
          <!-- logging properties (end) -->
         
           <!-- ############################################ -->
          <!-- # mapping files with external dependencies # -->
          <!-- ############################################ -->

          <!-- following mapping file has a dependendy on   -->
          <!-- 'bsh-{version}.jar'.                         -->
          <!-- uncomment this if you don't have bsh on your -->
          <!-- classpath.  you won't be able to use the     -->
          <!-- script element in process definition files   -->
          <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>

          <!-- following mapping files have a dependendy on  -->
          <!-- 'jbpm-identity.jar', mapping files            -->
          <!-- of the pluggable jbpm identity component.     -->
          <!-- Uncomment the following 3 lines if you        -->
          <!-- want to use the jBPM identity mgmgt           -->
          <!-- component.                                    -->
          <!-- identity mappings (begin) -->
          <mapping resource="org/jbpm/identity/User.hbm.xml"/>
          <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
          <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
          <!-- identity mappings (end) -->
         
          <!-- following mapping files have a dependendy on  -->
          <!-- the JCR API                                   -->
          <!-- jcr mappings (begin) ===
          <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
          ==== jcr mappings (end) -->


          <!-- ###################### -->
          <!-- # jbpm mapping files # -->
          <!-- ###################### -->

          <!-- hql queries and type defs -->
          <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
         
          <!-- graph.def mapping files -->
          <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
          <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
          <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>

          <!-- graph.node mapping files -->
          <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
          <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>

          <!-- context.def mapping files -->
          <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
          <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>

          <!-- taskmgmt.def mapping files -->
          <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>

          <!-- module.def mapping files -->
          <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>

          <!-- bytes mapping files -->
          <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>

          <!-- file.def mapping files -->
          <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>

          <!-- scheduler.def mapping files -->
          <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
          <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>

          <!-- graph.exe mapping files -->
          <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
          <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
          <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
          <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>

          <!-- module.exe mapping files -->
          <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
             
          <!-- context.exe mapping files -->
          <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/>
          <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>

          <!-- job mapping files -->
      <!--
          <mapping resource="org/jbpm/job/Job.hbm.xml"/>
          <mapping resource="org/jbpm/job/Timer.hbm.xml"/>
          <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/>
          <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/>
      -->

          <!-- taskmgmt.exe mapping files -->
          <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>

          <!-- logging mapping files -->
          <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
          <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
          <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
          <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
          <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
         
        </session-factory>
      </hibernate-configuration>

       

       

        • 1. how turn off jbpm and hibernate logging?
          simonbaker

          Does anyone know where the following logging output (in Tomcat stdout.log) comes from (jbpm, or hibernate)?

           

          Regards,

          -SB

           

          Hibernate:

              /* load org.jbpm.graph.exe.Token */ select

                  token0_.ID_ as ID1_21_0_,

                  token0_.VERSION_ as VERSION2_21_0_,

                  token0_.NAME_ as NAME3_21_0_,

                  token0_.START_ as START4_21_0_,

                  token0_.END_ as END5_21_0_,

                  token0_.NODEENTER_ as NODEENTER6_21_0_,

                  token0_.NEXTLOGINDEX_ as NEXTLOGI7_21_0_,

                  token0_.ISABLETOREACTIVATEPARENT_ as ISABLETO8_21_0_,

                  token0_.ISTERMINATIONIMPLICIT_ as ISTERMIN9_21_0_,

                  token0_.ISSUSPENDED_ as ISSUSPE10_21_0_,

                  token0_.LOCK_ as LOCK11_21_0_,

                  token0_.NODE_ as NODE12_21_0_,

                  token0_.PROCESSINSTANCE_ as PROCESS13_21_0_,

                  token0_.PARENT_ as PARENT14_21_0_,

                  token0_.SUBPROCESSINSTANCE_ as SUBPROC15_21_0_

              from

                  JBPM_TOKEN token0_

              where

                  token0_.ID_=?

          Hibernate:

              /* load org.jbpm.graph.exe.ProcessInstance */ select

                  processins0_.ID_ as ID1_20_0_,

                  processins0_.VERSION_ as VERSION2_20_0_,

                  processins0_.KEY_ as KEY3_20_0_,

                  processins0_.START_ as START4_20_0_,

                  processins0_.END_ as END5_20_0_,

                  processins0_.ISSUSPENDED_ as ISSUSPEN6_20_0_,

                  processins0_.PROCESSDEFINITION_ as PROCESSD7_20_0_,

                  processins0_.ROOTTOKEN_ as ROOTTOKEN8_20_0_,

                  processins0_.SUPERPROCESSTOKEN_ as SUPERPRO9_20_0_

              from

                  JBPM_PROCESSINSTANCE processins0_

              where

                  processins0_.ID_=?

          Hibernate:

              /* load one-to-many org.jbpm.graph.exe.ProcessInstance.instances */ select

                  instances0_.PROCESSINSTANCE_ as PROCESSI4_1_,

                  instances0_.ID_ as ID1_1_,

                  instances0_.NAME_ as NAME6_1_,

                  instances0_.ID_ as ID1_23_0_,

                  instances0_.VERSION_ as VERSION3_23_0_,

                  instances0_.PROCESSINSTANCE_ as PROCESSI4_23_0_,

                  instances0_.TASKMGMTDEFINITION_ as TASKMGMT5_23_0_,

                  instances0_.CLASS_ as CLASS2_23_0_

              from

                  JBPM_MODULEINSTANCE instances0_

              where

                  instances0_.PROCESSINSTANCE_=?

          Hibernate:

              /* load org.jbpm.graph.def.ProcessDefinition */ select

                  processdef0_.ID_ as ID1_4_0_,

                  processdef0_.NAME_ as NAME3_4_0_,

                  processdef0_.DESCRIPTION_ as DESCRIPT4_4_0_,

                  processdef0_.VERSION_ as VERSION5_4_0_,

                  processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_4_0_,

                  processdef0_.STARTSTATE_ as STARTSTATE7_4_0_

              from

                  JBPM_PROCESSDEFINITION processdef0_

              where

                  processdef0_.ID_=?

          Hibernate:

              /* load one-to-many org.jbpm.context.exe.ContextInstance.tokenVariableMaps */ select

                  tokenvaria0_.CONTEXTINSTANCE_ as CONTEXTI4_1_,

                  tokenvaria0_.ID_ as ID1_1_,

                  tokenvaria0_.TOKEN_ as TOKEN3_1_,

                  tokenvaria0_.ID_ as ID1_24_0_,

                  tokenvaria0_.VERSION_ as VERSION2_24_0_,

                  tokenvaria0_.TOKEN_ as TOKEN3_24_0_,

                  tokenvaria0_.CONTEXTINSTANCE_ as CONTEXTI4_24_0_

              from

                  JBPM_TOKENVARIABLEMAP tokenvaria0_

              where

                  tokenvaria0_.CONTEXTINSTANCE_=?

          Hibernate:

              /* load one-to-many org.jbpm.context.exe.TokenVariableMap.variableInstances */ select

                  variablein0_.TOKENVARIABLEMAP_ as TOKENVAR7_1_,

                  variablein0_.ID_ as ID1_1_,

                  variablein0_.NAME_ as NAME4_1_,

                  variablein0_.ID_ as ID1_25_0_,

                  variablein0_.VERSION_ as VERSION3_25_0_,

                  variablein0_.NAME_ as NAME4_25_0_,

                  variablein0_.CONVERTER_ as CONVERTER5_25_0_,

                  variablein0_.TOKEN_ as TOKEN6_25_0_,

                  variablein0_.TOKENVARIABLEMAP_ as TOKENVAR7_25_0_,

                  variablein0_.PROCESSINSTANCE_ as PROCESSI8_25_0_,

                  variablein0_.BYTEARRAYVALUE_ as BYTEARRA9_25_0_,

                  variablein0_.DATEVALUE_ as DATEVALUE10_25_0_,

                  variablein0_.DOUBLEVALUE_ as DOUBLEV11_25_0_,

                  variablein0_.LONGIDCLASS_ as LONGIDC12_25_0_,

                  variablein0_.LONGVALUE_ as LONGVALUE13_25_0_,

                  variablein0_.STRINGIDCLASS_ as STRINGI14_25_0_,

                  variablein0_.STRINGVALUE_ as STRINGV15_25_0_,

                  variablein0_.CLASS_ as CLASS2_25_0_

              from

          • 2. how turn off jbpm and hibernate logging?
            bpmn2user

            Did you try the following?

             

             

                <!-- logging properties (begin) -->

                <property name="hibernate.show_sql">false</property>

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

                <property name="hibernate.use_sql_comments">false</property>

                <!-- logging properties (end) -->

            1 of 1 people found this helpful
            • 3. how turn off jbpm and hibernate logging?
              simonbaker

              Thanks, I'll try that --  have not  done that as I wanted to control it through the logging system itself if possible.

               

              Do you know what loggers these properties correspond to?

               

              <!-- logging properties (begin) -->

                  <property name="hibernate.show_sql">false</property>

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

                  <property name="hibernate.use_sql_comments">false</property>

                  <!-- logging properties (end) -->

               

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

               

              Also, do you know where this type of logging is coming from?

               

              14:03:39,620 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors
              14:03:39,620 [http-443-5] DEBUG HqlSqlBaseWalker : select << begin [level=1, statement=select]
              14:03:39,636 [http-443-5] DEBUG FromElement : FromClause{level=1} :  org.jbpm.taskmgmt.exe.TaskInstance (ti) -> taskinstan0_
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti -> taskinstan0_.ID_
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti -> taskinstan0_.ID_
              14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> actorId (class)]
              14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : actorId -> org.hibernate.type.StringType@17a8369
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti.actorId -> taskinstan0_.ACTORID_
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti -> taskinstan0_.ID_
              14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> isSuspended (class)]
              14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isSuspended -> org.hibernate.type.BooleanType@1b52eaf
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti.isSuspended -> taskinstan0_.ISSUSPENDED_
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti -> taskinstan0_.ID_
              14:03:39,636 [http-443-5] DEBUG FromElement : handling property dereference [org.jbpm.taskmgmt.exe.TaskInstance (ti) -> isOpen (class)]
              14:03:39,636 [http-443-5] DEBUG DotNode : getDataType() : isOpen -> org.hibernate.type.BooleanType@1b52eaf
              14:03:39,636 [http-443-5] DEBUG FromReferenceNode : Resolved :  ti.isOpen -> taskinstan0_.ISOPEN_
              14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select : finishing up [level=1, statement=select]
              14:03:39,636 [http-443-5] DEBUG HqlSqlWalker : processQuery() :  ( SELECT ( {select clause} taskinstan0_.ID_ ) ( FromClause{level=1} JBPM_TASKINSTANCE taskinstan0_ ) ( where ( and ( and ( in ( taskinstan0_.ACTORID_ taskinstan0_.ID_ actorId ) ( inList ? ) ) ( != ( taskinstan0_.ISSUSPENDED_ taskinstan0_.ID_ isSuspended ) 1 ) ) ( = ( taskinstan0_.ISOPEN_ taskinstan0_.ID_ isOpen ) 1 ) ) ) )
              14:03:39,636 [http-443-5] DEBUG JoinProcessor : Using FROM fragment [JBPM_TASKINSTANCE taskinstan0_]
              14:03:39,636 [http-443-5] DEBUG HqlSqlBaseWalker : select >> end [level=1, statement=select]
              14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- SQL AST ---
              \-[SELECT] QueryNode: 'SELECT'  querySpaces (JBPM_TASKINSTANCE)
                  +-[SELECT_CLAUSE] SelectClause: '{select clause}'
                  |  +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_ as ID1_27_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}
                  |  \-[SQL_TOKEN] SqlFragment: 'taskinstan0_.VERSION_ as VERSION3_27_, taskinstan0_.NAME_ as NAME4_27_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_27_, taskinstan0_.ACTORID_ as ACTORID6_27_, taskinstan0_.CREATE_ as CREATE7_27_, taskinstan0_.START_ as START8_27_, taskinstan0_.END_ as END9_27_, taskinstan0_.DUEDATE_ as DUEDATE10_27_, taskinstan0_.PRIORITY_ as PRIORITY11_27_, taskinstan0_.ISCANCELLED_ as ISCANCE12_27_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_27_, taskinstan0_.ISOPEN_ as ISOPEN14_27_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_27_, taskinstan0_.ISBLOCKING_ as ISBLOCKING16_27_, taskinstan0_.TASK_ as TASK17_27_, taskinstan0_.TOKEN_ as TOKEN18_27_, taskinstan0_.PROCINST_ as PROCINST19_27_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_27_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_27_'
                  +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[ti], fromElementByTableAlias=[taskinstan0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
                  |  \-[FROM_FRAGMENT] FromElement: 'JBPM_TASKINSTANCE taskinstan0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ti,role=null,tableName=JBPM_TASKINSTANCE,tableAlias=taskinstan0_,origin=null,colums={,className=org.jbpm.taskmgmt.exe.TaskInstance}}
                  \-[WHERE] SqlNode: 'where'
                     \-[AND] SqlNode: 'and'
                        +-[AND] SqlNode: 'and'
                        |  +-[IN] InLogicOperatorNode: 'in'
                        |  |  +-[DOT] DotNode: 'taskinstan0_.ACTORID_' {propertyName=actorId,dereferenceType=4,propertyPath=actorId,path=ti.actorId,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}
                        |  |  |  +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}
                        |  |  |  \-[IDENT] IdentNode: 'actorId' {originalText=actorId}
                        |  |  \-[IN_LIST] SqlNode: 'inList'
                        |  |     \-[NAMED_PARAM] ParameterNode: '?' {name=actorIds, expectedType=org.hibernate.type.StringType@17a8369}
                        |  \-[NE] BinaryLogicOperatorNode: '!='
                        |     +-[DOT] DotNode: 'taskinstan0_.ISSUSPENDED_' {propertyName=isSuspended,dereferenceType=4,propertyPath=isSuspended,path=ti.isSuspended,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}
                        |     |  +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}
                        |     |  \-[IDENT] IdentNode: 'isSuspended' {originalText=isSuspended}
                        |     \-[TRUE] BooleanLiteralNode: '1'
                        \-[EQ] BinaryLogicOperatorNode: '='
                           +-[DOT] DotNode: 'taskinstan0_.ISOPEN_' {propertyName=isOpen,dereferenceType=4,propertyPath=isOpen,path=ti.isOpen,tableAlias=taskinstan0_,className=org.jbpm.taskmgmt.exe.TaskInstance,classAlias=ti}
                           |  +-[ALIAS_REF] IdentNode: 'taskinstan0_.ID_' {alias=ti, className=org.jbpm.taskmgmt.exe.TaskInstance, tableAlias=taskinstan0_}
                           |  \-[IDENT] IdentNode: 'isOpen' {originalText=isOpen}
                           \-[TRUE] BooleanLiteralNode: '1'

              14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors
              14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : HQL:
                 
                    select ti
                    from org.jbpm.taskmgmt.exe.TaskInstance as ti
                    where ti.actorId in ( :actorIds )
                      and ti.isSuspended != true
                      and ti.isOpen = true
                 
               
              14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : SQL: select taskinstan0_.ID_ as ID1_27_, taskinstan0_.VERSION_ as VERSION3_27_, taskinstan0_.NAME_ as NAME4_27_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_27_, taskinstan0_.ACTORID_ as ACTORID6_27_, taskinstan0_.CREATE_ as CREATE7_27_, taskinstan0_.START_ as START8_27_, taskinstan0_.END_ as END9_27_, taskinstan0_.DUEDATE_ as DUEDATE10_27_, taskinstan0_.PRIORITY_ as PRIORITY11_27_, taskinstan0_.ISCANCELLED_ as ISCANCE12_27_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_27_, taskinstan0_.ISOPEN_ as ISOPEN14_27_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_27_, taskinstan0_.ISBLOCKING_ as ISBLOCKING16_27_, taskinstan0_.TASK_ as TASK17_27_, taskinstan0_.TOKEN_ as TOKEN18_27_, taskinstan0_.PROCINST_ as PROCINST19_27_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_27_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_27_ from JBPM_TASKINSTANCE taskinstan0_ where (taskinstan0_.ACTORID_ in (?)) and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
              14:03:39,636 [http-443-5] DEBUG ErrorCounter : throwQueryException() : no errors
              14:03:39,636 [http-443-5] DEBUG HQLQueryPlan : HQL param location recognition took 0 mills (
                 
                    select ti
                    from org.jbpm.taskmgmt.exe.TaskInstance as ti
                    where ti.actorId in ( :actorIds )
                      and ti.isSuspended != true
                      and ti.isOpen = true
                 
                )
              14:03:39,636 [http-443-5] DEBUG SessionFactoryImpl : Checking named query: LoggingSession.findLogsByToken
              14:03:39,636 [http-443-5] DEBUG QueryPlanCache : unable to locate HQL query plan in cache; generating (
                 
                    select pl
                    from org.jbpm.logging.log.ProcessLog as pl
                    where pl.token = :token
                    order by pl.index
                 
                )
              14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : parse() - HQL:
                 
                    select pl
                    from org.jbpm.logging.log.ProcessLog as pl
                    where pl.token = :token
                    order by pl.index
                 
               
              14:03:39,636 [http-443-5] DEBUG QueryTranslatorImpl : --- HQL AST ---