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

["Karl Wright (JIRA)" <ji...@apache.org>]

    [ 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.