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)
Changed JIRA type from feature request to bug - Sybase is tier2 supported DB.
Link: Added: This issue is related to SOA-531
Duplicate of SOA-541
SOA-537 refers to adding Sybase support SOA-541 is the same, but for MS-SQL
Link: Added: This issue is related to SOA-856
Emailed Julian for comments
Uncommented the sybase15 in the schema tool and tested against helloworld and bpm_orchestration2 quickstarts ok.
Changed fixed in version to 'FUTURE' as Sybase is not yet supported by SOA-P.
Support is there in the 5.1 ER2 schema tool - for when the DB is certified - future.