| Summary: | schema tool does not support databases as defined in PRD/ERD | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Jiri Pechanec <jpechane> |
| Component: | Tooling | Assignee: | Julian Coleman <jcoleman> |
| Status: | CLOSED NEXTRELEASE | QA Contact: | |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 5.1.0.ER2 | Keywords: | TestBlocker |
| Target Milestone: | --- | ||
| Target Release: | 5.1.0 GA, 5.1.0.CR1 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://jira.jboss.org/jira/browse/SOA-2432 | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-02-13 05:33:27 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
Jiri Pechanec
2010-10-18 07:08:25 UTC
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. |