Tuesday, May 4, 2010

Adding HSQLDB Plugin to Eclipse

i wanted to play a little bit with HSQLDB and i thought it might be a good idea to add HSQLDB Plugin to my eclipse so that i can use it more seamlessly while i try out stuff in my java code from eclipse.The main advantage is that the footprint of the DB is so small and no complex installation is there.It doesn't consume much resources & is good enough while experimenting things in a dev box.
I thought of keeping some quick pointers here.

1.Download HSQLDB from sourceforge http://sourceforge.net/projects/hsqldb/
2.Download HSQLDBPlugin from sourceforge http://sourceforge.net/projects/hsqldb-plugin/files/
3.Unzip the HSQLDBPlugin zip,you will get two folders hsqldb.core and hsqldb.ui
4.Copy both the folders into ECLIPSE_HOME/plugins folder
5.Navigate to ECLIPSE_HOME/plugins/hsqldb.ui folder from command prompt/shell
6.run the command jar cvf ui.jar -C bin . (note the ending dot,denotes the current folder).This command will generate ui.jar
7.restart eclipse

Once we follow these steps,we will see a new link named "Add Database Engine Nature" appear in the right click menu of the eclipse project

Clicking on this menu will then show up various options for starting/stopping/starting database manager etc

14 comments:

Anonymous said...

Thanks a lot,
Simple and to the point.

Anonymous said...

Thank you so much ...
It helped me exactly how I wanted ..
Many thanks dude .. Keep it up

Coenos said...

Hi Jobin,

cool post. However, the included HSQLDB jar is ancient (2003).

For successful development, you need at least HSQLB 1.8.0.10. Make sure to replace the hsqldb.jar in hsqlbd.core and/or change the correct path in plugin.xml.

Cheers. Coen

Anonymous said...

Thanks for this. Very helpful.

Tyler Pedersen

Anonymous said...

Thanks for posting this!

One thing I noticed is that the HSQLDB context menu only shows in the Java perspective, but not in the Java EE perspective.

Cheers

Marc

HSQLDB looney said...

Thank you buddy. It was really frustrating trying to figure out how to install the plugin. There is absolutely nothing on the web that describes these steps except for you link. I was missing dot(.) and running into issues before i figured that out thanks to you.

SaiRaghava K said...

All good, but HSQL option is shown in java perspective not in J2EE perspective.

Anonymous said...

thanks sai

Anonymous said...

it shows only in java perspective..:(
any othr method?..

Anonymous said...

D:\eclipse-jee-helios-SR2-win32\eclipse\plugins\hsqldb.ui>jar cvf ui.jar -C bin .

When i write above command in command prompt

This error is occured..

'jar' is not recognized as an internal or external command,
operable program or batch file.

please help me

Anonymous said...

D:\eclipse-jee-helios-SR2-win32\eclipse\plugins\hsqldb.ui>jar cvf ui.jar -C bin .

When i write above command in command prompt

This error is occured..

'jar' is not recognized as an internal or external command,
operable program or batch file.

Anonymous said...

D:\eclipse-jee-helios-SR2-win32\eclipse\plugins\hsqldb.ui>jar cvf ui.jar -C bin .

When i write above command in command prompt

This error is occured..

'jar' is not recognized as an internal or external command,
operable program or batch file.

Unknown said...

Thank you so much ...
I do all of the step but my eclipse did not change at all. Please help me .

nallabheem said...

Hi Jobin,

I did all the steps but in my eclipse I don't see this option though I am in java-perspective.

I am using the eclipse-Lunar.

Any help in this regard is much appreciated.

Regards
Satish N