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

[jbartels]

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)

[jbartels]

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

[jbartels]

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

This is in /conf/mule-config.xml

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

[jbartels]

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've fixed the ID10T and PEBKAC errors, Mirth looks like a fantastic tool for us. I think we'll be able to use this instead of rolling our own HL7 Gateway for this application.