[JS2-431] Remove PropertyManager for Preferences

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-FINAL
• Fix Version/s: 2.0-FINAL
• Component/s: Portlet Entities and Preferences
• Assignee: David LeStrat
• Reporter: David LeStrat
• Created: 27/Nov/05 05:46
• Updated: 27/Nov/05 06:14
• Resolved: 27/Nov/05 06:14

Description

Remove the PropertyManager and PropertyKey from the Preferences implementation. This simplifies the implementation a bit. The PropertyManager was not used and was left as a configurable value of the PreferencesProvider. As a result of this change, the configurable flag has been removed.

The database schema has also be changed to reflect the removal of PropertyManager:

• The PREFS_NODE_PROPERTY_KEY table has been removed.
• The PREFS_PROPERTY_KEY table has been removed.
• The PREFS_PROPERTY_VALUE table has been changed. The following columns have been removed:

• PROPERTY_KEY_ID INTEGER,
• BOOLEAN_VALUE INTEGER,
• DATETIME_VALUE TIMESTAMP,
• LONG_VALUE INTEGER,
• DOUBLE_VALUE DOUBLE,
• TEXT_VALUE VARCHAR(254)
  The following columns have been added:
• PROPERTY_NAME VARCHAR(100),
• PROPERTY_VALUE VARCHAR(254)

The foreign key FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) on PREFS_PROPERTY_VALUE has not been added. It still causes foreign key violations with OJB 1.0.3 for cascade deletes.