Originally posted by Gregg Bolinger: I've worked with both. They seem about the same to me. Anyone have a preference and why?
How can there be any question? With that name, it's obvious that the Apache product is superior...
But seriously, I asked a trusted co-worker with serious experience with both; his opinion was that HSQLDB was better for small-footprint applications (e.g. embedded in a cellphone app or small part of a J2EE app), and Derby was the better choice as a desktop engine for most purposes. He mentioned that the version he worked with (prior to the most recent 10.1.1.0 release) had some small db2-like issues that were non-standard, but he didn't explain what those were.
I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.
Sorry for the late response. I appreciate the tips. I recently used Derby in a small utility at work and that is why I asked the question. I find datbases like Derby and HSQLDB useful for application where you would normally need to write information to a log file and then need to analize that log file later. It is much simpler to write SQL queries to obtain that data.
I wonder if anyone has compared the build in functions available in both databases and noticed one or the other have more/better options?
One item I saw in there mentioned HSQLDB being faster that cloudscape though I haven't compared. <<HSQLDB is the best java embedded database I have found, far better performance than derby/cloudscape, both when inserting and querying.>>
I use an in memory hsqdldb database for a live demo I have at www.fdsapi.com and have been happy with it, though I hardly stress the database.