I think that HsqlDB is the only one that stores the data in one file.
I personally prefer Derby because it feels more robust, but I know of other people who swear by HsqlDB.
One$DB is slow in my testing and last time I checked there were some problems with transaction MVCC multi-threading stability.
I like McKoiSQL in general and the code looks good, it's GPL however, to distribute it in a non-GPL app, you need to pay a license fee.
On 16-nov-05, at 17:57, F Baube wrote:
Geert had said:SQLite is not supported since the JDBC driver is experimental. You can use any of these: HsqlDB Derby One$DB McKoiSQL They are all embedded databases [..] written in pure Java.I wonder if Rifers have any preferences or horror stories here ? AFAICT One$DB is the new kid on the block, but otherwise they all appear to be more or less similar. I'm looking for a DB that can easily be bundled with Tomcat and Rife to make a more-or-less turnkey application ("Just add Java!" :) In production deployment it can be embedded rather than a daemon. Ideally, the DB will have these features: - Works with JDK 1.5 - Transaction support - Single-file storage, rather than multiple files - Free for commercial use - Commercial support available - Can run embedded in a Rife app - But it can also run as a daemon, and there is a standalone tool to browse the DB Has anyone found that one of Rife's supported DB's delivers this in a fairly foolproof way ? thx fred -- F.Baube * Georgetown/MSFS/1988 * Act locally. email fbaube#welho.com * Think pangalactically. gsm +358 41 536 8192 * wmd 60°11'10.8"N 24°57'36.9"E _______________________________________________ Rife-users mailing list [email protected] http://www.uwyn.com/mailman/listinfo/rife-users
-- Geert Bevin Uwyn bvba "Use what you need" Avenue de Scailmont 34 http://www.uwyn.com 7170 Manage, Belgium gbevin[remove] at uwyn dot com Tel +32 64 84 80 03 PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9 Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net _______________________________________________ Rife-users mailing list [email protected] http://www.uwyn.com/mailman/listinfo/rife-users
