On Sat Dec 10 16:39:50 2011, Andrus Adamchik wrote:
Could be a bug (in Derby?). Probably worth opening a bug report at
https://issues.apache.org/jira/browse/CAY ... Also would be helpful if you
could take a thread dump when the app is frozen to see what the app is doing at
this moment. IIRC we had people using CreateIfNoSchemaStrategy with Derby, so
there may be a special case causing this condition.
Andrus
On Dec 8, 2011, at 10:04 PM, Mathias Clerc wrote:
I am using an embedded Derby DB together with Cayenne
CreateIfNoSchemaStrategy feature.
If I start with an empty DB, on the first query the DB is created but
at the moment of actually running the query, Derby freezes waiting for
a lock.
If I use JDBC to manually create the table before the first connection
(manually injecting a copy/paste of the debug output of cayenne), then
the query works perfectly.
Any idea ?
I also recommend searching the Derby Jira database for "deadlock".
There are a number of deadlock issues in recent Derby versions.
Although I've never seen it in the situation the original poster
reported, I've seen other similar deadlocks when trying to alter the
schema of a Derby database.
--
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A