[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2765) With the introduction of the id generator sql-scripts (${jbpm.home}/install/src/db/create) were not updated

With the introduction of the id generator sql-scripts (${jbpm.home}/install/src/db/create) were not updated ----------------------------------------------------------------------------------------------------------- Key: JBPM-2765 URL: https://jira.jboss.org/browse/JBPM-2765 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: jBPM 4.3 Environment: Databases HSQLDB, MySQL, Oracle, PostgrasSql: if database tables where created using the sql-scripts in ${jbpm.home}/install/src/db/create Reporter: Jan Scherf Priority: Minor Fix For: jBPM 4.4 org.jbpm.pvm.internal.model.ExecutionImpl.save() crashs with database-error. reason: - DatabaseIdComposer.createId(...) produces datatype string - but sql-Skripts create dbid-colums whose datatype is integer __________________________________________________________________________________________ See more Details on: http://community.jboss.org/message/521822 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 of integer. But DatabaseIdComposer.createId(...) produces String ... It seems that with the introduction of the id generator these scripts were not updated.