[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2007) SQL scripts in jbpm-sql missing identity table creation for most DB's.

SQL scripts in jbpm-sql missing identity table creation for most DB's. ---------------------------------------------------------------------- Key: JBPM-2007 URL: https://jira.jboss.org/jira/browse/JBPM-2007 Project: JBoss jBPM Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: jBPM 3.2.4 GA Environment: SOA platform 4.3.0 GA CP01 (CR1) Reporter: Julian Coleman Priority: Critical Attachments: jbpm-sql-diffs See SOA-1157 - when starting the SOA server for the second and subsequent times, the scripts attempt to recreate the DB, which fails, as the DB has already been created. The script is the ESB jbpm-service.xml script and it checks the existance of the JBPM_ID_USER table to see if the databases have already been created. In the (generated at build time) jbpm-sql/*sql scipts from 3.2.2, every DB contains: create tabe JBPM_ID_* lines, but these are missing from the source in 3.2.4.