SQL reserved keywords

If an abstract field or bean name for a container managed persistence (CMP) entity beans uses a SQL reserved keyword, the top-down mapping adds a numeric suffix to the column name when generating the data definition language file (Table.ddl). This is to avoid SQL command conflicts when SQL reserved words are used as the column name. The numeric suffix is added when you run ejbdeploy command to generate deployment code for container managed persistence (CMP) entity beans.

Each of the database back end supported by the ejbdeploy command have their own list of SQL reserved keywords. Select one of the following links to see the set of SQL reserved keywords for a particular database back-end vendor:


Feedback