javamysqlmirth

How to read database and convert result to HL7 file in Mirth Connect


I need help with reading MySQL database and converting it's result to HL7 file with Mirth Connect.

Since now I've added simple database reader as Source (picture below).

Data types in Summary tab are set like this:

Then I added Destination to be File writer and added path to folder and filename.

When I try to deploy this channel I get an error:

[2021-09-16 12:38:20,001]  ERROR  (org.quartz.core.JobRunShell:222): Job d7444f3c-249a-4e4f-b3b2-1862ac874cbc.PollConnectord7444f3c-249a-4e4f-b3b2-1862ac874cbc threw an unhandled Exception: 
java.lang.IllegalAccessError: class com.mirth.connect.connectors.jdbc.DatabaseReceiverQuery (in unnamed module @0x2ca26d77) cannot access class com.sun.rowset.CachedRowSetImpl (in module java.sql.rowset) because module java.sql.rowset does not export com.sun.rowset to unnamed module @0x2ca26d77
    at com.mirth.connect.connectors.jdbc.DatabaseReceiverQuery.poll(DatabaseReceiverQuery.java:195)
    at com.mirth.connect.connectors.jdbc.DatabaseReceiver.poll(DatabaseReceiver.java:134)
    at com.mirth.connect.donkey.server.channel.PollConnectorJob.execute(PollConnectorJob.java:49)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Solution

  • I did it :)

    My solution was simple.. downgrade Java version from 16 to 15 and it will work perfectly.