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

DBRE MSSQL database with space in table name

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Complete
    • 1.2.0.RELEASE
    • 1.2.1.RELEASE
    • PERSISTENCE
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: