how to insert to MySQL database

Mirth Connect 4.0.1 Released!

Mirth Connect 4.0.1 is now available as an appliance update and on our GitHub page. Mirth Connect 4.0.1 is a patch release containing a bug fix which includes fixing a Jetty keystore regression that caused Connect servers using a PKCS12 keystore containing a wildcard certificate and/or a certificate with a SAN to throw an exception on startup. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.

See less

julia1231

OBX.1 Kenobi

Join Date: Mar 2007

Posts: 46
- Share
- Tweet
#1

how to insert to MySQL database

03-23-2007, 10:43 AM

I am inserting 1 field from hl7 message into a table in my database.
How do I test the connection between MySQL database and mirth?
thanks,
This is the error I am getting:
-------------------------------------------------

ERROR-406: JDBC Connector error
ERROR MESSAGE: Error writing to database:
java.sql.SQLException: Access denied for user 'lexus1'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2941)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:868)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3340)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 38)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2743)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc Connector.getConnection(JdbcConnector.java:452)
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageDispatcher.doDispatch(JdbcMessageDispatcher .java:121)
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageDispatcher.doSend(JdbcMessageDispatcher.jav a:146)
at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:166)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:191)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:130)
at org.mule.routing.outbound.AbstractOutboundRouter.s end(AbstractOutboundRouter.java:85)
at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:89)
at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:161)
at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:128)
at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:492)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:271)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:230)
at com.webreach.mirth.server.mule.providers.file.File MessageReceiver.processFile(FileMessageReceiver.ja va:186)
at com.webreach.mirth.server.mule.providers.file.File MessageReceiver.poll(FileMessageReceiver.java:114)
at org.mule.providers.PollingMessageReceiver.run(Poll ingMessageReceiver.java:73)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)

--------------------------------
this is my channel
---------------------------------
<com.webreach.mirth.model.Channel>
<id>e0016292-ea4c-48ae-8355-c302194a2a0b</id>
<name>HL7_TO_DB</name>
<description></description>
<enabled>true</enabled>
<version>1.4.0</version>
<revision>17</revision>
<sourceConnector>
<name>sourceConnector</name>
<properties>
<property name="sortAttribute">date</property>
<property name="pollingFrequency">1000</property>
<property name="binary">0</property>
<property name="processBatchFiles">1</property>
<property name="DataType">File Reader</property>
<property name="fileAge">0</property>
<property name="moveToPattern"></property>
<property name="charsetEncoding">DEFAULT_ENCODING</property>
<property name="checkFileAge">0</property>
<property name="autoDelete">0</property>
<property name="host">C:/ADT</property>
<property name="fileFilter">*.hl7</property>
<property name="moveToDirectory"></property>
</properties>
<transformer>
<steps>
<com.webreach.mirth.model.Step>
<sequenceNumber>0</sequenceNumber>
<name>set_id</name>
<script>connectorMap.put('set_id', validate(msg['PV1']['PV1.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>set_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>isGlobal</string>
<string>connector</string>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>1</sequenceNumber>
<name>patient_id</name>
<script>channelMap.put('patient_id', validate(msg['PID']['PID.3']['CX.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PID']['PID.3']['CX.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>patient_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
<entry>
<string>isGlobal</string>
<string>channel</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>2</sequenceNumber>
<name>patient_class</name>
<script>channelMap.put('patient_class' , validate(msg['PV1']['PV1.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>patient_class</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
<entry>
<string>isGlobal</string>
<string>channel</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>3</sequenceNumber>
<name>assigned_location_point_of_care</name>
<script>connectorMap.put('assigned_location_p oint_of_care', validate(msg['PV1']['PV1.3']['PL.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_point_of_care</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
<entry>
<string>isGlobal</string>
<string>connector</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>4</sequenceNumber>
<name>assigned_location_room</name>
<script>connectorMap.put('assigned_location_r oom', validate(msg['PV1']['PV1.3']['PL.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_room</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>5</sequenceNumber>
<name>assigned_location_bed</name>
<script>connectorMap.put('assigned_location_b ed', validate(msg['PV1']['PV1.3']['PL.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_bed</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>6</sequenceNumber>
<name>assigned_location_facility_name</name>
<script>connectorMap.put('assigned_location_f acility_name', validate(msg['PV1']['PV1.3']['PL.4']['HD.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.4']['HD.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_facility_name</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>7</sequenceNumber>
<name>assigned_location_facility_id</name>
<script>connectorMap.put('assigned_location_f acility_id', validate(msg['PV1']['PV1.3']['PL.4']['HD.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.4']['HD.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_facility_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>8</sequenceNumber>
<name>assigned_location_status</name>
<script>connectorMap.put('assigned_location_s tatus', validate(msg['PV1']['PV1.3']['PL.5'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.5']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_status</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>9</sequenceNumber>
<name>assigned_location_type</name>
<script>connectorMap.put('assigned_location_t ype', validate(msg['PV1']['PV1.3']['PL.6'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.6']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_type</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>10</sequenceNumber>
<name>assigned_location_building</name>
<script>connectorMap.put('assigned_location_b uilding', validate(msg['PV1']['PV1.3']['PL.7'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.7']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_building</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>11</sequenceNumber>
<name>assigned_location_description</name>
<script>connectorMap.put('assigned_location_d escription', validate(msg['PV1']['PV1.3']['PL.9'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.9']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_description</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>12</sequenceNumber>
<name>assigned_location_floor</name>
<script>connectorMap.put('assigned_location_f loor', validate(msg['PV1']['PV1.3']['PL.8'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.3']['PL.8']</string>
</entry>
<entry>
<string>Variable</string>
<string>assigned_location_floor</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>13</sequenceNumber>
<name>admission_type</name>
<script>connectorMap.put('admission_type&apos ;, validate(msg['PV1']['PV1.4'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.4']</string>
</entry>
<entry>
<string>Variable</string>
<string>admission_type</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>14</sequenceNumber>
<name>preadmit_number</name>
<script>connectorMap.put('preadmit_number&apo s;, validate(msg['PV1']['PV1.5']['CX.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.5']['CX.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>preadmit_number</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>15</sequenceNumber>
<name>prior_location_point_of_care</name>
<script>connectorMap.put('prior_location_poin t_of_care', validate(msg['PV1']['PV1.6']['PL.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_point_of_care</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>16</sequenceNumber>
<name>prior_location_room</name>
<script>connectorMap.put('prior_location_room ', validate(msg['PV1']['PV1.6']['PL.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_room</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>17</sequenceNumber>
<name>prior_location_bed</name>
<script>connectorMap.put('prior_location_bed& apos;, validate(msg['PV1']['PV1.6']['PL.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_bed</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>18</sequenceNumber>
<name>prior_location_facility_name</name>
<script>connectorMap.put('prior_location_faci lity_name', validate(msg['PV1']['PV1.6']['PL.4']['HD.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.4']['HD.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_facility_name</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>19</sequenceNumber>
<name>prior_location_facility_id</name>
<script>connectorMap.put('prior_location_faci lity_id', validate(msg['PV1']['PV1.6']['PL.4']['HD.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.4']['HD.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_facility_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>20</sequenceNumber>
<name>prior_location_status</name>
<script>connectorMap.put('prior_location_stat us', validate(msg['PV1']['PV1.6']['PL.5'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.5']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_status</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>21</sequenceNumber>
<name>prior_location_type</name>
<script>connectorMap.put('prior_location_type ', validate(msg['PV1']['PV1.6']['PL.6'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.6']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_type</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>22</sequenceNumber>
<name>prior_location_building</name>
<script>connectorMap.put('prior_location_buil ding', validate(msg['PV1']['PV1.6']['PL.7'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.7']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_building</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>23</sequenceNumber>
<name>prior_location_floor</name>
<script>connectorMap.put('prior_location_floo r', validate(msg['PV1']['PV1.6']['PL.8'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.8']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_floor</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>24</sequenceNumber>
<name>prior_location_description</name>
<script>connectorMap.put('prior_location_desc ription', validate(msg['PV1']['PV1.6']['PL.9'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.6']['PL.9']</string>
</entry>
<entry>
<string>Variable</string>
<string>prior_location_description</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>25</sequenceNumber>
<name>attending_doctor_id</name>
<script>connectorMap.put('attending_doctor_id ', validate(msg['PV1']['PV1.7']['XCN.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.7']['XCN.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>attending_doctor_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>26</sequenceNumber>
<name>attending_doctor_surname</name>
<script>connectorMap.put('attending_doctor_su rname', validate(msg['PV1']['PV1.7']['XCN.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.7']['XCN.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>attending_doctor_surname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>27</sequenceNumber>
<name>attending_doctor_firstname</name>
<script>connectorMap.put('attending_doctor_fi rstname', validate(msg['PV1']['PV1.7']['XCN.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.7']['XCN.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>attending_doctor_firstname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>28</sequenceNumber>
<name>attending_doctor_middleinitial</name>
<script>connectorMap.put('attending_doctor_mi ddleinitial', validate(msg['PV1']['PV1.7']['XCN.4'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.7']['XCN.4']</string>
</entry>
<entry>
<string>Variable</string>
<string>attending_doctor_middleinitial</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>29</sequenceNumber>
<name>referring_doctor_id</name>
<script>connectorMap.put('referring_doctor_id ', validate(msg['PV1']['PV1.8']['XCN.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.8']['XCN.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>referring_doctor_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>30</sequenceNumber>
<name>referring_doctor_surname</name>
<script>connectorMap.put('referring_doctor_su rname', validate(msg['PV1']['PV1.8']['XCN.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.8']['XCN.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>referring_doctor_surname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>31</sequenceNumber>
<name>referring_doctor_firstname</name>
<script>connectorMap.put('referring_doctor_fi rstname', validate(msg['PV1']['PV1.8']['XCN.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.8']['XCN.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>referring_doctor_firstname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>32</sequenceNumber>
<name>referring_doctor_middleinitial</name>
<script>connectorMap.put('referring_doctor_mi ddleinitial', validate(msg['PV1']['PV1.8']['XCN.4'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.8']['XCN.4']</string>
</entry>
<entry>
<string>Variable</string>
<string>referring_doctor_middleinitial</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>33</sequenceNumber>
<name>consulting_doctor_id</name>
<script>connectorMap.put('consulting_doctor_i d', validate(msg['PV1']['PV1.9']['XCN.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.9']['XCN.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>consulting_doctor_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>34</sequenceNumber>
<name>consulting_doctor_surname</name>
<script>connectorMap.put('consulting_doctor_s urname', validate(msg['PV1']['PV1.9']['XCN.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.9']['XCN.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>consulting_doctor_surname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>35</sequenceNumber>
<name>consulting_doctor_firstname</name>
<script>connectorMap.put('consulting_doctor_f irstname', validate(msg['PV1']['PV1.9']['XCN.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.9']['XCN.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>consulting_doctor_firstname</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>36</sequenceNumber>
<name>consulting_doctor_middleinitial</name>
<script>connectorMap.put('consulting_doctor_m iddleinitial', validate(msg['PV1']['PV1.9']['XCN.4'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.9']['XCN.4']</string>
</entry>
<entry>
<string>Variable</string>
<string>consulting_doctor_middleinitial</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>37</sequenceNumber>
<name>hospital_service</name>
<script>connectorMap.put('hospital_service&ap os;, validate(msg['PV1']['PV1.10'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.10']</string>
</entry>
<entry>
<string>Variable</string>
<string>hospital_service</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>38</sequenceNumber>
<name>temporary_location_point_of_care</name>
<script>connectorMap.put('temporary_location_ point_of_care', validate(msg['PV1']['PV1.11']['PL.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_point_of_care</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>39</sequenceNumber>
<name>temporary_location_room</name>
<script>connectorMap.put('temporary_location_ room', validate(msg['PV1']['PV1.11']['PL.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_room</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>40</sequenceNumber>
<name>temporary_location_bed</name>
<script>connectorMap.put('temporary_location_ bed', validate(msg['PV1']['PV1.11']['PL.3'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.3']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_bed</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>41</sequenceNumber>
<name>temporary_location_facility_name</name>
<script>connectorMap.put('temporary_location_ facility_name', validate(msg['PV1']['PV1.11']['PL.4']['HD.1'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.4']['HD.1']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_facility_name</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>42</sequenceNumber>
<name>temporary_location_facility_id</name>
<script>connectorMap.put('temporary_location_ facility_id', validate(msg['PV1']['PV1.11']['PL.4']['HD.2'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.4']['HD.2']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_facility_id</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>43</sequenceNumber>
<name>temporary_location_status</name>
<script>connectorMap.put('temporary_location_ status', validate(msg['PV1']['PV1.11']['PL.5'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.5']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_status</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>44</sequenceNumber>
<name>temporary_location_type</name>
<script>connectorMap.put('temporary_location_ type', validate(msg['PV1']['PV1.11']['PL.6'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.6']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_type</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>45</sequenceNumber>
<name>temporary_location_building</name>
<script>connectorMap.put('temporary_location_ building', validate(msg['PV1']['PV1.11']['PL.7'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.7']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_building</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>46</sequenceNumber>
<name>temporary_location_floor</name>
<script>connectorMap.put('temporary_location_ floor', validate(msg['PV1']['PV1.11']['PL.8'], '', new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['PV1']['PV1.11']['PL.8']</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_floor</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
Tags: None
nshaik

Mirth Guru

Join Date: Sep 2006

Posts: 302
- Share
- Tweet
#2

03-23-2007, 10:57 AM

Re: how to insert to MySQL database

It looks like the database login id does not have permission to access the database. Could you possibly try connecting to the database from some other application with the same database login id and password? Also, if the login goes through, try to do the same database operation you are trying from Mirth (Insert or update to the table). This would help confirm that the database connection works fine and the login id has the required permission on the database object.

Hope it helps!
Comment
julia1231

OBX.1 Kenobi

Join Date: Mar 2007

Posts: 46
- Share
- Tweet
#3

03-23-2007, 11:48 AM

Re: how to insert to MySQL database

thanks!
It's my first time to use MySQL and I will try to find other application to connect to MySQL db.
The part I don't really understand is the jdbc connection. I setup the path with the jdbc driver, but not sure it's correct...
Comment
julia1231

OBX.1 Kenobi

Join Date: Mar 2007

Posts: 46
- Share
- Tweet
#4

03-26-2007, 07:26 AM

Re: how to insert to MySQL database

I tested with a MySQL GUI and figured out my connection name was invalid.
After fixing that, I am able to connect from mirth to MySQL.
thank you for the tip!
The other question I have is --> Does Mirth working with Microsoft SQL server?
We are actrally using MS SQl server 2005 and sql server 2000 and oracle 10g.
Comment
nshaik

Mirth Guru

Join Date: Sep 2006

Posts: 302
- Share
- Tweet
#5

03-26-2007, 12:15 PM

Re: how to insert to MySQL database

Glad you got it working with MySQL!

Mirth works fine with Microsoft SQL Server 2000.
[orange]
jdbc:jtds:sqlserver://TestServer:1433/TestDB
[/orange]
TestServer: Name of the SQL Server 2000 Server

TestDB: Database Name

Default Port is 1433 (Enterprise Manager / Right-click on server / General Tab / Network Configuration / TCP/IP / Properties)

I haven't tried with SQL Server 2005 yet but it should work fine. I have seen posts in this forum from users who use Mirth with Oracle.

Hope it helps!
Comment
julia1231

OBX.1 Kenobi

Join Date: Mar 2007

Posts: 46
- Share
- Tweet
#6

03-27-2007, 12:17 PM

Re: how to insert to MySQL database

I downloaded the jdbc driver for sqlserver 2005 and sqlserver2000. then load it.
I also checked the Default Port is 1433 in my machine; the next thing to do is setting up jdbc:jtds:sqlserver://TestServer:1433/TestDB at mirth and tested successfully.
thank you so much for the help!!

Julia
Comment
chrisl

Mirth Certified

Join Date: Aug 2006

Posts: 967
- Share
- Tweet
#7

03-27-2007, 06:57 PM

Re: how to insert to MySQL database

Glad it's all working Julia and thanks Nazir for all the help!!!

Chris Lang
Comment

Previous template Next

Announcement

Mirth Connect 4.0.1 Released!

how to insert to MySQL database

how to insert to MySQL database

Comment

Comment

Comment

Comment

Comment

Comment