Bug 778976 (SOA-1404) - Schema tool does not reflect new management console oracle dir layout
Summary: Schema tool does not reflect new management console oracle dir layout
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1404
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Tooling
Version: 4.3 CP02
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 4.3 CP02
Assignee: Julian Coleman
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-07-07 08:43 UTC by Jiri Pechanec
Modified: 2009-08-18 11:30 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-08-18 11:30:20 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 778002 0 medium CLOSED WARNING on OracleDialect used with Management console 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1404 0 None None None Never

Internal Links: 778002

Description Jiri Pechanec 2009-07-07 08:43:39 UTC
Date of First Response: 2009-07-08 07:46:46
project_key: SOA

The management console now uses new dir layout
[jpechane@dhcp-0-121 jboss-as]$ ls /home/jpechane/releases/43CP02IR2AS/jboss-as/tools/console/management-esb/src/main/resources/
hsqldb  jbossesbmanagement-service.xml  mysql  oracle  oracle10g  oracle9i  postgresql

Note oracle10g  oracle9i 

The old layout was
hsqldb  jbossesbmanagement-service.xml  mysql  oracle  postgresql

Note oracle

The schema tool build.xml contains these lines

        <!--
            If either oracle9i or oracle10g is selected, the target database
            should still be "oracle"
        -->
        <condition property="target.db" value="oracle">
            <or>
                <equals arg1="${source.dir}" arg2="oracle9i"/>
                <equals arg1="${source.dir}" arg2="oracle10g"/>
            </or>
        </condition>
        <!-- otherwise the target db is just the same as the dirname -->
        <property name="target.db" value="${source.dir}"/>

This has to be disabled for management console

Comment 1 Jiri Pechanec 2009-07-07 08:51:26 UTC
Same issue is for dir jboss-as/tools/console/management/src/main/resources/

Comment 2 Jiri Pechanec 2009-07-07 09:04:04 UTC
The overlay system is broken as well, there is yet another dir that contains SOA-P specific files

ls tools/console/management-esb/src/main/resources/oracle/*
tools/console/management-esb/src/main/resources/oracle/management-ds.xml  tools/console/management-esb/src/main/resources/oracle/upgrade_database.sql

Comment 3 Julian Coleman 2009-07-07 10:45:15 UTC
Link: Added: This issue related SOA-529


Comment 4 Julian Coleman 2009-07-08 11:46:46 UTC
Fixed with revision 3256 (4.3 branch) of:
  resource/schema/tool/esb/build.xml
  builders/eap/resources/management.esb/tools/src/main/resources/oracle/upgrade_database.sql
  builders/eap/resources/management.esb/tools/src/main/resources/oracle9i/upgrade_database.sql
  builders/eap/resources/management.esb/tools/src/main/resources/oracle10g/upgrade_database.sql

Commit message:
  JIRA SOA-1404

  Handle oracle to oracle9i and oracle10g change in ESB management console.

Tested by pmacik.

Comment 5 Jiri Pechanec 2009-08-18 11:30:20 UTC
Verified in CR2


Note You need to log in before you can comment on or make changes to this bug.