wood burning stoves 2.0*
The moose likes JDBC and the fly likes HSQLDB users take note Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 24183

Hi folks --

If you've used, or are using HSQLDB (http://hsqldb.sourceforge.net/) 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: 15299

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: 860
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 http://ssouza.kgbinternet.com/fdsapi/demo.jsp any of the queries you issue go against hsqldb. This sample war is also available for download from http://www.fdsapi.com

http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
subject: HSQLDB users take note
Similar Threads
help! Java desktop application database
MappingException class is not there in hibernate-tools.jar
Cannot open connection
light weight in memory database with the option of saving to csv/xml files
HSQL Database error