IBM Support

JPA Tools does not generate entities from a DB2 table when any SQL word is used as table name

Troubleshooting


Problem

JPA Tools is not able to generate entities from a DB2 table whose name contains SQL words (like TABLE, USER, RESULT, etc.), and when there's a Foreign Key Constraint associated to that table.

Symptom

Steps to reproduce:

  1. There is a table named with any of the DB2 Reserved words (like: TABLE, RESULT, USER, etc.)
  2. The table has a Foreign Key constraint related to that table
  3. After clicking Finish in the Generate Custom Entities wizard, the error message is displayed.

[{"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Tooling","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF033","label":"Windows"}],"Version":"9.0;9.0.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
Rational Application Developer for WebSphere Software

Software version:
9.0, 9.0.1

Operating system(s):
Linux, OS X, Windows

Document number:
500611

Modified date:
16 June 2018

UID

swg21654523

Manage My Notification Subscriptions