Subscribe for updates on posts
Be the first to read the latest news

Apache Derby versus Hypersonic SQL

October 3rd, 2006 by Robert Enyedi in Java, General

There are several limitations and problems of Apache Derby as noted in the previous post (http://blog.tremend.ro/2006/10/03/about-the-maturity-of-apache-derby/), but with Derby it seems that you’re still way better than with Hypersonic SQL. While I used Apache Derby extensively as described by the post, I did not end up trying out Hypersonic SQL for this same project I was porting. The reason was that when I asked around for potential issues right on the Hypersonic SQL mailing list, I received these responses.

To sum up, in Hypersonic SQL you can encounter database corruption, besides internal server errors. In Derby at least what you have in the database is secure. You might encounter some problems retrieving data when using more complex queries, but at no point when using Derby I never had to worry about the possibility of getting the database corrupted.


You might also like

About the maturity of Apache Derby For those of you that didn't hear about it yet, Apache Derby is a Java relational database engine that...
What to do: Error reading tld listeners java.lang.NullPointerException I've been bugged by this problem for some time now, so I decided investigating a bit. The error shows...
File not found: transaction …, path …. SVN mysteries behind an Apache Reverse Proxy We have an SVN server somewhere on our intranet, but since outside people want to access it, I put it...
Create a Solr filter that replaces diacritics Some languages (like Romanian) have special characters (diacritics, often called accent marks). It's...
.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.