Spring Roo
  1. Spring Roo
  2. ROO-1502

Can not create Entity with Reserved SQL keyword class name even when --table is specified

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Invalid
    • Affects Version/s: 1.0.2.RELEASE, 1.1.0.M1, 1.1.0.M2, 1.1.0.M3
    • Fix Version/s: 1.1.0.RC1
    • Component/s: PERSISTENCE
    • Labels:
      None

      Description

      entity --class order.Order --table orders
      results in
      Reserved SQL keyword 'Order' is not permitted as simple type name

      entity --class user.User --table users
      results in
      Reserved SQL keyword 'User' is not permitted as simple type name

      The preceding errors are incorrect because a table name that is not a reserved SQL keyword is being specified.

      Reserved SQL keyword 'Order' is not permitted as simple type name
      java.lang.IllegalStateException: Reserved SQL keyword 'Order' is not permitted as simple type name
          at org.springframework.roo.model.ReservedWords.verifyReservedSqlKeywordsNotPresent(ReservedWords.java:54)
          at org.springframework.roo.model.ReservedWords.verifyReservedWordsNotPresent(ReservedWords.java:29)
          at org.springframework.roo.classpath.operations.ClasspathCommands.newPersistenceClassJpa(ClasspathCommands.java:228)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at org.springframework.roo.support.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:191)
          at org.springframework.roo.process.manager.ProcessManagerHostedExecutionStrategy$1.callback(ProcessManagerHostedExecutionStrategy.java:49)
          at org.springframework.roo.process.manager.internal.DefaultProcessManager.doTransactionally(DefaultProcessManager.java:177)
          at org.springframework.roo.process.manager.internal.DefaultProcessManager.execute(DefaultProcessManager.java:140)
          at org.springframework.roo.process.manager.ProcessManagerHostedExecutionStrategy.execute(ProcessManagerHostedExecutionStrategy.java:47)
          at org.springframework.roo.shell.AbstractShell.executeCommand(AbstractShell.java:161)
          at org.springframework.roo.shell.jline.JLineShell.promptLoop(JLineShell.java:325)
          at org.springframework.roo.shell.jline.JLineShell.run(JLineShell.java:118)
          at java.lang.Thread.run(Thread.java:637)
      
      

        Activity

        Hide
        Alan Stewart added a comment -

        There is an option on the entity command to allow reserved words - try using --permitReservedWords

        Show
        Alan Stewart added a comment - There is an option on the entity command to allow reserved words - try using --permitReservedWords
        Hide
        Imesh Gunaratne added a comment -

        Thanks Alan, I found the same problem while trying to generate an entity called User and your suggestion works fine.

        Show
        Imesh Gunaratne added a comment - Thanks Alan, I found the same problem while trying to generate an entity called User and your suggestion works fine.

          People

          • Assignee:
            Alan Stewart
            Reporter:
            Scott Murphy
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: