问题描述
JBPM4.4与SSH框架整合之后,启动Tomcat6.0之后,一直在查询JBPM4_JOB,而且每个5秒查询一次。求各位大侠帮我解决一下。Hibernate:selectjobimpl0_.DBID_asDBID1_3_,jobimpl0_.DBVERSION_asDBVERSION3_3_,jobimpl0_.DUEDATE_asDUEDATE4_3_,jobimpl0_.STATE_asSTATE5_3_,jobimpl0_.ISEXCLUSIVE_asISEXCLUS6_3_,jobimpl0_.LOCKOWNER_asLOCKOWNER7_3_,jobimpl0_.LOCKEXPTIME_asLOCKEXPT8_3_,jobimpl0_.EXCEPTION_asEXCEPTION9_3_,jobimpl0_.RETRIES_asRETRIES10_3_,jobimpl0_.PROCESSINSTANCE_asPROCESS11_3_,jobimpl0_.EXECUTION_asEXECUTION12_3_,jobimpl0_.CFG_asCFG13_3_,jobimpl0_.SIGNAL_asSIGNAL14_3_,jobimpl0_.EVENT_asEVENT15_3_,jobimpl0_.REPEAT_asREPEAT16_3_,jobimpl0_.CLASS_asCLASS2_3_fromJBPM4_JOBjobimpl0_where(jobimpl0_.LOCKOWNER_isnull)andjobimpl0_.RETRIES_>0andjobimpl0_.STATE_<>'suspended'orderbyjobimpl0_.DUEDATE_asclimit?11:29:45,890DEBUGAbstractBatcher:426-abouttoopenResultSet(openResultSets:0,globally:0)11:29:45,890DEBUGAbstractBatcher:433-abouttocloseResultSet(openResultSets:1,globally:1)11:29:45,890DEBUGAbstractBatcher:418-abouttoclosePreparedStatement(openPreparedStatements:1,globally:1)11:29:45,890DEBUGStatefulPersistenceContext:893-initializingnon-lazycollections11:29:45,890DEBUGJDBCTransaction:130-commit11:29:45,891DEBUGJDBCTransaction:223-re-enablingautocommit11:29:45,891DEBUGJDBCTransaction:143-committedJDBCConnection11:29:45,891DEBUGConnectionManager:325-transactioncompletedonsessionwithon_closeconnectionreleasemode;besuretoclosethesessiontoreleaseJDBCresources!11:29:45,891DEBUGConnectionManager:464-releasingJDBCconnection[(openPreparedStatements:0,globally:0)(openResultSets:0,globally:0)]11:29:45,891DEBUGConnectionManager:325-transactioncompletedonsessionwithon_closeconnectionreleasemode;besuretoclosethesessiontoreleaseJDBCresources!我的配置如下:applicationContext.xml文件:<beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.2.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.2.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.2.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.2.xsd"><context:annotation-config/><context:component-scanbase-package="com.ssh"/><aop:aspectj-autoproxy/><!--<beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close"><propertyname="driverClassName"value="com.mysql.jdbc.Driver"/><propertyname="url"value="jdbc:mysql://localhost:3306/db_spring"/><propertyname="username"value="root"/><propertyname="password"value="123"/></bean>--><beanclass="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><propertyname="locations"value="classpath:jdbc.properties"/></bean><beanid="dataSource"destroy-method="close"class="org.apache.commons.dbcp.BasicDataSource"><propertyname="driverClassName"value="${jdbc.driverClassName}"/><propertyname="url"value="${jdbc.url}"/><propertyname="username"value="${jdbc.username}"/><propertyname="password"value="${jdbc.password}"/></bean><!--jbpm4.4工作流--><beanid="springHelper"class="org.jbpm.pvm.internal.processengine.SpringHelper"><propertyname="jbpmCfg"value="spring-jbpm4.cfg.xml"/></bean><beanid="processEngine"factory-bean="springHelper"factory-method="createProcessEngine"/><beanid="sessionFactory"class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"><propertyname="dataSource"ref="dataSource"/><!--<propertyname="annotatedClasses"><list><value>com.sram.model.User</value><value>com.sram.model.Log</value></list></property>--><propertyname="packagesToScan"><list><value>com.ssh.model</value></list></property><!--org.hibernate.dialect.MySQLDialect--><propertyname="hibernateProperties"><props><propkey="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop><propkey="hibernate.show_sql">true</prop><propkey="hibernate.format_sql">true</prop></props></property><propertyname="mappingLocations"><list><value>classpath:jbpm.execution.hbm.xml</value><value>classpath:jbpm.history.hbm.xml</value><value>classpath:jbpm.identity.hbm.xml</value><value>classpath:jbpm.repository.hbm.xml</value><value>classpath:jbpm.task.hbm.xml</value></list></property></bean><beanid="hibernateTemplate"class="org.springframework.orm.hibernate3.HibernateTemplate"><propertyname="sessionFactory"ref="sessionFactory"></property></bean><beanid="txManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager"><propertyname="sessionFactory"ref="sessionFactory"/></bean><tx:adviceid="txAdvice"transaction-manager="txManager"><tx:attributes><tx:methodname="exists"read-only="true"/><tx:methodname="add*"propagation="REQUIRED"/><tx:methodname="delete*"propagation="REQUIRED"/><tx:methodname="update*"propagation="REQUIRED"/></tx:attributes></tx:advice><aop:config><aop:pointcutid="entryPointMethod"expression="execution(public*com.ssh.service..*.*(..))"/><aop:advisoradvice-ref="txAdvice"pointcut-ref="entryPointMethod"/></aop:config></beans>spring-jbpm4.cfg.xml文件配置如下:<?xmlversion="1.0"encoding="UTF-8"?><jbpm-configuration><importresource="jbpm.default.cfg.xml"/><importresource="jbpm.tx.spring.cfg.xml"/><importresource="jbpm.jpdl.cfg.xml"/><importresource="jbpm.bpmn.cfg.xml"/><importresource="jbpm.identity.cfg.xml"/><importresource="jbpm.businesscalendar.cfg.xml"/><importresource="jbpm.console.cfg.xml"/><importresource="jbpm.jobexecutor.cfg.xml"/><process-engine-context><stringname="spring.cfg"value="applicationContext.xml"/></process-engine-context></jbpm-configuration>
解决方案
解决方案二:
希望各位大侠有知道的,帮我解答一下。就是整合JBPM4.4+SSH后,启动Tomcat,输出窗口一直在查询JBPM_JOB这张表,而且每个5秒查询一次,但是我并没有做任何操作。
解决方案三:
,究竟是为什么呀!
解决方案四:
不懂,帮你顶了,只用过6
解决方案五:
请问你解决了吗遇到同样问题了
解决方案六:
我把jbpm.cfg.xml中<importresource="jbpm.jobexecutor.cfg.xml"/>注释掉就不会出现这种问题了不过不知道以后在开发中会不会出现什么问题,有人知道的话希望能详细说明下