JdbcStorage update

"John V. Sichi" <[email protected]> Sat, 27 Nov 2004 03:21:39 -0800
Newsgroups gmane.comp.java.netbeans.modules.mdr.devel
Message-ID <[email protected]>
JdbcStorage has been broken for a while due to build changes and changes 
to the MDRCache class which JdbcStorage borrows from BTreeStorage.  I 
just checked in fixes so it should build and run again.  I also fixed 
some other bugs I found in my code.

I'm finding that JdbcStorage with the latest release of HSQLDB running 
in-process appears to be even a little faster than BTree storage.  This 
is just from casual observation with small data sets.  But it raises the 
question:  instead of continuing to put effort into the BTree library 
(e.g. enhancing with java.nio), why not replace it with an embedded Java 
database instead?  HSQLDB uses java.nio already, and supports both 
memory-based and disk-based tables.  Its license recently changed to 
new-BSD (the old advertising clause was removed) which is compatible 
with just about anything.  They claim performance has improved a lot, 
and it has crash recovery.

Or if something more robust is required, there's Derby nee Cloudscape. 
I haven't tried it yet.

JVS