Announcement

Collapse
No announcement yet.

how to insert to MySQL database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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>

  • #2
    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


    • #3
      Re: how to insert to MySQL database

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

      Comment


      • #4
        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


        • #5
          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&#039;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


          • #6
            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


            • #7
              Re: how to insert to MySQL database

              Glad it&#039;s all working Julia and thanks Nazir for all the help!!!
              Chris Lang

              Comment

              Working...
              X