Fórum
How to inspect the HSQL db using Squirrel SQL?
Cameron McBride, modificado 12 Anos atrás.
How to inspect the HSQL db using Squirrel SQL?
Expert Postagens: 269 Data de Entrada: 08/02/11 Postagens Recentes
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.
Anexos:
jelmer kuperus, modificado 12 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL? (Resposta)
Liferay Legend Postagens: 1191 Data de Entrada: 10/03/10 Postagens Recentes
It works fine here. Did you forget to add /lportal at the end of your path ?
Cameron McBride, modificado 12 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
Expert Postagens: 269 Data de Entrada: 08/02/11 Postagens Recentes
That was it, works great now that I added lportal to the end. Thanks!
Hitoshi Ozawa, modificado 12 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
Liferay Legend Postagens: 7942 Data de Entrada: 24/03/10 Postagens Recentes
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, modificado 10 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
Regular Member Postagens: 141 Data de Entrada: 11/12/13 Postagens Recentes
SquirrelSQL just saved my skin thank you all who posted on this thread
Fatema Rajkotwala, modificado 12 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Postagens: 2 Data de Entrada: 17/02/12 Postagens Recentes
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, modificado 10 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Postagens: 16 Data de Entrada: 16/07/13 Postagens Recentes
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, modificado 9 Anos atrás.
RE: How to inspect the HSQL db using Squirrel SQL?
New Member Postagens: 2 Data de Entrada: 13/08/14 Postagens Recentes
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