Friday, August 15, 2014

H2 Database

H2 Database is another open open source database with a very small foot print. The database can be downloaded from http://www.h2database.com

Download H2 database. Windows version comes with an installer for H2 database otherwise you can download the zip version and unzip it at a location. Go to the bin directory of unzipped location and issue the command based in platform.

In Linux in a terminal issue 

./h2.sh. 

It will open a browser. In the browser select Generic H2 (Server) in saved settings menu. Accept the defaults. However you are free to change the defaults also. Click on connect. This will take you to a screen where you can do your database related stuff.

Database connection parameters for H2 Database is:

driver_class=org.h2.Driver
url=jdbc:h2:tcp://localhost/~/test
username=sa
password=""

No comments:

Post a Comment