Exception with Mysql during deployment of processdefinition
anu123suya Dec 18, 2006 12:08 AMHi,
I could deploy a processdefinition in default hypersonic db. but when i try to deploy it in Mysql getting the following exception. have added users in the users table manually.
code used for deployment is
JbpmConfiguration jbpmConfig = JbpmConfiguration.getInstance();
JbpmContext jbpmContext = jbpmConfig.createJbpmContext();
ProcessDefinition processDefinition = ProcessDefinition.parseXmlResource("META-INF/processdefinition.xml");
jbpmContext.deployProcessDefinition(processDefinition);
Can anyone let me know if i am missing something??
Thanks in advance
processdefinition.xml is
<process-definition xmlns="urn:jbpm.org:jpdl-3.1" name="LeaveApproval"> <swimlane name="Applier"> <assignment expression="user(Ana)"></assignment> </swimlane> <swimlane name="Approver"> <assignment expression="user(Bask)"></assignment> </swimlane> <start-state name="ApplyLeave"> <task name="ApplyLeave" swimlane="Applicant"> <controller> <variable name="Start Date" access="read,write,required"></variable> <variable name="Duration" access="read,write,required"></variable> <variable name="Reason For Leave"></variable> </controller> </task> <transition name="" to="EvaluateLeave"></transition> </start-state> <task-node name="EvaluateLeave"> <task name="EvaluateLeave" swimlane="Approver"> <controller> <variable name="Start Date" access="read"></variable> <variable name="Duration" access="read"></variable> <variable name="Reason" access="read"></variable> <variable name="Comments"></variable> </controller> </task> <transition name="Approve/disapprove" to="End"></transition> <transition name="Provide More Info" to="MoreInfoNeeded"></transition> </task-node> <task-node name="MoreInfoNeeded"> <task name="Edit Leave Info" swimlane="Applicant"> <controller> <variable name="Start Date"></variable> <variable name="Duration"></variable> <variable name="Reason"></variable> <variable name="Comment" access="read"></variable> </controller> </task> <transition name="" to="EvaluateLeave"></transition> </task-node> <end-state name="End"></end-state> </process-definition>
Stack trace is
18:51:46,325 WARN [JpdlXmlReader] process xml warning: task references unknown
swimlane 'Applicant':<task xmlns="urn:jbpm.org:jpdl-3.1" name="ApplyLeave" swiml
ane="Applicant" blocking="false" signalling="true" priority="normal">
<controller config-type="field">
18:51:46,340 WARN [JpdlXmlReader] process xml warning: task references unknown
swimlane 'Applicant':
<controller config-type="field">
18:52:37,903 WARN [JDBCExceptionReporter] SQL Error: 1205, SQLState: 41000
18:52:37,903 ERROR [JDBCExceptionReporter] Lock wait timeout exceeded; try resta
rting transaction
18:52:37,903 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.graph.
def.ProcessDefinition]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2404)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentit
yInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplic
ate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(Abstrac
tSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId
(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGene
ratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrR
equestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTran
sient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(
DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:77
)
at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
at org.apache.jsp.Testdeploy_jsp._jspService(Testdeploy_jsp.java:51)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
14)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)<?xml version="1.0" encoding="UTF-8"?>