web stats
Error Building SQL Session - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2019, 09:30 AM
petem petem is offline
What's HL7?
 
Join Date: Nov 2018
Posts: 1
petem is on a distinguished road
Default Error Building SQL Session

Hello,

I am creating a new MIRTH server for our environment. It is running Server 2019 in Azure and connecting to a SQL PaaS instance in Azure. Java 8 Update 201 (64 bit) is installed along with Mirth Connect 3.7.1.b243 and the Mirth Connect Administrator Launcher. I added the JDBC driver to dbdrivers.xml. I changed the mirth.properties file to server.includecustomlib = true and added the database.url and database.driver. In the custom-lib file I have the smsql-jdbc-7.2.1.jre11.jar file.

Whenever I try to open http://localhost:8080 or https://localhost:8443, I get the following error:

ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Exception in thread "Main Server Thread" java.lang.RuntimeException: org.apache.ibatis.exceptions.PersistenceException:
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Error building SqlSession.
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### The error may exist in SQL Mapper Configuration
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.init(SqlCo nfig.java:117)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.<init>(Sql Config.java:71)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.getInstanc e(SqlConfig.java:62)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.Mirth.startup(Mirth.java: 228)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.Mirth.run(Mirth.java:154)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: org.apache.ibatis.exceptions.PersistenceException:
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Error building SqlSession.
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### The error may exist in SQL Mapper Configuration
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.exceptions.ExceptionFactory.wrap Exception(ExceptionFactory.java:23)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:51)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:43)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.createFact ory(SqlConfig.java:141)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.init(SqlCo nfig.java:101)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 4 more
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par seConfiguration(XMLConfigBuilder.java:105)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par se(XMLConfigBuilder.java:88)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:49)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 7 more
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.mybatis.BridgeDataSourceF actory.setProperties(BridgeDataSourceFactory.java: 30)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.dat aSourceElement(XMLConfigBuilder.java:264)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.env ironmentsElement(XMLConfigBuilder.java:222)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par seConfiguration(XMLConfigBuilder.java:100)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 9 more

I have tried different versions of the JDBC file, added the localhost to the security settings in Java, rebooted multiple times, etc. but I still cannot seem to get connected.

Has anyone else experienced this issue?

Thanks in advance.
Reply With Quote
Reply

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 05:22 AM.


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