Announcement

Collapse
No announcement yet.

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