liferay - java.sql.SQLException : Connections could not be acquired from the underlying database! — HSQLDB

Question

我已经安装了SQL Workbench/J Build 118我登录了Liferay Portal的HSQL数据库。

然后我关闭了 SQL Workbench，没有对数据库进行任何更改。我重新启动了 Liferay tomcat 服务器，然后出现以下错误:

ERROR [localhost-startStop-1][DialectDetector:124] java.sql.SQLException:
Connections could not be acquired from the underlying database!

还有这个警告:

WARN  [C3P0PooledConnectionPoolManager[identityToken->3c8jofUN]-HelperThread-#4][BasicResourcePool:1851]
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3249a129 --
Acquisition Attempt Failed!!! Clearing pending acquires.
While trying to acquire a needed new resource, we failed to succeed more than
the maximum number of allowed acquisition attempts (3).
Last acquisition attempt exception:
java.sql.SQLException: error in script file line: 
7 unexpected token: CONFLICT required: DEADLOCK

<子>ps。我正在使用最新版本的 HSQL JDBC 驱动程序 (v.2.3.3)

Answer 1

我通过更改 %LIFERAY_DIR%/data/hsql/lportal.script 文件中的这一行解决了该问题:

SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE

至

SET DATABASE TRANSACTION ROLLBACK ON DEADLOCK TRUE

然后我删除了这一行:

SET DATABASE SQL AVG SCALE 0

我成功启动了服务器。