How to open HSQL DB tables of Liferay in eclipse

Earlier i blogged about how to connect to HSQL DB from command prompt using HSQL Database Manager. Now as per request i have blogged to connect to HSQL DB form Eclipse

> Open Data source explorer in Eclipse

> Right click on Database Connections > New, you see screen looking like below as shown in Figure.1

> Type hsql as showing screen below & select HSQLDB - Give a name to your DB connection

Figure.1

> Do as described in Figure.2 below(Point to a Liferay DB which is using HSQL)

Figure.2

> You will see screen like below in Figure.3, once done close this window

Figure.3

NOTE : Here jar file you will using should point to the hsql.jar you have for Liferay installation under tomcat/lib/ext (Below is the screen shot for the same)

> Now you have to give proper Liferay DB name & Database location - Give DB connection other will be populated automatically. Check the save password check box. In my case DB location is

D:\projects\liferay\lr52sp3\liferay-portal-5.2-ee-sp3\data\hsql\lportal

You change this path according to your Liferay instance DB running on HSQL

> You can test the connection as show below

 > Click on Next from above screen, you see below screen check for connection profile & click finish

> You will be redirect to Datasource Explorer, which looks like below

Please feel free to add comments.

Cheers :)