[CONNECTORS-114] Derby seems too unstable in multithreaded situations to be a good database for ManifoldCF, so try to add support for HSQLDB

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: ManifoldCF 0.3
• Component/s: Framework core
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 09/Oct/10 11:23
• Updated: 03/Jun/11 14:31
• Resolved: 03/Jun/11 14:31

Description

Derby seems to have multiple problems:
(1) It has internal deadlocks, which even if caught cause poor performance due to stalling (CONNECTORS-111);
(2) It has no support for certain SQL constructs (CONNECTORS-109 and CONNECTORS-110);
(3) It locks up entirely for some people (CONNECTORS-100).

HSQLDB has been recommended as another potential embedded database that might work better.