2 tuposky tuposky 于 2013.08.12 16:25 提问

jbpm4.4 部署时,发生死锁问题

jbpm中deploy的时候出现死锁问题。
发现数据库中以下三个表被锁定
JBPM4_LOB
JBPM4_DEPLOYMENT
JBPM4_DEPLOYPROP

然后控制台不断重复打印下面的sql语句,像死循环一样,求解。
网上说加上索引就好了,不知道具体在哪张表哪个字段上加索引呢?求解
Hibernate:
select
deployment0_.dbid_ as dbid1_43_0_,
deployment0_.name_ as name2_43_0_,
deployment0_.timestamp_ as timestamp3_43_0_,
deployment0_.state_ as state4_43_0_
from
jbpm4_deployment deployment0_
where
deployment0_.dbid_=?
Hibernate:
select
resources0_.deployment_ as deployment4_43_1_,
resources0_.dbid_ as dbid1_1_,
resources0_.name_ as name5_1_,
resources0_.dbid_ as dbid1_33_0_,
resources0_.dbversion_ as dbversion2_33_0_,
resources0_.blob_value_ as blob3_33_0_
from
jbpm4_lob resources0_
where
resources0_.deployment_=?
Hibernate:
select
objectprop0_.deployment_ as deployment2_43_1_,
objectprop0_.dbid_ as dbid1_1_,
objectprop0_.dbid_ as dbid1_44_0_,
objectprop0_.deployment_ as deployment2_44_0_,
objectprop0_.objname_ as objname3_44_0_,
objectprop0_.key_ as key4_44_0_,
objectprop0_.stringval_ as stringval5_44_0_,
objectprop0_.longval_ as longval6_44_0_
from
jbpm4_deployprop objectprop0_
where
objectprop0_.deployment_=?

1个回答

DKQ991340512
DKQ991340512   2014.08.18 09:09

请问这是如何解决的 求解 谢谢

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!