Couldn’t connect to liferay HSQL database

Problem: When I am trying to connect to default database used by Liferay. I am getting an exception “HSQLDB-In memory: The database is already in use by another process: lockFile: org.hsqldb.persist.LockFile@ca3f17a1”

Solution:

• Open the properties file C:\demo\liferay-portal-6.0.6\data\hsql\lportal.properties
• Change the value of “hsqldb.lock_file” to “false”
• Restart the liferay tomcat server

Info:

• JDBC URL = jdbc:hsqldb:file:/C:/demo/liferay-portal-6.0.6/data/hsql/lportal
• UserName=sa
• Password=
• Password is empty