Jobin's Blog: Adding HSQLDB Plugin to Eclipse

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.; September 19, 2010 at 4:55 AM
Anonymous said...: Thank you so much ...
It helped me exactly how I wanted ..
Many thanks dude .. Keep it up; November 27, 2010 at 12:46 AM
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; February 4, 2011 at 6:33 AM
Anonymous said...: Thanks for this. Very helpful.

Tyler Pedersen; March 11, 2011 at 10:01 PM
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; January 29, 2012 at 9:20 PM
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.; February 16, 2012 at 1:36 AM
SaiRaghava K said...: All good, but HSQL option is shown in java perspective not in J2EE perspective.; September 8, 2012 at 9:03 AM
Anonymous said...: thanks sai; April 5, 2013 at 3:29 PM
Anonymous said...: it shows only in java perspective..:(
any othr method?..; June 26, 2013 at 8:15 AM
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; January 20, 2014 at 12:26 AM
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.; January 20, 2014 at 12:27 AM
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.; January 20, 2014 at 12:28 AM
Unknown said...: Thank you so much ...
I do all of the step but my eclipse did not change at all. Please help me .; February 9, 2014 at 5:09 AM
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; June 30, 2015 at 5:55 AM