Thanks for your answer. BTW. There's ongoing progress in ODE for migrating from Derby to H2 for embedded database, particularly due to lacking support for MVCC, which raises deadlocks in concurrent scenarios in ODE (https://issues.apache.org/jira/browse/ODE-666). I'm not actually happy of that, because H2 is not so mature project and I'm afraid we could step into precipice. But are going to support MVCC in some future in Derby?
BTW 2. Here's a H2 <-> Derby comparison, which may be used for future improvements of Derby: http://www.h2database.com/html/features.html#comparison. 2009/10/8 Knut Anders Hatlen <[email protected]>: > Rafal Rusin <[email protected]> writes: > >> Hello, >> >> I'm a committer from Apache ODE. We had a hang on derby 10.5.3.0 while >> we used such prepared statement. >> We use JTA environment with Tranql and Geronimo embedded, but I think >> it's not related to this problem. >> >> Here's a code to reproduce this hang: >> > [...] >> >> This statement doesn't make much sense, but we lost a lot of time >> figuring out what's going on. Alexis Midon found eventually a cause. >> >> Is there a chance of fixing it (or at least throwing error on nulls)? > > This bug was actually fixed just a couple of weeks ago, see > https://issues.apache.org/jira/browse/DERBY-4376. I tried the code you > posted, and it does reproduce the hang with Derby 10.5.3.0, but it does > not hang when I test it with head of trunk. The fix is also available on > the 10.5 branch. > >> FYI, here's an entry in ODE jira: >> https://issues.apache.org/jira/browse/ODE-671 > > I've posted a link to DERBY-4376 on that issue. > > -- > Knut Anders > Regards, -- Rafał Rusin http://www.touk.pl http://top.touk.pl http://people.apache.org/~rr/
