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

java.sql.SQLException

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

  • java.sql.SQLException

    Hello to all,

    I'm using Mirth 1.7.1.3422, i'm taking incoming HL7 messages and write them to a Oracle Database 10g Express Edition Database. The Connection to the DB is good.

    But when a try to write a message in the table "patient',i get following error:

    [[email protected] mirth-1.7.1.3422]# ./mirth.sh
    Mirth 1.7.1.3422 (April 23, 2008) server successfully started: Wed Jun 11 11:59:06 GMT-01:00 2008
    This product includes software developed by SymphonySoft Limited (http://www.symphonysoft.com) and its contributors.
    Running Java 1.5.0_12 on Linux (2.6.18-92.el5, i386)
    ERROR 2008-06-11 11:59:26,269 [_vmConnector#11724626.5a2d27f1-4061-42e2-9759-c729d84fae18.receiver.1] org.mule.impl.DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 5a2d27f1-4061-42e2-9759-c729d84fae18: java.sql.SQLException: Invalid column index Query: INSERT IGNORE INTO patient (message_date,vorname,nachname,birthday) values ('?','?','?','?'); Parameters: [20080610000904, Xy, Xy, 19610919000000]
    java.sql.SQLException: Invalid column index Query: INSERT IGNORE INTO patient (message_date,vorname,nachname,birthday) values ('?','?','?','?'); Parameters: [20080610000904, Walter, Pertl, 19610919000000]
    at org.apache.commons.dbutils.QueryRunner.rethrow(Que ryRunner.java:359)
    at org.apache.commons.dbutils.QueryRunner.update(Quer yRunner.java:428)
    at com.webreach.mirth.connectors.jdbc.JdbcMessageDisp atcher.doDispatch(JdbcMessageDispatcher.java:130)
    at com.webreach.mirth.connectors.jdbc.JdbcMessageDisp atcher.doSend(JdbcMessageDispatcher.java:157)
    at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:166)
    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(AbstractOutboundRouter.java:85)
    at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:89)
    at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
    at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
    at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
    at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
    at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
    at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
    at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
    at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:161)
    at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:128)
    at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:493)
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:272)
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:231)
    at com.webreach.mirth.connectors.vm.VMMessageReceiver .getMessages(VMMessageReceiver.java:157)
    at org.mule.providers.TransactedPollingMessageReceive r.poll(TransactedPollingMessageReceiver.java:108)
    at org.mule.providers.PollingMessageReceiver.run(Poll ingMessageReceiver.java:118)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Thread.java:595)


    Can someone give me some ideas on how to get around this.

    fossl33

  • #2
    Re:java.sql.SQLException

    It looks like the problem is with the query itself.

    Code:
    java.sql.SQLException: Invalid column index Query: INSERT IGNORE INTO patient (message_date,vorname,nachname,birthday) values ('?','?','?','?'); Parameters: [20080610000904, Walter, Pertl, 19610919000000]
    I'm not familiar with Oracle, but are the dates formatted correctly?? Are the strings supposed to be quoted??

    Viel gluck!
    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.

    Comment


    • #3
      Re:java.sql.SQLException

      searching google, I've found this:
      http://mail-archives.apache.org/mod_...l.gmail.com%3E

      Seems that this error happens when one or more of the parameters passed to the insert is null. Also, as jbartels said you should try to use the TODATE() oracle function to convert the dates into a valid date format.

      Comment


      • #4
        Re:java.sql.SQLException

        hi to all,

        found the failure in the sql statement :

        INSERT IGNORE INTO patient (message_date,vorname,nachname,birthday) values ('?','?','?','?');

        oracle have a problem with the comma after the statement -

        INSERT IGNORE INTO patient (message_date,vorname,nachname,birthday) values ('?','?','?','?')


        thanks for your hints

        Comment

        Working...
        X