Adding a new entry to dbdrivers.xml

Mirth® Connect by NextGen Healthcare User Guide

dbdrivers.xml File

Note: This file is used by the and connectors to populate the Driver drop-down menu. The default values are as shown: <drivers> <driver class="sun.jdbc.odbc.JdbcOdbcDriver" name="Sun JDBC-ODBC Bridge" template="jdbc:odbc:DSN" selectLimit="" /> <driver class="com.mysql.jdbc.Driver" name="MySQL" template="jdbc:mysql://host:port/dbname" selectLimit="SELECT * FROM ? LIMIT 1" /> <driver class="oracle.jdbc.driver.OracleDriver" name="Oracle" template="jdbc:oracle:thin:@host:port:dbname" selectLimit="SELECT * FROM ? WHERE ROWNUM &lt; 2" /> <driver class="org.postgresql.Driver" name="PostgreSQL" template="jdbc:postgresql://host:port/d

Mirth® Connect by NextGen Healthcare User Guide

Editing Database Drivers

Select on the wrench icon next to the Driver text field. A new dialog will appear: From this dialog you can add/modify/remove the default drivers that will show up in the drop-down menu in Database Reader/Writer connectors. The following properties are used: 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 sele

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

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

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

Library Resources

Resources are shared services that can be used in specific channels / connectors or in other places throughout the Mirth® Connect server. They may include custom Java libraries to use within scripts, or services to handle outbound connections. The Library Resources tab allows you to include resources throughout your entire channel, or in more specific contexts such as the channel scripts or certain connectors. The Library Context tree in the top section of the tab allows you to select a specific context, or the Channel root-level node which represents all contexts across your channel at once. The following library contexts are available: Library Context Description Channel This is the root-level node of the tree, and includes all contexts below it. If one of the resource check boxes in the table below is in the indeterminate state (grey box), it means that it is currently included on some but not all of the sub-contexts. Channel Scripts This includes the deploy, undeploy, preprocessor,

Adding a new entry to dbdrivers.xml

Recommendations

dbdrivers.xml File

Editing Database Drivers

Database Writer

Database Reader

3.8.0 Upgrade Notes

Library Resources

dbdrivers.xml File

Editing Database Drivers

Database Writer

Database Reader

3.8.0 Upgrade Notes

Library Resources