Bug 778976 (SOA-1404)

Summary: Schema tool does not reflect new management console oracle dir layout
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Jiri Pechanec <jpechane>
Component: ToolingAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 4.3 CP02Keywords: Regression, TestBlocker
Target Milestone: ---   
Target Release: 4.3 CP02   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1404
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-08-18 11:30:20 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 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