web stats
how to insert to MySQL database - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2007, 11:43 AM
julia1231 julia1231 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 46
julia1231
Default how to insert to MySQL database

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(&apos;set_id&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.1&apos;]</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(&apos;patient_id&apos;, validate(msg[&apos;PID&apos;][&apos;PID.3&apos;][&apos;CX.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PID&apos;][&apos;PID.3&apos;][&apos;CX.1&apos;]</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(&apos;patient_class&apos; , validate(msg[&apos;PV1&apos;][&apos;PV1.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.2&apos;]</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(&apos;assigned_location_p oint_of_care&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.1&apos;]</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(&apos;assigned_location_r oom&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.2&apos;]</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(&apos;assigned_location_b ed&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.3&apos;]</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(&apos;assigned_location_f acility_name&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;]</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(&apos;assigned_location_f acility_id&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;]</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(&apos;assigned_location_s tatus&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.5&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.5&apos;]</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(&apos;assigned_location_t ype&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.6&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.6&apos;]</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(&apos;assigned_location_b uilding&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.7&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.7&apos;]</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(&apos;assigned_location_d escription&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.9&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.9&apos;]</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(&apos;assigned_location_f loor&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.8&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.3&apos;][&apos;PL.8&apos;]</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(&apos;admission_type&apos ;, validate(msg[&apos;PV1&apos;][&apos;PV1.4&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.4&apos;]</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(&apos;preadmit_number&apo s;, validate(msg[&apos;PV1&apos;][&apos;PV1.5&apos;][&apos;CX.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.5&apos;][&apos;CX.1&apos;]</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(&apos;prior_location_poin t_of_care&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.1&apos;]</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(&apos;prior_location_room &apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.2&apos;]</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(&apos;prior_location_bed& apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.3&apos;]</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(&apos;prior_location_faci lity_name&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;]</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(&apos;prior_location_faci lity_id&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;]</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(&apos;prior_location_stat us&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.5&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.5&apos;]</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(&apos;prior_location_type &apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.6&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.6&apos;]</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(&apos;prior_location_buil ding&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.7&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.7&apos;]</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(&apos;prior_location_floo r&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.8&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.8&apos;]</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(&apos;prior_location_desc ription&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.9&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.6&apos;][&apos;PL.9&apos;]</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(&apos;attending_doctor_id &apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.1&apos;]</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(&apos;attending_doctor_su rname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.2&apos;]</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(&apos;attending_doctor_fi rstname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.3&apos;]</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(&apos;attending_doctor_mi ddleinitial&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.4&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.7&apos;][&apos;XCN.4&apos;]</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(&apos;referring_doctor_id &apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.1&apos;]</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(&apos;referring_doctor_su rname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.2&apos;]</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(&apos;referring_doctor_fi rstname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.3&apos;]</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(&apos;referring_doctor_mi ddleinitial&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.4&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.8&apos;][&apos;XCN.4&apos;]</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(&apos;consulting_doctor_i d&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.1&apos;]</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(&apos;consulting_doctor_s urname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.2&apos;]</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(&apos;consulting_doctor_f irstname&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.3&apos;]</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(&apos;consulting_doctor_m iddleinitial&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.4&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.9&apos;][&apos;XCN.4&apos;]</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(&apos;hospital_service&ap os;, validate(msg[&apos;PV1&apos;][&apos;PV1.10&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.10&apos;]</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(&apos;temporary_location_ point_of_care&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.1&apos;]</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(&apos;temporary_location_ room&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.2&apos;]</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(&apos;temporary_location_ bed&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.3&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.3&apos;]</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(&apos;temporary_location_ facility_name&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.4&apos;][&apos;HD.1&apos;]</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(&apos;temporary_location_ facility_id&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.4&apos;][&apos;HD.2&apos;]</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(&apos;temporary_location_ status&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.5&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.5&apos;]</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(&apos;temporary_location_ type&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.6&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.6&apos;]</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(&apos;temporary_location_ building&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.7&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.7&apos;]</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(&apos;temporary_location_ floor&apos;, validate(msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.8&apos;], &apos;&apos;, new Array()));</script>
<type>Mapper</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg[&apos;PV1&apos;][&apos;PV1.11&apos;][&apos;PL.8&apos;]</string>
</entry>
<entry>
<string>Variable</string>
<string>temporary_location_floor</string>
</entry>
<entry>
<string>RegularExpressions</string>
<list/>
</entry>
<entry>
<string>DefaultValue</string>
<string></string>
Reply With Quote
  #2  
Old 03-23-2007, 11:57 AM
nshaik nshaik is offline
Mirth Guru
 
Join Date: Sep 2006
Posts: 302
nshaik
Default 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!
Reply With Quote
  #3  
Old 03-23-2007, 12:48 PM
julia1231 julia1231 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 46
julia1231
Default 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...
Reply With Quote
  #4  
Old 03-26-2007, 08:26 AM
julia1231 julia1231 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 46
julia1231
Default 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.
Reply With Quote
  #5  
Old 03-26-2007, 01:15 PM
nshaik nshaik is offline
Mirth Guru
 
Join Date: Sep 2006
Posts: 302
nshaik
Default 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!
Reply With Quote
  #6  
Old 03-27-2007, 01:17 PM
julia1231 julia1231 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 46
julia1231
Default 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
Reply With Quote
  #7  
Old 03-27-2007, 07:57 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: how to insert to MySQL database

Glad it's all working Julia and thanks Nazir for all the help!!!
__________________
Chris Lang
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Geting last insert ID deltoideus Support 9 09-02-2010 09:57 PM
Helper function to insert segments Alexander Support 0 05-01-2008 07:39 PM
"Update" instead of "insert" on MySQL Database Svetlomir Kasabov Support 12 02-20-2008 05:08 AM
Using nextval() and multiple insert statements r_kerry Support 3 02-11-2008 03:17 PM
Insert a delay between messages csaccavini Support 0 01-28-2008 02:25 AM


All times are GMT -8. The time now is 12:13 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation