web stats
Mirth Community - View Single Post - Mirth with MS SQL Server backend fails
View Single Post
  #2  
Old 05-14-2019, 05:25 AM
Shamil Shamil is offline
OBX.3 Kenobi
 
Join Date: May 2013
Posts: 151
Shamil is on a distinguished road
Default

That's interesting. The server was totally rebuilt with Windows 2012, and we've freshly installed JDK and Mirth, but still the same issue.
Windows 2012 is not connected to the Internet if that makes any difference.

Just to verify we switched back to Derby and received exactly the same error:

Code:
ERROR 2019-05-14 16:16:50,473 [Main Server Thread] com.mirth.connect.server.Mirth: Error establishing connection to database, aborting startup. java/sql/Connection
INFO  2019-05-14 16:16:50,477 [Shutdown Hook Thread] com.mirth.connect.server.Mirth: shutting down mirth due to normal request
ERROR 2019-05-14 16:16:50,542 [Shutdown Hook Thread] com.mirth.connect.server.controllers.DefaultConfigurationController: Could not retrieve property: category=core, name=channelDependencies
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: java/sql/Connection
### The error may exist in derby/derby-configuration.xml
### The error may involve Configuration.selectProperty
### The error occurred while executing a query
### Cause: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: java/sql/Connection
....
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: java/sql/Connection
                at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:512)
                at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:105)
                at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:94)
                at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:131)
                at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)
....
Caused by: java.lang.NoClassDefFoundError: java/sql/Connection
                at com.compuware.apm.agent.introspection.jdbc.ConnectionPoolIntrospection.updateConnectionClass(ConnectionPoolIntrospection.java:209)
                at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source)
....
We've installed SQL Squirrel to test the jdbc driver from C:\[Mirth root]\server-lib\database\jtds-1.3.1.jar independently.
However, on connection test this threw the error: class java.lang.NoClassDefFoundError: java/sql/Connection

Last edited by Shamil; 05-14-2019 at 06:44 AM.
Reply With Quote