Bug 778012

Summary:	Extend /jboss-as/tools/schema tool, add multiple config files to support DB2 (tier2 database)
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Len DiMaggio <ldimaggi>
Component:	Tooling	Assignee:	nwallace <nwallace>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.0
Target Milestone:	---
Target Release:	5.0.0 GA
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-538
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:	SOA-538	Environment:
Last Closed:	2010-02-08 17:17:30 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Len DiMaggio 2008-04-30 17:49:14 UTC

++ This bug is a clone of bug 778011 ++

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.