javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

[cheeno_starx]

Hello guys,

I've installed OpenKM on Windows 7x64. I've got this error from Apache Tomcat.Attached also are the log files I got from Tomcat.

Code: Select all

Class: 	org.apache.jasper.JasperException
Message: 	   javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date:     Sun Feb 14 16:30:27 CST 2016

Please help me on this issue.

Thanks!

[jllort]

The error is clear:

Code: Select all

2016-02-14 09:13:28,283 [pool-2-thread-1] WARN  org.hibernate.cfg.SettingsFactory- Could not obtain connection to query metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.hsqldb.jdbcDriver'
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

In your tomcat-7.0.27 you should have the hsqldb.jar ( the hypersonic library ) and for some reason I think is missing or you have applied a security that when openkm is started has not access to the file.

I suggest on production environment go for MySQL.