aspose file tools*
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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HSQLDB users take note" Watch "HSQLDB users take note" New topic
Author

HSQLDB users take note

Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24187
    
  34

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
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
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
author
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
Bartender

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: 15300
    
    6

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
Rancher

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: 861
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HSQLDB users take note