jbpm与spring整合不停显示查询语句select jobimpl0_.DBID_ as DBID1_6_, jobimpl0_.DBVERSION_ as DBVERSION3_6_......
将jbpm4 和spring整合一起使用时,当我启动服务器的时候,后台就不停的显示:
Hibernate: select jobimpl0_.DBID_ as DBID1_6_, jobimpl0_.DBVERSION_ as DBVERSION3_6_, jobimpl0_.DUEDATE_ as DUEDATE4_6_, jobimpl0_.STATE_ as STATE5_6_, jobimpl0_.ISEXCLUSIVE_ as ISEXCLUS6_6_, jobimpl0_.LOCKOWNER_ as LOCKOWNER7_6_, jobimpl0_.LOCKEXPTIME_ as LOCKEXPT8_6_, jobimpl0_.EXCEPTION_ as EXCEPTION9_6_, jobimpl0_.RETRIES_ as RETRIES10_6_, jobimpl0_.PROCESSINSTANCE_ as PROCESS11_6_, jobimpl0_.EXECUTION_ as EXECUTION12_6_, jobimpl0_.CFG_ as CFG13_6_, jobimpl0_.SIGNAL_ as SIGNAL14_6_, jobimpl0_.EVENT_ as EVENT15_6_, jobimpl0_.REPEAT_ as REPEAT16_6_, jobimpl0_.CLASS_ as CLASS2_6_ from JBPM4_JOB jobimpl0_ where (jobimpl0_.LOCKOWNER_ is null) and jobimpl0_.RETRIES_>0 and jobimpl0_.STATE_<>'suspended' order by jobimpl0_.DUEDATE_ asc limit ?
分析:
这个往往会被很多人以为是一个错误。
源头是因为:在src目录下的配置文件“jbpm.cfg.xml”中的“<import resource="jbpm.jobexecutor.cfg.xml" />”这句代码引起的,加上后,会不停的查询JBPM4_JOB。
其实这个是JBPM4的一个定时器,只是为了执行异步消息,才定时去搜索数据库,看日志也看得到,只是sql语句而已,不是错误。不影响程序的运行。
可以通过注释掉“jbpm.cfg.xml”中的“<import resource="jbpm.jobexecutor.cfg.xml" />”这句代码来取消这个不停查询的行为。