Bug 1076696 - Schema problems with DDL scripts
Summary: Schema problems with DDL scripts
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: BAM
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER1
: 6.0.2
Assignee: Maciej Swiderski
QA Contact: Jan Hrcek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-03-14 20:45 UTC by jbride@redhat.com
Modified: 2014-08-06 19:51 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2014-08-06 19:51:18 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)

Description jbride@redhat.com 2014-03-14 20:45:30 UTC 
OPTLOCK fields are missing for the BAMTaskSummary and TaskEvent tables in the mysql and postgresql DDL scripts included in the BPMS6.0.0GA installer.  The following commands correct the problems (mysql specific):

alter table BAMTaskSummary add column OPTLOCK integer;
alter table TaskEvent add column OPTLOCK integer;

jeff
Comment 4 Maciej Swiderski 2014-03-20 12:12:56 UTC 
DDL scripts regenerated

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/43b691033403bf91e57e09fffc06b2e88df35445

6.0.x:
https://github.com/droolsjbpm/jbpm/commit/2fa9f8a2bf13eee6d56f1c3cc17d283ea3179e90
Comment 5 Jan Hrcek 2014-05-05 09:01:31 UTC 
Ok, verified with BPMS 6.0.2 ER2 that updated scripts with missing fields added are present in jboss-bpms-brms-6.0.2.GA-redhat-2-supplementary-tools
Note You need to log in before you can comment on or make changes to this bug.