Forums

Home » Liferay Portal » English » Liferay Legacy

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Marcio Marcio
How can I view/edit the Hypersonic database bundled with Liferay?
April 4, 2006 8:40 AM
Answer

Marcio Marcio

Rank: New Member

Posts: 13

Join Date: April 1, 2006

Recent Posts

Hi,<br /><br />I&#39;m not familiar with Hypersonic. Tried to change the database to SQL Server but got some issues. In the meantime, I&#39;ll stick with Hypersonic since it seems to be the one that is working properly.<br /><br />How can I access the content of this database, view tables, edit rows, etc? Is there a client for this database?<br /><br />Thanks.
John Rabe
How can I view/edit the Hypersonic database bundled with Liferay?
April 4, 2006 9:28 AM
Answer

John Rabe

Rank: Junior Member

Posts: 63

Join Date: July 14, 2005

Recent Posts

Hey, Marcio,<br /><br />I learn it from www.hsqldb.org<br /><br />java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing<br />or java -cp hsqldb.jar org.hsqldb.util.DatabaseManager<br /><br />Ching
Neil Griffin
How can I view/edit the Hypersonic database bundled with Liferay?
April 4, 2006 11:02 AM
Answer

Neil Griffin

LIFERAY STAFF

Rank: Liferay Legend

Posts: 2369

Join Date: July 26, 2005

Recent Posts

<br />Hi,<br /><br />I&#39;m not familiar with Hypersonic. Tried to change the database to SQL Server but got some issues. In the meantime, I&#39;ll stick with Hypersonic since it seems to be the one that is working properly.<br /><br />How can I access the content of this database, view tables, edit rows, etc? Is there a client for this database?<br /><br />Thanks.<br />
<br /><br />Another way you can do it is to use a free JDBC tool like JaySQL (formerly WinSQL for Java) that you can download from <a href="http://www.synametrics.com/SynametricsWebApp/WinSQLForJdbc.jsp" target="_blank">here</a>.<br /><br />Here is the JDBC connection info:<br /><br />JDBC Class: org.hsqldb.jdbcDriver<br />JDBC Connection String: jdbc:hsqldb:file:c:/liferay-3.6.1/jboss-tomcat/bin/test<br />Username: sa<br />Password:<br /><br />Note that you have to replace c:/liferay-3.6.1/jboss-tomcat/bin/test to the one that matches your system.<br /><br />Neil
Marcio Marcio
How can I view/edit the Hypersonic database bundled with Liferay?
April 6, 2006 2:46 PM
Answer

Marcio Marcio

Rank: New Member

Posts: 13

Join Date: April 1, 2006

Recent Posts

Thanks guys
ilke Muhtaroglu
RE: How can I view/edit the Hypersonic database bundled with Liferay?
July 1, 2010 5:41 AM
Answer

ilke Muhtaroglu

Rank: Regular Member

Posts: 226

Join Date: May 12, 2009

Recent Posts

I get the following error when I try to do what is described at wiki:



in Configure the HSQL Driver, it is told that we should provide the hsql.jar (this already exists in /lib/ext of liferay tomcat distribution, ok?)

then we are told to provide an url, which is in form "jdbc:hsqldb:."

there it is told url should be "jdbc:hsqldb:file:<path>/lportal"

( according to this link: http://www.emforge.net/web/liferay-petstore-portlet/wiki/-/wiki/Main/Step1:+From+DB+to+simple+UI )

( according to this link: http://www.liferay.com/community/forums/-/message_boards/message/70471 )

so what I try is to give URL:

jdbc:hsqldb:file:/home/ilke/lportal6/liferay-apache-tomcat-6.0.26/bin/lportal


Then I get the following error by SQuirreL:

( liferay_hsql: The database is already in use by another process: lockFile: org.hsqldb.persist.LockFile@b82b963b[file =/home/ilke/lportal6/liferay-apache-tomcat-6.0.26/bin/lportal.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2010-07-01 15:35:24.417 heartbeat - read: -9854 ms.
)


I use Ubuntu, liferay deployed into tomcat.

ilke
Palani Venkat
RE: How can I view/edit the Hypersonic database bundled with Liferay?
April 12, 2011 2:59 AM
Answer

Palani Venkat

Rank: Junior Member

Posts: 32

Join Date: November 10, 2010

Recent Posts

The current HSQLDB can be accessed through the client by executing the following command from the tomcat\lib\ext folder, where hsql.jar is available.

java -cp hsql.jar org.hsqldb.util.DatabaseManagerSwing
Hitoshi Ozawa
RE: How can I view/edit the Hypersonic database bundled with Liferay?
April 12, 2011 4:00 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

If you shutdown your Liferay, hsql dumps all the sql script to create the database in \data\hsql\lportal.script

Just as a note, you shouldn't change the content of the database directly unless you really know what you're doing.
Michael Bravo
RE: How can I view/edit the Hypersonic database bundled with Liferay?
February 25, 2013 6:20 PM
Answer

Michael Bravo

Rank: New Member

Posts: 20

Join Date: April 26, 2012

Recent Posts

Palani,

I know this is an old thread, but I haven't been able to view the DB this way. I am able to get the HSQLDB Swing app to display but when I enter the URL path to the lportal DB it fails with a '.lck' error. I attempted to removing the file, but somehow still get the same error.

Any thoughts?

Thanks,
~Michael
Hitoshi Ozawa
RE: How can I view/edit the Hypersonic database bundled with Liferay?
February 26, 2013 4:58 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Just use squirrelSQL. Follow Jelmer's suggestion in the following thread.

http://www.liferay.com/community/forums/-/message_boards/message/12551601

There's also a wiki page.
http://www.liferay.com/community/wiki/-/wiki/Main/HSQLInspect
Michael Bravo
RE: How can I view/edit the Hypersonic database bundled with Liferay?
February 26, 2013 11:58 AM
Answer

Michael Bravo

Rank: New Member

Posts: 20

Join Date: April 26, 2012

Recent Posts

Thanks Hitoshi. I ended up using this after posting and it did work fine. Also, In case anyone runs across the same issue, you can use Eclipse. I was also able to accomplish the same by pulling the DB files off the server, storing them locally and connecting using Eclipse's DB Perspective. It's more or less the same connection properties as Squirrel. You just need to point configure the connection to point to a local copy of hsql.jar.

Thanks you again for your reply.