I am using Liferay with Apache Tomcat and hsql. I need to locate the database file that is used. According to hsql documentation there should be a file lportal.data in the directory data/hsql, but there isn't one.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
The hibernate database consists of 4 files.
The .script file contains the data as SQL, the .log that last actions that took place, the .properties the configuration and the .lck is the db lockfile.
These are the database, hsql has nothing like one big .data file. All other constructs that are typical for a database are generated and only in memory.
回答2:
Connection line jdbc:hsqldb:file:/D:/Coding/liferay-portal-6.1.0-ce-ga1/data/hsql/lportal
for Squirrel SQL Client (Liferay on Apache Tomcat)