[jboss-user] [JBoss Seam] - SQLException on jBPM Process Creation

[ajaneesh]

Hi All,

I get the below error when i submit to an action method with the @CreateProcess annotation.   What could be the reason.  The error is very clear,  a parent entry needs to be in the table jbpm_processinstance.  The primary key in question is a auto generated one. (set up by jbpm).  I manually created an entry in the processinstance table and ID_ was automatically generated.  Dont understand what the problem could be, any help is appreciated.  

I am using MySQL, SEAM 1.2.1-GA and Jboss 4.0.5-GA.

Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`cvsportal/jbpm_moduleinstance`, CONSTRAINT `FK_MODINST_PRCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`))
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)




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

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