Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

JDBC Connector error and Error writing to databas

  • Filter
  • Time
  • Show
Clear All
new posts

  • JDBC Connector error and Error writing to databas

    Please help me. I am using Windows Server 2003R2, SQLExpress2005. I am using Mirth 1.5
    Source: FileReader, read a .hl7 file

    Destination: Connecter Type: DatabaseWriter; Driver: SQL Server/Sybase; URL: jdbc:jtds:sqlserver://localhost:2301/Test
    SQL: INSERT IGNORE INTO Test(name) VALUES(${name})

    Transformer: Variable: name
    Mapping: tmp['PID']['PID.5']['PID.5.1']

    Can you please show me how to solve my problem with the error I got:

    ERROR-406: JDBC Connector error
    ERROR MESSAGE: Error writing to database:
    java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.ja va:611)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(C
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:178)
    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(
    at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageDispatcher.doDispatch(JdbcMessageDispatcher .java:122)
    at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageDispatcher.doSend(JdbcMessageDispatcher.jav a:149)
    at org.mule.providers.AbstractMessageDispatcher.send(
    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(
    at org.mule.routing.outbound.FilteringMulticastingRou ter.route(
    at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(
    at org.mule.transaction.TransactionTemplate.execute(T
    at ute(
    at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul
    at org.mule.impl.model.seda.SedaComponent.doSend(Seda
    at org.mule.impl.model.AbstractComponent.sendEvent(Ab
    at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
    at org.mule.routing.inbound.InboundMessageRouter.send (
    at org.mule.routing.inbound.InboundMessageRouter.rout e(
    at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(
    at com.webreach.mirth.server.mule.providers.file.File MessageReceiver.processFile(FileMessageReceiver.ja va:183)
    at com.webreach.mirth.server.mule.providers.file.File MessageReceiver.poll(
    at .java:290)
    at eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at eadPoolExecutor$ :675)
    at Source)
    Caused by: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
    at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(T
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.ja va:584)

  • #2
    Re:JDBC Connector error and Error writing to databas

    Let's look at the first error message "ERROR-406: JDBC Connector error"
    1. Is your database up and running (with correct Port number)?
    2. Check username and password (Not sure with Express but in my SQL db I have to use SQL Authentication instead of Windows e.g. use "sa" as the user name and the password that you created for it.) I believe that if you do not supply a user name and a password jtds will attempt to use your windows credentials. Someone will correct me if i am wrong...hopefully.