Editing Database Drivers

Column	Required	Description
Name	Yes	The name of the driver entry. This will appear in the drop-down menu for the Database Reader/Writer connectors.
Driver Class	Yes	The fully-qualified Java class name for the JDBC driver.
JDBC URL Template	Yes	The template for the JDBC connection URL that can be auto-populated from the Database Reader/Writer settings.
Select with Limit Query	No	A select query (with limit 1) that can be used to retrieve column metadata. If empty the driver-specific generic query will be used, which could be slow.
Legacy Driver Classes	No	A comma-separated list of alternate or legacy JDBC driver class names. Any Database Reader/Writer connector using one of these driver classes will have the corresponding entry selected in the Driver drop-down menu. The driver will be updated to the primary value if you select the entry from the drop-down menu again.

Mirth® Connect by NextGen Healthcare User Guide

Database Reader

This Database Reader connects to an external database, performs a query, and reads selected rows into messages that get dispatched to the channel. This can be done using a SQL statement, or by using JavaScript mode to perform the query manually. The database connection will automatically be kept open across multiple polling windows, unless otherwise specified. This connector also supports a Post-Process section where an update statement can be performed after each row is read in, for example to set a processed flag in the source table. The values selected from the query will be automatically converted into an XML document where each column will be a separate node. That XML document is what actually gets dispatched to the channel as a message. Supported property groups: Polling Settings Source Settings Item Name Default Value Description A Driver Specifies the type of database driver to use to connect to the database. The following values are supported by default: Sun JDBC-ODBC Bridge M

Mirth® Connect by NextGen Healthcare User Guide

Adding a new entry to dbdrivers.xml

Simply add a new <driver> node to the list. The following attributes must be specified: class: The fully-qualified class name of the JDBC Driver implementation. name: The name you want to appear in the Driver drop-down menu. template: The JDBC URL template you want to have populated when you select on the Insert URL Template button in a Database connector. selectLimit: An optional query that selects one row from a given table. If specified, this will be used when attempting to retrieve database metadata. alternativeClasses: A comma-separated list of legacy driver classes (optional). Parent topic: dbdrivers.xml File

Mirth® Connect by NextGen Healthcare User Guide

Database Writer

This destination connector connects to an external database and performs an INSERT/UPDATE statement (or any other statement, like calling a stored procedure). This can be done using a SQL statement, or by using JavaScript mode to execute the statement manually. The database connection will automatically be kept open across multiple dispatches. Supported property groups: Destination Settings Item Name Default Value Description A Driver Specifies the type of database driver to use to connect to the database. The following values are supported by default: Sun JDBC-ODBC Bridge MySQL Oracle PostgreSQL SQL Server / Sybase SQLite Additional drivers can be added by editing the dbdrivers.xml File. B URL The JDBC URL to connect to the database with. This is not used when "Use JavaScript" is checked. However, it is used when the Generate Connection / Insert feature is used to generate code. Use the Insert URL Template button to populate the URL field with a starting template. C Username The usern

Mirth® Connect by NextGen Healthcare User Guide

3.8.0 Upgrade Notes

In version 3.8 we upgraded the MySQL JDBC driver to version 8.0.16, so that the latest MySQL 8.x can be used. However the new driver doesn't support versions of MySQL older than 5.6. Since these older versions are over 10 years old and are already listed as End-Of-Life by Oracle, we have made the decision to adjust our system requirements to reflect that 5.6+ is now the minimum supported version for MySQL. If you still need to connect to an older version of MySQL, do not worry you still can! Connecting via a Database Reader/Writer or in JavaScript Download the appropriate MySQL JDBC Driver JAR for the version of MySQL you need to connect to. Place this JAR into a folder of your choice on the system running Mirth Connect. Create a new library resource (Settings -> Resources tab) pointing to that folder. Link your connector/channel to your new resource (Summary tab -> Set Dependencies). Make sure you are using the old driver class name, "com.mysql.jdbc.Driver". Using an Old Version of My

Mirth® Connect by NextGen Healthcare User Guide

Change Database Settings

Double-click the Mirth icon in your system tray to open the Mirth® Connect Server Manager. Select the Database tab. In the Type field, select the database server you want to connect to from the pull-down menu. The JDBC URL field will be auto-populated with a sample URL. In the URL field, change the IP, port, and database name as needed. Enter the Username and Password, if needed. Select Apply. Select OK to exit the Server Manager. Note: If using sqlserver, the SQL Server/Sybase (jTDS) driver is used by default. If you prefer to use the Microsoft SQL Server driver, you must edit the properties file directly (see Editing the Properties File Directly for Windows, Linux, and Mac). Editing the Properties File Directly for Windows, Linux, and Mac Parent topic: Changing the Database Type

Mirth® Connect by NextGen Healthcare User Guide

JMS Listener

This source connector connects to an external JMS provider and reads messages from a queue or topic. It supports both JNDI and specifying a specific connection factory, as well as fine-tuned queries through a configurable selector. Once this connector is started, it will attempt to keep a persistent open connection to the JMS provider. If for any reason the connection is dropped, the connector will automatically reconnect without any intervention needed. The properties view also includes a mechanism to save configuration templates for common provider types, so that creating a new JMS Listener is as quick and easy as possible. Note: Depending on the JMS connection provider you are using, you may need to include some external libraries (JARs) as a Library Resource and include them using the Set Dependencies dialog on the Channel Summary tab. For example, to use connection templates included for ActiveMQ and JBoss, you should download the libraries from their official site in order to use

Editing Database Drivers

Recommendations

Database Reader

Adding a new entry to dbdrivers.xml

Database Writer

3.8.0 Upgrade Notes

Change Database Settings

JMS Listener

Database Reader

Adding a new entry to dbdrivers.xml

Database Writer

3.8.0 Upgrade Notes

Change Database Settings

JMS Listener