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

DBRE MSSQL database with space in table name

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Complete
    • Affects Version/s: 1.2.0.RELEASE
    • Fix Version/s: 1.2.1.RELEASE
    • Component/s: PERSISTENCE
    • Labels:
      None
    • Environment:
      MS Windows 7, Java 1.6.0_30

      Description

      I have an existing MSSQL database with tables which has spaces in it. During DBRE, it will fail because it tries to create a class with space in it. See roo output snippet below. It is failing where a table is named "Common Filters"

      core roo> database reverse engineer --schema dbo
      Created core|SRC_MAIN_RESOURCES\dbre.xml
      Created core|SRC_MAIN_JAVA\hk\com\quantum
      Created core|SRC_MAIN_JAVA\hk\com\quantum\Catagories.java
      Undo create core|SRC_MAIN_JAVA\hk\com\quantum\Catagories.java
      Undo create core|SRC_MAIN_JAVA\hk\com\quantum
      Undo create core|SRC_MAIN_RESOURCES\dbre.xml
      Illegal name 'hk.com.quantum.Common filters' (illegal character)

        Attachments

        1. create_database.sql
          3 kB
        2. dbre.xml
          2 kB
        3. log.roo
          0.3 kB

          Activity

            People

            Assignee:
            stewarta Alan Stewart
            Reporter:
            lsiu Leonard Siu
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: