Bug 778010 (SOA-537)

Summary:	Extend /jboss-as/tools/schema to support Sybase (tier2 database)
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Len DiMaggio <ldimaggi>
Component:	Tooling	Assignee:	Julian Coleman <jcoleman>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.2 CP01
Target Milestone:	---
Target Release:	FUTURE
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-537
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-10-04 17:53:40 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:08 UTC

Date of First Response: 2008-07-09 19:38:45
project_key: SOA

In order to support Sybase -  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.

[ldimaggi@ldimaggi jboss-soa-p-standalone.4.2.0]$ find . -name "*sybase*" -print | grep -v doc
./jbpm-jpdl/db/jbpm.jpdl.sybase.sql
./jboss-as/server/default/deploy/jbossesb.sar/juddi-sql/sybase
./jboss-as/server/default/deploy/jbpm.esb/jbpm-sql/jbpm.jpdl.sybase.sql
./jboss-as/tools/schema/common/sybase-persistence-service.xml

In comparison - we have these files 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

We will have to at least have sample files for each DB:

 -> <database>-ds.xml (needed for DB2, Sybase, MS-SQL)
 -> message-store-sql/<database>/create_database.sql, drop_database.sql (needed for DB2, Sybase, MS-SQL)
 -> <database>-persistence-service.xml (needed for DB2)

Comment 1 Len DiMaggio 2008-05-07 13:14:38 UTC

Changed JIRA type from feature request to bug - Sybase is tier2 supported DB.

Comment 2 Len DiMaggio 2008-05-07 13:25:38 UTC

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

Comment 3 Mike Brock 2008-07-09 23:38:45 UTC

Duplicate of SOA-541

Comment 4 Len DiMaggio 2008-08-26 16:52:25 UTC

SOA-537 refers to adding Sybase support

SOA-541 is the same, but for MS-SQL

Comment 5 nwallace 2008-09-25 19:39:54 UTC

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

Comment 6 nwallace 2008-10-01 11:30:44 UTC

Emailed Julian for comments

Comment 7 nwallace 2009-11-25 04:07:49 UTC

Uncommented the sybase15 in the schema tool and tested against helloworld and bpm_orchestration2 quickstarts ok.

Comment 8 Len DiMaggio 2010-02-08 17:26:00 UTC

Changed fixed in version to 'FUTURE' as Sybase is not yet supported by SOA-P.

Comment 9 Len DiMaggio 2010-10-04 17:53:40 UTC

Support is there in the 5.1 ER2 schema tool - for when the DB is certified - future.