web stats
Mirth Community - View Single Post - Mirth with MS SQL Server backend fails
View Single Post
  #1  
Old 05-07-2019, 09:12 PM
Shamil Shamil is offline
OBX.3 Kenobi
 
Join Date: May 2013
Posts: 153
Shamil is on a distinguished road
Default Mirth with MS SQL Server backend fails

I'm trying to configure MS SQL Server as Mirth back-end database but it fails with the following (Microsoft Windows Server 2008 R2 Datacenter, JDK 11, login name is set with SQL Server Authentication, DB connection string is as Mirth Manager suggests):

Code:
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.compuware.apm.agent.util.classvalue.InstrumentedClassValueAccess$1 to field java.lang.Class.dynatraceClassValue
WARNING: Please consider reporting this to the maintainers of com.compuware.apm.agent.util.classvalue.InstrumentedClassValueAccess$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
ERROR 2019-05-08 14:12:18,213 [Main Server Thread] com.mirth.connect.server.Mirth: Error establishing connection to database, aborting startup. java/sql/Connection
INFO  2019-05-08 14:12:18,219 [Shutdown Hook Thread] com.mirth.connect.server.Mirth: shutting down mirth due to normal request
ERROR 2019-05-08 14:12:18,305 [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 sqlserver/sqlserver-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 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(Exception
....
What's wrong with HikariCP? Should I use the newest Microsoft JDBC driver or something?

Last edited by Shamil; 05-07-2019 at 09:17 PM.
Reply With Quote