[NXP-3784] WebWidgets cannot create its JPA table with Oracle - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

Content model Change
Upgrade notes:

Hide

To keep existing webwidgets, the tables NXP_WEBWIDGETS_DATA and NXP_WEBWIDGETS_WIDGET will have to be renamed to NXP_WEBW_DATA and NXP_WEBW_WIDG, and their columns renamed as well (no more prefix, and the WIDGET_ORDER column is renamed to ORD (because ORDER would be a reserved word)).

Show
To keep existing webwidgets, the tables NXP_WEBWIDGETS_DATA and NXP_WEBWIDGETS_WIDGET will have to be renamed to NXP_WEBW_DATA and NXP_WEBW_WIDG, and their columns renamed as well (no more prefix, and the WIDGET_ORDER column is renamed to ORD (because ORDER would be a reserved word)).

When initializing theme's webwidgets table with Oracle, an error is thrown:

ORA-00972: identifier is too long
This occurs because of NXP_WEBWIDGETS_WIDGET_PREFERENCES and NXP_WEBWIDGETS_WIDGET_WIDGET_ID for instance.