Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many 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

Hooking up "non-supported" database for writing

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

  • Hooking up "non-supported" database for writing

    We work with Sybase Advantage Database Server. There is a java driver which I have installed and done the CLASSPATH mods.
    I just need another set of eyes to determine if I have set the destination correctly.
    I used the MySQL connector, the clicked on Javascript.
    Does this look right?
    Code:
    var dbConn = DatabaseConnectionFactory.createDatabaseConnection('com.extendedsystems.jdbc.advantage.ADSDriver','jdbc:extendedsystems:advantage://compulink1:6262/IHE/cbsdata.add','adssys','');
    var expression = "INSERT IGNORE INTO HL7Temp ( message ) values ('"+$(message.rawData)+"')";
    var result = dbConn.executeUpdate(expression);
    The error I get is
    Code:
    ERROR-406: JDBC Connector error
    ERROR MESSAGE:	Error writing to database: 
    org.mozilla.javascript.WrappedException: Wrapped java.sql.SQLException: No suitable driver found for jdbc:extendedsystems:advantage://compulink1:6262/IHE/cbsdata.add (279d9272-97cc-4f8c-9186-1af18181280b#2)
    	at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1693)
    	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:157)
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:201)
    	at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:84)
    	at org.mozilla.javascript.gen.c379._c6(279d9272-97cc-4f8c-9186-1af18181280b:2)
    	at org.mozilla.javascript.gen.c379.call(279d9272-97cc-4f8c-9186-1af18181280b)
    	at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:106)
    	at org.mozilla.javascript.gen.c379._c0(279d9272-97cc-4f8c-9186-1af18181280b:9)
    	at org.mozilla.javascript.gen.c379.call(279d9272-97cc-4f8c-9186-1af18181280b)
    	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:337)
    	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2755)
    	at org.mozilla.javascript.gen.c379.call(279d9272-97cc-4f8c-9186-1af18181280b)
    	at org.mozilla.javascript.gen.c379.exec(279d9272-97cc-4f8c-9186-1af18181280b)
    	at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:97)
    	at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:157)
    	at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:166)
    	at org.mule.impl.MuleSession.sendEvent(MuleSession.java:191)
    	at org.mule.impl.MuleSession.sendEvent(MuleSession.java:130)
    	at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:85)
    	at org.mule.routing.outbound.FilteringMulticastingRouter.route(FilteringMulticastingRouter.java:89)
    	at org.mule.routing.outbound.OutboundMessageRouter$1.doInTransaction(OutboundMessageRouter.java:78)
    	at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:48)
    	at org.mule.routing.outbound.OutboundMessageRouter.route(OutboundMessageRouter.java:82)
    	at org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:247)
    	at org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:209)
    	at org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:277)
    	at org.mule.impl.MuleSession.sendEvent(MuleSession.java:201)
    	at org.mule.routing.inbound.InboundMessageRouter.send(InboundMessageRouter.java:161)
    	at org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:128)
    	at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:492)
    	at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:271)
    	at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:230)
    	at com.webreach.mirth.connectors.file.FileMessageReceiver.processFile(FileMessageReceiver.java:208)
    	at com.webreach.mirth.connectors.file.FileMessageReceiver.poll(FileMessageReceiver.java:130)
    	at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:118)
    	at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
    	at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
    	at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
    	at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: No suitable driver found for jdbc:extendedsystems:advantage://compulink1:6262/IHE/cbsdata.add
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at com.webreach.mirth.server.util.DatabaseConnection.<init>(DatabaseConnection.java:65)
    	at com.webreach.mirth.server.util.DatabaseConnectionFactory.createDatabaseConnection(DatabaseConnectionFactory.java:65)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    	at java.lang.reflect.Method.invoke(Unknown Source)
    	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:142)
    	... 37 more
Working...
X