Bug 779611 (SOA-1981) - Schema tool extensions required for Oracle RAC
Summary: Schema tool extensions required for Oracle RAC
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1981
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Tooling
Version: 5.0.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.0.2
Assignee: Zuzana Zoubkova
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-03-08 15:09 UTC by Julian Coleman
Modified: 2010-06-07 03:46 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-05-31 10:32:23 UTC
Type: Task

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 779600 0 urgent CLOSED Extend schema tool to support tier2 databases 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1981 0 None None None Never

Internal Links: 779600

Description Julian Coleman 2010-03-08 15:09:24 UTC 
Affects: Compatibility/Configuration
Date of First Response: 2010-05-14 10:49:43
project_key: SOA

Oracle RAC requires a DB URL of the form:

  jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=host1.some.domain)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2.some.domain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=${db})))

where there are multiple instances of (HOST=)(PORT=) pairs.

The schema tool needs to be expanded to handle this.
Comment 1 Julian Coleman 2010-03-08 15:16:27 UTC 
Link: Added: This issue is related to SOA-1970
Comment 2 Zuzana Zoubkova 2010-05-14 14:49:43 UTC 
Extension committed in revision 5612.
Comment 3 Jiri Pechanec 2010-05-31 10:32:23 UTC 
Verified in CR1
Comment 4 David Le Sage 2010-06-07 02:02:07 UTC 
This is the draft text for the Release Notes:


https://jira.jboss.org/jira/browse/SOA-1970

    Previously, the Schema tool would only support a limited number of databases. It has now been
    enhanced and, as a result, supports these second-tier databases:

    • MySQL 5.0
    • PostgreSQL 8.2.4
    • Microsoft SQL Server 2008
    • Oracle 11g
Comment 5 David Le Sage 2010-06-07 03:46:58 UTC 
Sorry, the note above was for SOA 1971.  Draft for SOA 1981 reads:



https://jira.jboss.org/jira/browse/SOA-1981

    The Oracle RAC required URLs to be presented in a specific format, which the Schema tool was unable to handle.
    Extensions have been added to the tool to provide compatibility with this format.
Note You need to log in before you can comment on or make changes to this bug.