Announcement

Collapse
No announcement yet.

EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005?

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

  • EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005?

    The topic says it: Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005? According to JTDS docs, yes it is.

    Question now is, why in the heck can't I connect?

    This is my connection string:
    jdbc:jtds:sqlserver://pm-db:1443;databaseName=triSTRUCT_hl7_gateway;doimain =CORP

    Any suggestions? Should [or how can] I utilize the Microsoft JDBC driver for 2005?

    When I start the channel I get this trace:
    com.webreach.mirth.client.core.ClientException: method failed: HTTP/1.1 500 java%2Ermi%2EUnmarshalException%3A+Error+unmarshal ing+return%3B+nested+exception+is%3A+%0A%09java%2E io%2EWriteAbortedException%3A+writing+aborted%3B+j ava%2Eio%2ENotSerializableException%3A+org%2Emule% 2Eproviders%2Ejdbc%2EJdbcConnector
    com.webreach.mirth.client.core.ServerConnection.ex ecutePostMethod(ServerConnection.java:59)
    com.webreach.mirth.client.core.Client.startChannel (Client.java:247)
    com.webreach.mirth.client.ui.Frame.doStart(Frame.j ava:1435)
    com.webreach.mirth.client.ui.Frame$28.actionPerfor med(Frame.java:717)
    javax.swing.AbstractButton.fireActionPerformed(Unk nown Source)
    javax.swing.AbstractButton$Handler.actionPerformed (Unknown Source)
    javax.swing.DefaultButtonModel.fireActionPerformed (Unknown Source)
    javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    javax.swing.AbstractButton.doClick(Unknown Source)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unk nown Source)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mou seReleased(Unknown Source)
    java.awt.Component.processMouseEvent(Unknown Source)
    javax.swing.JComponent.processMouseEvent(Unknown Source)
    java.awt.Component.processEvent(Unknown Source)
    java.awt.Container.processEvent(Unknown Source)
    java.awt.Component.dispatchEventImpl(Unknown Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.LightweightDispatcher.retargetMouseEvent( Unknown Source)
    java.awt.LightweightDispatcher.processMouseEvent(U nknown Source)
    java.awt.LightweightDispatcher.dispatchEvent(Unkno wn Source)
    java.awt.Container.dispatchEventImpl(Unknown Source)
    java.awt.Window.dispatchEventImpl(Unknown Source)
    java.awt.Component.dispatchEvent(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    java.awt.EventDispatchThread.pumpOneEventForHierar chy(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForHierarch y(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    java.awt.EventDispatchThread.run(Unknown Source)
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

  • #2
    Re: EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005?

    I added an entry to dbdrivers.xml for the Microsoft issued JDBC SQL Server driver and tried it. Still getting errors.

    The JTDS error seems to come down to "java.sql.SQLException: No suitable driver". Still tracing thru the MS Errors.

    The MS driver connection string is: jdbc:sqlserver://pm-db;databaseName=triSTRUCT_hl7_gateway;integratedSe curity=true

    The JTDS connection string is:
    jdbc:jtds:sqlserver://pm-db/triSTRUCT_hl7_gateway;doimain=CORP
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment


    • #3
      Re: EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005?

      This is in /conf/mule-config.xml

      Code:
      <connector className="org.mule.providers.jdbc.JdbcConnector" name="2_source">
      - <properties>
        <property name="pollingFrequency" value="5000" /> 
        <property name="username" value="root" /> 
        <property name="useAck" value="0" /> 
        <property name="URL" value="\\pm-db/mirth" /> 
        <property name="password" value="root" /> 
        <property name="driver" value="net.sourceforge.jtds.jdbc.Driver" /> 
      - <map name="queries">
        <property name="query" value="SELECT `pd_lname`, `pd_row_no`, `pd_fname` FROM `inbound_hl7` WHERE `pd_lname` <> &#039;TEST&#039;;" /> 
        <property name="ack" value="UPDATE `inbound_hl7` SET `pd_lname` = &#039;TEST&#039; WHERE `pd_row_no` = ${pd_row_no}" /> 
        </map>
        </properties>
        </connector>
      I never set that URL, username, and password. Should I edit the file directly or is there a config tool/option that I need to use?
      Jon Bartels

      Zen is hiring!!!!
      http://consultzen.com/careers/
      Talented healthcare IT professionals wanted. Engineers to sales to management.
      Good benefits, great working environment, genuinely interesting work.

      Comment


      • #4
        Re: EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005?

        Found it. jdbc:jtds:sqlserver://pm-db/triSTRUCT_hl7_gateway;doimain=CORP

        Now that I&#039;ve fixed the ID10T and PEBKAC errors, Mirth looks like a fantastic tool for us. I think we&#039;ll be able to use this instead of rolling our own HL7 Gateway for this application.
        Jon Bartels

        Zen is hiring!!!!
        http://consultzen.com/careers/
        Talented healthcare IT professionals wanted. Engineers to sales to management.
        Good benefits, great working environment, genuinely interesting work.

        Comment

        Working...
        X