adfemg
  1. adfemg
  2. ADFEMG-146

JDeveloper 11.1.1.7.0 generates duplicate entity associations if associations are put in a subdirectory of the EO

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Cannot Reproduce
    • Labels:
      None
    • Environment:

      JDev 11.1.1.7.0 (tested in 11.1.1.6.0 too);
      Win 7x64;
      JDK 1.6.0_45 64bit

      Description

      Original OTN 'space' entry: https://forums.oracle.com/message/11090681#11090681

      Steps to reproduce:
      0) check that the global preferences for the 'business components'>'Packages'>'Association' is set to e.g. 'entity.association' (as defined in ADFng1-
      03012])
      1) create a fresh ADF Model Project and use 'Business Component From Table' wizard to create the e.g. based on the HR schema
      2) use DEPARTMENT and EMPLOYEE tables and create EO and VO from the tables and setup an application module holding the VO in the data model
      3) add a column in the HR DB schema to the EMPLOYEES table, e.g. DUMMY type varchar2(255)
      4) select the Employees EO, right click and select 'Synchronize with DB'
      5) do the sync to get the new column into the Employee EO
      6) check the association folder where you now find duplicate associations for the FK attributes, e.g. EmpDeptFkAssoc and EmpDeptFk1Assoc

      The duplicated associations are equal beside of their name. Attached zip contains images!

      Workaround: either delete the duplicate associations or change the package the associations are generate into to the same as the entity objects are generated to.

        Activity

        Hide
        chriscmuir added a comment -

        Ah, this bugs back, I meant to log this way back before I joined Oracle. Thanks for logging Timo. I'll get onto logging this internally as a bug soon.

        CM.

        Show
        chriscmuir added a comment - Ah, this bugs back, I meant to log this way back before I joined Oracle. Thanks for logging Timo. I'll get onto logging this internally as a bug soon. CM.
        Hide
        chriscmuir added a comment -

        Reproduced bug against 11.1.1.7.0 and lodged bug 17160748. Note the bug isn't reproducible in 12.1.2.0.0. However I encountered a separate problem where an exception "INTERNAL ERROR : ORPHANED CONSTRAINT" is thrown in the console. I've lodged that bug separately as bug 17160740.

        As the original bug can't be reproduced in 12.1.2.0.0 and there is a workaround, I suggest development wont pursue a fix for that bug unless pressed by a customer. If a customer sees either bug as a necessary problem to be fixed in the 11gR1 branch or 12c branches respectively, they should lodge an SR to progress further.

        Thanks for taking the time to lodge this.

        CM.

        Show
        chriscmuir added a comment - Reproduced bug against 11.1.1.7.0 and lodged bug 17160748. Note the bug isn't reproducible in 12.1.2.0.0. However I encountered a separate problem where an exception "INTERNAL ERROR : ORPHANED CONSTRAINT" is thrown in the console. I've lodged that bug separately as bug 17160740. As the original bug can't be reproduced in 12.1.2.0.0 and there is a workaround, I suggest development wont pursue a fix for that bug unless pressed by a customer. If a customer sees either bug as a necessary problem to be fixed in the 11gR1 branch or 12c branches respectively, they should lodge an SR to progress further. Thanks for taking the time to lodge this. CM.
        Hide
        Timo_Hahn added a comment -

        Chirs, thank you for the follow up on this. I verified that this can't be reproduced in 12.1.2.0.0.
        If you like we can close the issue here.

        Timo

        Show
        Timo_Hahn added a comment - Chirs, thank you for the follow up on this. I verified that this can't be reproduced in 12.1.2.0.0. If you like we can close the issue here. Timo
        Hide
        chriscmuir added a comment -

        Issue closed, thanks for lodging.

        CM.

        Show
        chriscmuir added a comment - Issue closed, thanks for lodging. CM.

          People

          • Assignee:
            Unassigned
            Reporter:
            Timo_Hahn
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: