aspose file tools*
The moose likes JDBC and the fly likes Derby and HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Derby and HSQLDB" Watch "Derby and HSQLDB" New topic
Author

Derby and HSQLDB

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

I've worked with both. They seem about the same to me. Anyone have a preference and why?


GenRocket - A Test Data Generation Platform
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

I've only used HSQLDB, and I've found it 'good enough'. I'd never look at doing anythiong with it other than running basic tests or demo versions, so my requirements are pretty small.
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
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.
Nitin Agarwal
Greenhorn

Joined: Dec 15, 2005
Posts: 9
Hi derby,

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.

Thanks
Nitin
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Nitin,
You will have a better chance of a response if you create a new thread for your question since it is not directly associated with the current conversation.

Dave
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

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?
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 852
This would be a good question to post at the hsqldb forum and also at the derby forum. The hsqldb forum is here:

http://sourceforge.net/forum/forum.php?forum_id=73674

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.


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Derby and HSQLDB