How to inspect the HSQL db using Squirrel SQL?

[12年前 に Cameron McBride によって更新されました。]

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.

[12年前 に jelmer kuperus によって更新されました。]

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

[12年前 に Cameron McBride によって更新されました。]

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

[12年前 に Hitoshi Ozawa によって更新されました。]

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.

[10年前 に Clay Banks によって更新されました。]

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

[12年前 に Fatema Rajkotwala によって更新されました。]

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.

[10年前 に David Lee によって更新されました。]

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!!

[9年前 に Roberto Méndez によって更新されました。]

You must use a jdbc connection like this:

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