[jbpm-issues] [JBoss JIRA] Updated: (JBPM-2007) SQL scripts in jbpm-sql missing identity table creation for most DB's.
[
https://jira.jboss.org/jira/browse/JBPM-2007?page=com.atlassian.jira.plug...
]
Julian Coleman updated JBPM-2007:
---------------------------------
Attachment: jbpm-sql-diffs
Attached are the diffs from a SOA distribution with jBPM 3.2.2 (-) and
the SOA 4.3.0 CP01 candidate with jBPM 3.2.4 (+). Note that, as well
as the changes from varchar(4000) to clob(255), most of the scripts
are missing the lines:
create table JBPM_ID_GROUP
create table JBPM_ID_MEMBERSHIP
create table JBPM_ID_PERMISSIONS
create table JBPM_ID_USER
It looks like the lines from the 3.2.2 version can be added directly to the
3.2.4 versions (modules/db/src/main/resources/ddl/).
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
Fix For: jBPM-3.2.4.SP1
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira