[ https://issues.apache.org/jira/browse/TOMEE-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Svetlin Zarev updated TOMEE-2062: --------------------------------- Issue Type: Improvement (was: Bug) > HSQLDB Deadlock > --------------- > > Key: TOMEE-2062 > URL: https://issues.apache.org/jira/browse/TOMEE-2062 > Project: TomEE > Issue Type: Improvement > Reporter: Svetlin Zarev > Priority: Minor > > I was running tests with eclipselink on my vanilla tomee when it just froze > during one of the tests. After a little bit of debugging and research it > turned out to be a well known issue with HSQLDB: [1] > {code} > The default transaction model is LOCKS which locks a table that is modified > until the transaction is committed. You can use the MVCC model instead, which > allows other sessions to read from the table and to modify rows that have not > been modified. > {code} > The solution as stated in the SO answer is to add ;hsqldb.tx=mvcc to the > hsqldb connection string. IMO it would make sense add this to the default > connection string specified in tomee-webapp's service-jar.xml, so it becomes: > {code} > <ServiceProvider id="Default JDBC Database" > parent="org.apache.openejb:Default JDBC Database"> > JdbcUrl=jdbc:hsqldb:file:data/hsqldb/hsqldb;hsqldb.tx=mvcc > </ServiceProvider> > <ServiceProvider id="Default Unmanaged JDBC Database" > parent="org.apache.openejb:Default Unmanaged JDBC Database"> > JdbcUrl=jdbc:hsqldb:file:data/hsqldb/hsqldb;hsqldb.tx=mvcc > </ServiceProvider> > {code} > [1] https://stackoverflow.com/a/16109062/2588800 -- This message was sent by Atlassian JIRA (v6.4.14#64029)