How to inspect the HSQL db using Squirrel SQL?

[Cameron McBride, geändert vor 12 Jahren.]

I've followed the pretty simple wiki article to setup a connection to the hsql db: http://www.liferay.com/community/wiki/-/wiki/Main/HSQLInspect. Once connected I can see three schemas, one called Public. Under Public I can see Tables but there is nothing listed. I assume there should be some stuff listed for me to check out? I have Liferay stopped when I am inspecting things. I have also tried it with the server running.

[jelmer kuperus, geändert vor 12 Jahren.]

It works fine here. Did you forget to add /lportal at the end of your path ?

[Cameron McBride, geändert vor 12 Jahren.]

That was it, works great now that I added lportal to the end. Thanks!

[Hitoshi Ozawa, geändert vor 12 Jahren.]

Thanks for the information on Squirrel SQL. I have to try it out myself. From the screenshot, it seems great. Probably better than setting up mysql databases during testing.

I think I'll help add Japanese translation to the project for my users here.

[Clay Banks, geändert vor 10 Jahren.]

SquirrelSQL just saved my skin thank you all who posted on this thread

[Fatema Rajkotwala, geändert vor 12 Jahren.]

Hi,
I tried to configure the liferay HSQLDB as mentioned in the above article.
I gave the URL as jdbc:hsqldb:file:<Liferay_HOME>/data/hsql/Iportal
I am not getting any errors and when I am testing the Squirrel connection it is showing as Connection successful.
But still I am not able to view the liferay tables.Is there something more that needs to be configured.Please help me out.

[David Lee, geändert vor 10 Jahren.]

Hi,
I get an error when trying to connect:
Caused by: java.sql.SQLException: Unable to create connection. Check your URL.
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:136)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more

I am running Windows. So my URL is:
jdbc:hsqldb:file:c:/liferay/data/hsql/lportal

Is this correct? Please help. Thanks in advance!!

[Roberto Méndez, geändert vor 9 Jahren.]

You must use a jdbc connection like this:

jdbc:hsqldb:file:/C:/liferay-portal-6.2-ce-ga2/data/hsql/lportal