Search code examples
sqlescapingspring-rooreserved-words

Issue with SQL reserved keyword when trying to generate Spring Roo Data On Demand

I am trying to generate a Data On Demand class for one of my entities whose class name is Member. However it seems that Member is a reserved SQL keyword.

So when I run the following command in the Roo shell:

dod --entity ~.domain.Member

Roo complains that Member is a reserved keyword with the following message:

Reserved SQL keyword 'Member' is not permitted as simple type name

Does Roo allow for a way to escape the name of my entity? If so how?

If no, how can I circumvent this issue?

Solution

  • Someone from the Springsource team replied to me about this issue. Here is the reply:

    The dod command also allows the --permitReservedWords option to overcome your issue.

    Hope it can help someone else.