Announcement

Collapse
No announcement yet.

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