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

DBRE fails with messge Field already defined in ITD when column name is the same as a table name

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Complete
    • Affects Version/s: None
    • Fix Version/s: 1.2.2.RELEASE
    • Component/s: None
    • Labels:
    • Environment:
      This behaves differently when running on Windows or Linux due to the way that MySQL handles the case sensitive of table names

      Description

      For 'persistence setup --provider ECLIPSELINK --database MYSQL '

      If you have a column studyStatus in table A, and a table named StudyStatus then

      Then the command 'database reverse engineer --schema myschema' will fail with the message:
      Field 'studyStatus' already defined in ITD

      A work around is to rename the column to something else.

      This will not fail when running in a Windows environment (presumably because the table names are returned as all lower case in Windows)

        Attachments

          Activity

            People

            Assignee:
            stewarta Alan Stewart
            Reporter:
            iwright Ian Wright
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: