Bug 778011 (SOA-538) - Extend /jboss-as/tools/schema tool, add multiple config files to support DB2 (tier2 database)
Summary: Extend /jboss-as/tools/schema tool, add multiple config files to support DB2 ...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-538
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Tooling
Version: 4.2 CP01
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: nwallace
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-04-30 17:49 UTC by Len DiMaggio
Modified: 2010-02-08 17:17 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 778012 (view as bug list)
Environment:
Last Closed: 2010-02-08 17:17:30 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 778004 0 high ASSIGNED jBPM datasource should be XA datasource 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 778373 0 high CLOSED jBPM datasource should be XA datasource 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-538 0 None Closed Extend /jboss-as/tools/schema tool, add multiple config files to support DB2 (tier2 database) 2012-02-05 15:00:21 UTC

Internal Links: 778004 778373

Description Len DiMaggio 2008-04-30 17:49:14 UTC 
Date of First Response: 2008-05-09 09:27:34
project_key: SOA

In order to support DB2 -  a tier2 database for 4.2.0 release - we'll need to extend the /jboss-as/tools/schema tool - and add other server config files
Comment 1 Len DiMaggio 2008-05-06 20:23:49 UTC 
We will actually need to create multiple config files (and add the connector jars to the distribution) to support DB2.

For example - in CP01 - these files exist for MySQL:

[ldimaggi@ldimaggi jboss-soa-p-standalone.4.2.0]$ find . -name "*mysql*" -print | grep -v doc
./jbpm-jpdl/db/jbpm.jpdl.mysql.sql
./jboss-as/server/default/deploy/jbossesb.esb/message-store-sql/mysql
./jboss-as/server/default/deploy/jbossesb.sar/juddi-sql/mysql
./jboss-as/server/default/deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.mysql.sql
./jboss-as/tools/schema/common/mysql-persistence-service.xml
./jboss-as/tools/schema/mysql
./jboss-as/tools/schema/mysql/template/mysql-ds.xml
./jboss-as/tools/schema/mysql/template/mysql-persistence-service.xml
./jboss-as/tools/schema/mysql/driver/mysql-connector-java-5.0.7-bin.jar

And these for DB2:

[ldimaggi@ldimaggi jboss-soa-p-standalone.4.2.0]$ find . -name "*db2*" -print | grep -v doc
./jbpm-jpdl/db/jbpm.jpdl.db2.sql
./jboss-as/server/default/deploy/jbossesb.sar/juddi-sql/db2
./jboss-as/server/default/deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.db2.sql
Comment 2 Len DiMaggio 2008-05-07 13:17:24 UTC 
 Changed JIRA type from feature request to bug - DB2 is tier2 supported DB.
Comment 3 Len DiMaggio 2008-05-07 13:22:58 UTC 
Link: Added: This issue is related to SOA-531
Comment 5 Aleksandar Kostadinov 2008-05-24 10:11:04 UTC 
I've committed https://svn.corp.jboss.com/repos/soa/trunk/qa/dbinstall/db2/readme if that can help
Comment 6 Mike Brock 2008-07-09 23:37:36 UTC 
Link: Added: This issue depends JBMESSAGING-1048
Comment 7 nwallace 2008-09-25 19:39:54 UTC 
Link: Added: This issue is related to SOA-856
Comment 8 nwallace 2009-11-24 15:26:49 UTC 
I've tested standalone and embedded with helloworld and bpm_orchestration2 and they're ok.
Comment 9 Len DiMaggio 2010-02-08 17:17:30 UTC 
Verified in SOA-P 5.0 ER8.
Note You need to log in before you can comment on or make changes to this bug.