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

Error from DB reader: "stmt should be select

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

  • Error from DB reader: "stmt should be select

    Obviously my SQL statement is not a simple SELECT statement. Is this the correct behaviour? I can only have simple SELECT statements in the DB reader??

    Edit: I'm using 1.6.1

    Code:
    org.mule.umo.model.ModelException: Failed to register listener 195b33fe-913a-44e8-bd36-b4974273f5b2 on endpoint jdbc://query
    	at org.mule.impl.model.AbstractModel.registerListeners(AbstractModel.java:225)
    	at org.mule.impl.model.AbstractModel.start(AbstractModel.java:353)
    	at org.mule.MuleManager.start(MuleManager.java:730)
    	at org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:207)
    	at org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:194)
    	at com.webreach.mirth.server.Mirth.startMule(Mirth.java:229)
    	at com.webreach.mirth.server.Mirth.restartMule(Mirth.java:186)
    	at com.webreach.mirth.server.Mirth.run(Mirth.java:117)
    Caused by: java.lang.IllegalArgumentException: Read statement should be a select sql statement
    	at com.webreach.mirth.connectors.jdbc.JdbcConnector.getReadAndAckStatements(JdbcConnector.java:279)
    	at com.webreach.mirth.connectors.jdbc.JdbcConnector.createReceiver(JdbcConnector.java:170)
    	at org.mule.providers.AbstractConnector.registerListener(AbstractConnector.java:514)
    	at org.mule.impl.model.AbstractModel.registerListeners(AbstractModel.java:221)
    Post edited by: jbartels, at: 02/12/2008 10:10
    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.
Working...
X