File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes HSQLDB users take note Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "HSQLDB users take note" Watch "HSQLDB users take note" New topic

HSQLDB users take note

Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24199

Hi folks --

If you've used, or are using HSQLDB ( I'd appreciate a brief description of what you did with it and what you think. I'm trying to get an idea of how much usage this software actually gets.

[Jess in Action][AskingGoodQuestions]
Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211

I used it for my university project once. It was a web application with JSP, Servlets and a bundled-in HSQL DB.
I think I will probabely use it again for writing sample applications etc.
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
I once used it for a in-memory database that was not persisted on disk at all.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
We're using it in the automated integration tests for the Spring/Hibernate/Oracle project we've been working on for the last nine months. Can't say anything about its behaviour in a production situation, but it is happy enough to handle the sometimes hefty SQL statements Hibernate throws at it during the tests.

- Peter
Balaji Loganathan
author and deputy

Joined: Jul 13, 2001
Posts: 3150
Very tiny and efficient,
It helped me to shift my whole webapp application including database as a jar file. All the user have to do is install the jar in their application server.

Spritle Software Blogs
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

I used it to deliver an Access like Swing Application for someone that wanted to persist all his Star Wars crap. He had one in MS Access so I basically mirrored its functionallity and used HSQLDB so he didn't need anything extra to install.

GenRocket - Experts at Building Test Data
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

We have previously used HSQLDB as a server for the very-early startup phases of projects, knowing that it would be replaced before the project got too serious. It's a bit hard to explain the decision process, it was a while ago. We tend to default to MySql now when the database is unspecified.

I also tend to plug a standalone instance into web apps when I'm just scratching out a thought.
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 862
I use it in my demo application as an in-memory database that allows me to ship my war and require no installation of a separate database product like mySQL on the end users part.

If you go to any of the queries you issue go against hsqldb. This sample war is also available for download from - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
I agree. Here's the link:
subject: HSQLDB users take note
jQuery in Action, 3rd edition