Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-3513

Getting Relationship error when doing DBRE for existing schema in Oracle

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.2.3.RELEASE
    • Fix Version/s: None
    • Component/s: @ ROO SHELL
    • Labels:
    • Environment:
      Windows

      Description

      I have checked with DBA team and there is no database relationship issue in my existing schema.I also did some research on same relationship issue and found there is still some issue in Spring ROO release ,even though roo unable to create simple relationship (one- to- one /PK- FK) between two tables using Database reverse engineering command(DBre).

      Steps
      =====

      Created two database tables – T1-table1 and T2- table2
      Create foreign key relationship between these two tables. [PK(T1) is FK (T2)]
      Create new ROO project
      Run DBre commands for table T2- database reverse engineer --schema schema name --includeTables table2
      Roo DBre command created all artifacts for table T2.
      Run DBre commands for table T1- database reverse engineer -schema schema name-includeTables table1
      Getting roo exception [Foreign key table for foreign key 'FK_table1' in table 'table1' does not exist. One-to-one relationship not created]
      I had reverse the order of executing DBre commands for tables i.e. first T1 & T2 but still getting exception for table T1.

      Also Attempted to create one-to-many mapped-by field – but type for table – could not be found or is not database managed (not annotated with @RooDbManaged)

        Attachments

        1. sample.roo
          0.8 kB
        2. tables.sql
          0.8 kB

          Activity

            People

            • Assignee:
              jcgarcia Juan Carlos García del Canto
              Reporter:
              sendilk Sendil Krishnan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: