Liferay.com

Tuesday, November 29, 2011

How to open HSQL DB tables of Liferay

Some times we may need come across vague where we have to check few things immediately. Need to make some new version of Liferay up & running quickly, have to check DB for reference

As we all know default DB that Liferay uses in HSQL DB.

Here are the quick steps to how to open HSQL DB table entries in Liferay


Step 1: Download HQSLDB from http://hsqldb.org. Extract into some folder (eg. D:\hsqldb)

Step 2: You can use the HSQLDB DatabaseManager to view this database. Run the following from the command line to invoke the tool.

    java -cp D:\hsqldb\lib\hsqldb.jar org.hsqldb.util.DatabaseManager

    In the "Connect" dialog, select the following options:
    Type: HSQL Database Engine Server
    Driver: org.hsqldb.jdbcDriver
    URL: jdbc:hsqldb: (In my case i have my Liferay installation @ D:\projects\liferay\lr523\liferay-portal-5.2.3\data\hsql so i have to give path as jdbc:hsqldb:D:/projects/liferay/lr523/liferay-portal-5.2.3/data/hsql/lportal for URL)
    User: sa
    Password:

Please see the attached image for reference of settings we need to provide


That's it now you should be able to see all the tables. Database interface may not be quite intuitive as other commercial/open-source DB interfaces. Please check the below image for ref



UPDATE : Check the blog for how to connect to HSQL DB using Eclipse

http://btnkumar.blogspot.com/2011/11/how-to-open-hsql-db-tables-of-liferay_29.html

Please feel free to provide feedback if any

Cheers :)



5 comments:

  1. Nice Blog Nagendra!!!
    If you can also share images for connecting same in eclipse without using HSQLDB DatabaseManager :)

    ReplyDelete
  2. Mayur, as per your request i quickly blogged about the same. Please check the same here

    http://btnkumar.blogspot.com/2011/11/how-to-open-hsql-db-tables-of-liferay_29.html

    Hope it helps :)

    ReplyDelete
  3. Cool, I can see my database! Thanks for this!

    ReplyDelete
  4. Thanks Nagendra, That will help to the members, Nice work :)

    ReplyDelete
  5. If you can join this blog as followers - it will give me push to blog more :). Just a request

    ReplyDelete