[jboss-user] [JBoss jBPM] - Exception with Mysql during deployment of processdefinition

[anu123suya]

Hi, 
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"?>




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994553#3994553

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994553