[jboss-user] [jBPM] New message: "Re: jbpm 4: Can't complete task in HSQLDB and DERBY"

[Jan Scherf]

User development,

A new message was posted in the thread "jbpm 4: Can't complete task in HSQLDB and DERBY":

http://community.jboss.org/message/521787#521787

Author  : Jan Scherf
Profile : http://community.jboss.org/people/JanScherf

Message:
--------------------------------------------------------------
The reason of this problem can be found in org.jbpm.pvm.internal.id.DatabaseIdComposer.createId(...) which is called in org.jbpm.pvm.internal.model.ExecutionImpl.save() to initialize ExecutionImpl.dbid. Property dbid is mapped to database table JBPM4_EXECUTION (see: jbpm.execution.hbm.xml). As you can see in sql-files in ${jbpm.home}/src/db/create, the database-field-datatype of property DBID_ is a kind og integer. But DatabaseIdComposer.createId(...) produces String ... 
Workaround (worked fine for me):
Use integer-values as "key" in you processdefinition.
e.g. use <process description="myDescription" key="123" name="myProcess" version="0" xmlns="http://jbpm.org/4.3/jpdl">
instead of <process description="myDescription" key="anyString" name="myProcess" version="0" xmlns="http://jbpm.org/4.3/jpdl">

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/521787#521787