web stats
EDIT:Is the JTDS driver packaged with Mirth 1.1 compatible with SQLServer 2005? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2006, 05:05 AM
jbartels jbartels is offline
Mirth Guru
 
Join Date: Oct 2006
Posts: 719
jbartels is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-24-2006, 05:58 AM
jbartels jbartels is offline
Mirth Guru
 
Join Date: Oct 2006
Posts: 719
jbartels is on a distinguished road
Default 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.
Reply With Quote
  #3  
Old 10-24-2006, 06:07 AM
jbartels jbartels is offline
Mirth Guru
 
Join Date: Oct 2006
Posts: 719
jbartels is on a distinguished road
Default 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` <> 'TEST';" /> 
  <property name="ack" value="UPDATE `inbound_hl7` SET `pd_lname` = 'TEST' 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.
Reply With Quote
  #4  
Old 10-24-2006, 08:07 AM
jbartels jbartels is offline
Mirth Guru
 
Join Date: Oct 2006
Posts: 719
jbartels is on a distinguished road
Default 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.
__________________
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.
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
No suitable driver Error - SQL Server 2005 RHavlick Support 1 02-03-2009 06:59 PM
how do you get Mirth 1.7.1 to work with SQL 2005 baziz Support 5 11-07-2008 11:24 AM
Mirth Service not starting with SQL Server 2005 Colizobble Support 2 06-20-2008 06:35 AM
Please help on compatible version kmthayil Support 4 09-13-2007 01:57 PM
NO suitable driver for sqlserver? shifting_18 Support 2 04-24-2007 10:08 PM


All times are GMT -8. The time now is 01:49 PM.


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