[ https://issues.apache.org/jira/browse/CONNECTORS-114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12920227#action_12920227 ]
Karl Wright commented on CONNECTORS-114: ---------------------------------------- Support added and checked in. However, when I try to use hsqldb for an actual crawl, in less than 10 seconds I wind up with a java-level thread deadlock. I've posted the thread dump to connectors-dev. All the locks seem to be deep inside hsqldb, FWIW, which leads me to believe that perhaps hsqldb is even less stable than Derby in a multithread environment. > Derby seems too unstable in multithreaded situations to be a good database > for ManifoldCF, so try to add support for HSQLDB > --------------------------------------------------------------------------------------------------------------------------- > > Key: CONNECTORS-114 > URL: https://issues.apache.org/jira/browse/CONNECTORS-114 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Reporter: Karl Wright > > 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. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.