Hide Forgot
++ 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
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
Changed JIRA type from feature request to bug - DB2 is tier2 supported DB.
Link: Added: This issue is related to SOA-531
I've committed https://svn.corp.jboss.com/repos/soa/trunk/qa/dbinstall/db2/readme if that can help
Link: Added: This issue depends JBMESSAGING-1048
Link: Added: This issue is related to SOA-856
I've tested standalone and embedded with helloworld and bpm_orchestration2 and they're ok.
Verified in SOA-P 5.0 ER8.