NextGen (Mirth) Connect 3.9.1 Released!

NextGen (Mirth) Connect 3.9.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes and adds support for eHealth Exchange UDDI providers in the Interoperability plugin. 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

Error calling a Stored Procedure

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error calling a Stored Procedure

    Hi there!

    I have to call a stored procedure as I have to decide wether to select an row of a table or to insert a new once.

    My DB is MySQL so I ve to wrap my IF statements in procedures... Mirth throws this error when processing a message:

    Error writing to the database
    java.lang.IllegalArgumentException: Write statement should be an insert / update / delete sql statement
    at org.mule.providers.jdbc.JdbcMessageDispatcher.doDi spatch(
    at org.mule.providers.jdbc.JdbcMessageDispatcher.doSe nd(
    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 org.mule.providers.tcp.TcpMessageReceiver$TcpWorke r.processData(
    at org.mule.providers.tcp.TcpMessageReceiver$TcpWorke
    at .java:290)
    at eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at eadPoolExecutor$ :675)

    How can I call my procedure?

    Thanks in advance.


  • #2
    Re: Error calling a Stored Procedure

    Close thread as I found this solution

    Sorry for opening a double thread and thanks for a great piece of software.