Page 1 of 1

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

PostPosted:Sun Feb 14, 2016 8:56 am
by 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!

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

PostPosted:Tue Feb 16, 2016 7:43 pm
by 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.