Bug 778586 (SOA-1060)

Summary:	Add setup script to support JBPM on DB2
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Jim Ma <ema>
Component:	Build Process	Assignee:	Jim Ma <ema>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3 GA
Target Milestone:	---
Target Release:	4.3 CP01
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-1060
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-03-16 00:32:07 UTC	Type:	Task
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:
Bug Blocks:	778120

Description Jim Ma 2008-12-03 06:28:06 UTC

Date of First Response: 2009-01-14 09:14:41
project_key: SOA

From http://www.jboss.org/community/docs/DOC-11149, the DB2 tables for JBPM need 32k pagesize table space. Look at if we can create setup.sql for it .

Comment 1 Jim Ma 2008-12-03 06:29:48 UTC

Link: Added: This issue is a dependency of SOA-630

Comment 2 Jim Ma 2008-12-09 02:48:41 UTC

Fixed in revision r2422

Comment 3 Julian Coleman 2009-01-14 14:14:41 UTC

Added to the 4.3 branch in revision 2540 of:
  build-tools/resource/schema/tooltool/esb/build.xml
  build-tools/resource/schema/tooltool/esb/db2/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/db2/template/db2-ds.xml
  build-tools/resource/schema/tooltool/esb/db2/template/setup.sql
  build-tools/resource/schema/tooltool/esb/mssql/driver/sqljdbc.jar
  build-tools/resource/schema/tooltool/esb/mssql/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/mssql/template/initial.sql
  build-tools/resource/schema/tooltool/esb/mssql/template/mssql-ds.xml
  build-tools/resource/schema/tooltool/esb/mssql/template/setup.sql
  build-tools/resource/schema/tooltool/esb/mssql/template/uuid-jboss-service.xml
  build-tools/resource/schema/tooltool/esb/mysql/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/oracle10g/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/oracle9i/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/oracle9i/template/setup.sql
  build-tools/resource/schema/tooltool/esb/postgresql/template/antsql.xml
  build-tools/resource/schema/tooltool/esb/sybase/template/antsql.xml

Commit message:
  Pull up revisions 2421, 2442, 2443 and 2476 from trunk for JIRA's SOA-541,
  SOA-630 and SOA-630.
  
    r2421
    (SOA-1060)Added DB2 setup script; (SOA-630)Extended /tools/schema to support DB2
  
    r2442
    add MYSQL support: SOA-541
  
    r2443
    support mssql
  
    r2476
    add db setup scripts for mssql

Comment 4 Len DiMaggio 2009-03-16 00:30:36 UTC

Link: Added: This issue is related to SOA-1204

Comment 5 Len DiMaggio 2009-03-16 00:32:07 UTC

Verified in 4,3 CP01 CR2 and CR4

See linked issue:   https://jira.jboss.org/jira/browse/SOA-1204   for related issue with the tools/schema/db2/template/setup.sql script