In Liferay with hsql: Where is the database file

2019-06-25 14:26发布

问题:

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)