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

Document PostgreSQL schema naming issue

    XMLWordPrintable

    Details

      Description

      For DBRE documentation, it may be a good idea to expand the 'Note' in section 9.3, first bullet.

      Here, we have a note on schema issues for databases we reverse engineer. In PostgreSQL, schema names that are all upper case will cause Roo DBRE to spit out the error: "Schema 'ABC' does not exist or does not have any tables. Note that the schema names of some databases are case-sensitive"

      Recommend either adding a blurb to the docs or modifying the Roo exception output to indicate PostgreSQL upper case schema names are not supported. This seems to be an issue in other software also so I'm confident it's not a Roo issue:

      Hibernate reverse engineering: https://hibernate.onjira.com/browse/HBX-1000
      Connecting JIRA to PostgreSQL:
      http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+PostgreSQL#ConnectingJIRAtoPostgreSQL-42ConnectingJIRAtoPostgreSQLManually

        Attachments

          Activity

            People

            Assignee:
            stewarta Alan Stewart
            Reporter:
            jmarkham Jeff Markham
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0.5d
                0.5d
                Remaining:
                Remaining Estimate - 0.5d
                0.5d
                Logged:
                Time Spent - Not Specified
                Not Specified