Hide Forgot
project_key: SOA Currently schema tool supports db2-97 mssql2005 mssql2008 mysql50 mysql51 oracle10g oracle11g oracle11RAC postgresql824 postgresql837 but the proper list should be db2-97 mssql2008 mysql50 mysql51 oracle11g oracle11RAC postgresql824 postgresql837 postgresql84x - verify proper version with RHEL 5.5 sybase15
Removed MS-SQL 2005 and added PostgreSQL 8.4 support in revision 7038 of: schema-tool/build.xml schema-tool/mssql2005 (deleted) schema-tool/postgresql84/config.properties (added) schema-tool/postgresql84/driver/name.properties (added) schema-tool/postgresql84/sql/ (added) schema-tool/postgresql84/template/antsql.xml (added) schema-tool/postgresql84/template/initial.sql (added) schema-tool/postgresql84/template/postgresql-ds.xml (added) schema-tool/postgresql84/template/setup.sql (added) Commit message: SOA-2432 Remove support for MS-SQL 2005. Add support for PostgreSQL 8.4.
There is no support (SQL scripts) for Sybase in the jUDDI nor in the RiftSaw components.
Link: Added: This issue related RIFTSAW-306
There is no support (SQL scripts) for Sybase in the ESB message store. The jBPM Sysbase support does not work with ASE 15.
Link: Added: This issue depends JBESB-3523
Link: Added: This issue depends JBPM-2971
jUDDI JIRA: https://issues.apache.org/jira/browse/JUDDI-424
Sybase 15 support added in revision 7086 of: build-tools/resource/schema-tool/build.xml build-tools/resource/schema-tool/sybase15/template/antsql.xml
Link: Added: This issue is related to JBPAPP-5319
Hi Julian, I checked in the sybase ddl for https://issues.apache.org/jira/browse/JUDDI-424. Is this all you need?
Hi, Kurt! That should be the only change that we need. Thanks, J
JBPAPP-5319 worked around with revision 7115 of: build-tools/builders/eap/post-patch/patch_db_persistance_conf.xml Commit message: SOA-2432/JBPAPP-5319 Patch sybase-persistence-service.xml to make it work.
Candidate for SOA 5.1.0
RiftSaw is included as a TP for SOA 5.1.0. This is not a blocker for SOA 5.1.0. Moving to future.
Release Notes Docs Status: Added: Not Yet Documented Release Notes Text: Added: Using Sybase as a backend database is not supported for the RiftSaw technical preview component.
Verified in ER9 build: [ldimaggi@ldimaggi schema]$ ll total 152 -rw-r--r-- 1 ldimaggi ldimaggi 1718 Feb 2 03:00 build.properties -rw-r--r-- 1 ldimaggi ldimaggi 32899 Feb 2 03:00 build.xml drwxr-xr-x 2 ldimaggi ldimaggi 4096 Feb 2 03:00 common drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 db2-97 -rw-r--r-- 1 ldimaggi ldimaggi 457 Feb 2 03:00 juddi-service.xml drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 mssql2008 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 mysql50 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 mysql51 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 oracle10g drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 oracle11g drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 oracle11RAC drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 postgresql824 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 postgresql837 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 postgresql84 drwxr-xr-x 4 ldimaggi ldimaggi 4096 Feb 2 03:00 sybase15 [ldimaggi@ldimaggi schema]$ ant Buildfile: build.xml execute: [groovy] JBoss SOA Platform Database Configuration Script [groovy] ------------------------------------------------ [groovy] [groovy] This script is used to configure the SOA platform and all its [groovy] constituent components against a new RDBMS. Deployment scripts [groovy] are currently available for the following databases: [groovy] DB2 9.7, MS SQL 2008, MySQL 5.0, MySQL 5.1, Oracle 10g, [groovy] Oracle 11g, Oracle 11RAC, PostgreSQL 8.2.4, PostgreSQL 8.3.7, PostgreSQL 8.4.x, [groovy] Sybase ASE 15 [groovy] [groovy] ** Warnings ** [groovy] This script may not work correctly if you have made manual [groovy] changes to the database configuration. [groovy] This script is only intended to do initial configuration. [groovy] It is not intended to be used multiple times. [groovy] [groovy] Which server configuration are you changing? [groovy] all, production, standard, web, minimal, [groovy] default [default]:
Reopening to remove the need for a release note. Will set back to Closed -> Done shortly.
Removing release note text, since this does not require a release note, but pasting here for reference: {quote}Using Sybase as a backend database is not supported for the RiftSaw technical preview component.{quote} Setting back to Closed -> Done.
Release Notes Docs Status: Removed: Not Yet Documented Added: Not Required Release Notes Text: Removed: Using Sybase as a backend database is not supported for the RiftSaw technical preview component.