web stats
Trying to use MS JDBC driver, but Mirth always reports error with JTDS driver - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2019, 01:04 PM
Tykester66 Tykester66 is offline
What's HL7?
 
Join Date: May 2018
Posts: 1
Tykester66 is on a distinguished road
Default Trying to use MS JDBC driver, but Mirth always reports error with JTDS driver

Can anyone tell my why Mirth is still using the JTDS driver instead of the JDBC driver? I'm using Mirth 3.7.1 with RedHat Open JDK 11

I have the following entry in dbdrivers.xml:
<driver class="com.microsoft.sqlserver.jdbc.SQLServerDrive r" name="sqlserver" template="jdbc:sqlserver://hostort;databaseName=dbname;integratedSecurity=t rue;" selectLimit="SELECT * FROM ? LIMIT 1" />

I have the following entries in mirth.properties:
database = sqlserver
database.url = jdbc:sqlserver://pghvm-vr5-sq1:1433;databaseName=mirthdb;integratedSecurity=t rue
database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

My CLASSPATH =.;C:\Program Files\Mirth Connect\server-lib\database\mssql-jdbc-7.2.2.jre11.jar
My PATH = ... ;C:\Program Files\Mirth Connect\server-lib\database;C:\Program Files\RedHat\java-11-openjdk-11.0.3-1\bin

In the C:\Program Files\Mirth Connect\server-lib\database folder, I've copied:
mssql-jdbc-7.2.2.jre11.jar
sqljdbc_auth.dll
sqljdbc_xa.dll

In the C:\Program Files\RedHat\java-11-openjdk-11.0.3-1\bin folder, I've copied:
mssql-jdbc-7.2.2.jre11.jar
sqljdbc_auth.dll
sqljdbc_xa.dll

With this configuration, the mirth log states:
ERROR 2019-06-17 16:00:01,983 [Shutdown Hook Thread] com.mirth.connect.server.controllers.DefaultConfig urationController: Could not retrieve property: category=core, name=channelDependencies
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:sqlserver://pghvm-vr5-sq1:1433;databaseName=mirthdb;integratedSecurity=t rue;authenticationScheme=JavaKerberos
### The error may exist in sqlserver/sqlserver-configuration.xml
### The error may involve Configuration.selectProperty
### The error occurred while executing a query
### Cause: java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:sqlserver://pghvm-vr5-sq1:1433;databaseName=mirthdb;integratedSecurity=t rue;authenticationScheme=JavaKerberos
at org.apache.ibatis.exceptions.ExceptionFactory.wrap Exception(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSessi on.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSessi on.selectList(DefaultSqlSession.java:95)
at org.apache.ibatis.session.defaults.DefaultSqlSessi on.selectOne(DefaultSqlSession.java:59)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invo ke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invo ke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl. invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.session.SqlSessionManager$SqlSes sionInterceptor.invoke(SqlSessionManager.java:282)
at com.sun.proxy.$Proxy9.selectOne(Unknown Source)
at org.apache.ibatis.session.SqlSessionManager.select One(SqlSessionManager.java:151)
at com.mirth.connect.server.controllers.DefaultConfig urationController.getProperty(DefaultConfiguration Controller.java:836)
at com.mirth.connect.server.controllers.DefaultConfig urationController.getChannelDependencies(DefaultCo nfigurationController.java:939)
at com.mirth.connect.server.util.ChannelDependencySer verUtil.getDependencyGraph(ChannelDependencyServer Util.java:26)
at com.mirth.connect.server.util.ChannelDependencySer verUtil.getOrderedChannels(ChannelDependencyServer Util.java:30)
at com.mirth.connect.server.controllers.DonkeyEngineC ontroller.undeployChannels(DonkeyEngineController. java:410)
at com.mirth.connect.server.controllers.DonkeyEngineC ontroller.stopEngine(DonkeyEngineController.java:2 26)
at com.mirth.connect.server.Mirth.stopEngine(Mirth.ja va:371)
at com.mirth.connect.server.Mirth.shutdown(Mirth.java :327)
at com.mirth.connect.server.Mirth$ShutdownHook.run(Mi rth.java:441)
Caused by: java.lang.RuntimeException: Driver net.sourceforge.jtds.jdbc.Driver claims to not accept jdbcUrl, jdbc:sqlserver://pghvm-vr5-sq1:1433;databaseName=mirthdb;integratedSecurity=t rue;authenticationScheme=JavaKerberos
at com.zaxxer.hikari.util.DriverDataSource.<init>(Dri verDataSource.java:84)
at com.zaxxer.hikari.pool.PoolBase.initializeDataSour ce(PoolBase.java:318)
at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.ja va:108)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPoo l.java:99)
at com.zaxxer.hikari.HikariDataSource.getConnection(H ikariDataSource.java:94)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction .openConnection(JdbcTransaction.java:131)
at org.apache.ibatis.transaction.jdbc.JdbcTransaction .getConnection(JdbcTransaction.java:58)
at org.apache.ibatis.executor.BaseExecutor.getConnect ion(BaseExecutor.java:279)
at org.apache.ibatis.executor.SimpleExecutor.prepareS tatement(SimpleExecutor.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doQuery( SimpleExecutor.java:56)
at org.apache.ibatis.executor.BaseExecutor.queryFromD atabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(Base Executor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(C achingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(C achingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSessi on.selectList(DefaultSqlSession.java:101)
... 18 more
Reply With Quote
  #2  
Old 06-18-2019, 07:52 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 1,028
agermano is on a distinguished road
Default

There's a bug in 3.7 due to the addition of the read-only database pool. You don't have to specify the database if you want read-only actions to share the main pool, but you do have to specify the driver in database-readonly.driver in your mirth.properties file.

http://www.mirthcorp.com/community/i...wse/MIRTH-4414
Reply With Quote
Reply

Tags
jdbc, sql server

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 08:49 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation