How to integrate HSQL DB with java application

Question

I would like to integrate HSQL in my Java application for testing purposes. Is there any tutorial that describes in a simple way how to integrate it-I want to distribute it with my app. I'm not restricted to HSQL any other easier solution are welcomed.

Thanks

Solution

Your question is extremely broad and not really possible to answer, but I'll try anyway.

HSQLDB is not different to any other DBMS (except that it can run in the same process as your application - that is different e.g. to PostgreSQL).

Starting the database is described in the first chapter of the manual including a chapter on how to create a new database

Apart from that, just run your CREATE TABLE statements e.g. from within your application, the included SqlTool or any (JDBC based) SQL client that you like.

Deployment and integration into your application is described in the manual as well: http://hsqldb.org/doc/2.0/guide/deployment-chapt.html.

The chapter "Embedded Databases in Desktop Applications" might also be interesting to you.