Fórumok
How to inspect the HSQL db using Squirrel SQL?
Cameron McBride, módosítva 12 év-val korábban
How to inspect the HSQL db using Squirrel SQL?
Expert Bejegyzések: 269 Csatlakozás dátuma: 2011.02.08. Legújabb bejegyzések
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.
Mellékletek:
jelmer kuperus, módosítva 12 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL? (Válasz)
Liferay Legend Bejegyzések: 1191 Csatlakozás dátuma: 2010.03.10. Legújabb bejegyzések
It works fine here. Did you forget to add /lportal at the end of your path ?
Mellékletek:
Cameron McBride, módosítva 12 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
Expert Bejegyzések: 269 Csatlakozás dátuma: 2011.02.08. Legújabb bejegyzések
That was it, works great now that I added lportal to the end. Thanks!
Hitoshi Ozawa, módosítva 12 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
Liferay Legend Bejegyzések: 7942 Csatlakozás dátuma: 2010.03.24. Legújabb bejegyzések
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.
I think I'll help add Japanese translation to the project for my users here.
Clay Banks, módosítva 10 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
Regular Member Bejegyzések: 141 Csatlakozás dátuma: 2013.12.11. Legújabb bejegyzések
SquirrelSQL just saved my skin thank you all who posted on this thread
Fatema Rajkotwala, módosítva 12 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Bejegyzések: 2 Csatlakozás dátuma: 2012.02.17. Legújabb bejegyzések
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.
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, módosítva 10 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Bejegyzések: 16 Csatlakozás dátuma: 2013.07.16. Legújabb bejegyzések
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!!
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, módosítva 9 év-val korábban
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Bejegyzések: 2 Csatlakozás dátuma: 2014.08.13. Legújabb bejegyzések
You must use a jdbc connection like this:
jdbc:hsqldb:file:/C:/liferay-portal-6.2-ce-ga2/data/hsql/lportal
jdbc:hsqldb:file:/C:/liferay-portal-6.2-ce-ga2/data/hsql/lportal