Hsqldb another database how to use it.

[mjm]

HyperSQL DataBase(hsqldb) is a lightweight database that can be use instead of mysql when you are working with hibernate or struts or whatever program,You can download hsqldb from In order to view links, you must have to reply to this thread. .
After downloading extract it to the folder and to start the database server enter in to the folder and provide following command
"forex:c:\hsqlbd>java -cp ./lib/hsqldb.jar org.hsqldb.Server"
To start executing the commands go to installed folder and type "c:\hsqldb>java -cp ./lib/hsqldb.jar org.hsqldb.util.DatabaseManager" and enter the settings like driver,username and password and click ok
Finally execute the command in the prompt to execute the sql query
For connecting database use the driver "Class.forName(org.hsqldb.JdbcDriver)"
for connecting Connection con=con.createStatement("jdbc:hsqldb:hsql://localhost/")
Now enjoy working in hsqldb database server happy coding.