PCMan911's tech blog

First off long time no post here on my blog, but thought this one might help other people out having difficulty in installing the latest version of Mirth (NextGen) Connect into a Microsoft SQL or SQL Express environment. In this quick rundown I will explain how I created a new Mirth Connect installation using Microsoft SQL Express 2017 and OpenJDK. Mirth Connect, now called NextGen Connect is a powerful open source HL7 integration engine with many features and a huge online community of resources and help. A big piece of the puzzle is Java.  Oracle will no longer support Java 8 and free updates at the end of 2020.  Basically starting in 2019 companies will have to license Java 11 (what happened to 9 & 10?) and the runtime be embedded or included as part of the fees.  Consumers will no longer have access to free Java runtime environment. (link:https://www.java.com/en/download/release_notice.jsp) Mirth Connect has relied heavily on Java for running.  The good part is they do s