Bug 778586 (SOA-1060) - Add setup script to support JBPM on DB2
Summary: Add setup script to support JBPM on DB2
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1060
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Build Process
Version: 4.3 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.3 CP01
Assignee: Jim Ma
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks: SOA-630
TreeView+ depends on / blocked
 
Reported: 2008-12-03 06:28 UTC by Jim Ma
Modified: 2009-03-16 00:32 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2009-03-16 00:32:07 UTC
Type: Task
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 778747 0 high CLOSED schema tool - DB2 setup.sql script includes commands that require SYSCTRL or SYSADM authority 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1060 0 None None None Never

Internal Links: 778747

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
Note You need to log in before you can comment on or make changes to this bug.