Page 1 of 1

My OpenKm Cannot open connection,please help me

PostPosted:Mon Aug 14, 2023 10:06 am
by qmkkx100
For some reason, I wanted to use Dbeaver to connect to HSQLDB, the database that comes with Openkm, but there was an error indicating that the connection was occupied, so I cut the okmdb.lck file somewhere else, but when I restarted Openkm, I got the following error:
Code: Select all
Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Mon Aug 14 15:30:18 CST 2023
Attached is the log file, please help me, thank you

Re: My OpenKm Cannot open connection,please help me

PostPosted:Wed Aug 23, 2023 5:00 pm
by jllort
In the case of embeded databases only one application can be connected at the same time. I suggest using mariadb database or mysql.

Take a look here https://docs.openkm.com/kcenter/view/ok ... riadb.html

If you wish to continue with HSQL, have the option in the administration of the OpenKM to do SQL Queries with the menu option Database Query https://docs.openkm.com/kcenter/view/ok ... query.html