java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement.

Mirth Project | Eric Butterfield | 7 years ago
  1. 0

    When using the Database Writer in SQL mode, comments will cause the following exception: [2009-12-16 14:10:43,731] ERROR (org.mule.impl.DefaultComponentExceptionStrategy:95): Caught exception in Exception Strategy for: 14c4cf95-4531-4fa4-a172-85774fd9a70a: java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement. java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement. at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:110) at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:139) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:167) 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:52) 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:180) at org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:147) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:493) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:272) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:244) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processHL7Data(MllpMessageReceiver.java:476) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processData(MllpMessageReceiver.java:436) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.run(MllpMessageReceiver.java:353) 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(Thread.java:619) This is in spite of the fact that the syntax highlighter highlights the comments as if they are valid. It would be a nice feature if you were able to use comments in your SQL code. I'm assuming the SQL contexts in the Database Reader behave the same, although I have not tested it.

    Mirth Project | 7 years ago | Eric Butterfield
    java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement.
  2. 0

    When using the Database Writer in SQL mode, comments will cause the following exception: [2009-12-16 14:10:43,731] ERROR (org.mule.impl.DefaultComponentExceptionStrategy:95): Caught exception in Exception Strategy for: 14c4cf95-4531-4fa4-a172-85774fd9a70a: java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement. java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement. at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:110) at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:139) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:167) 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:52) 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:180) at org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:147) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:493) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:272) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:244) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processHL7Data(MllpMessageReceiver.java:476) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processData(MllpMessageReceiver.java:436) at com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.run(MllpMessageReceiver.java:353) 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(Thread.java:619) This is in spite of the fact that the syntax highlighter highlights the comments as if they are valid. It would be a nice feature if you were able to use comments in your SQL code. I'm assuming the SQL contexts in the Database Reader behave the same, although I have not tested it.

    Mirth Project | 7 years ago | Eric Butterfield
    java.lang.IllegalArgumentException: Write statement should be an INSERT, UPDATE, or DELETE SQL statement.
  3. 0

    Here is the basic problem, i have been using mu1e 1.3 rc 4 for a while now, i had a couple of endpoints using jdbc, axis connectors setup. I recently moved to mule 1.4.1, my endpoints using the axis connectors all worked, but the ones connecting using the jdbc connectors are all failing. 16:26:43,585 ERROR [MuleManagerComponent] Failed to process admin request: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:251) at org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604) at org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:326) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:208) at org.mule.impl.MuleEventContext.sendEvent(MuleEventContext.java:247) at org.mule.impl.internal.admin.MuleManagerComponent.sendAction(MuleManagerComponent.java:175) at org.mule.impl.internal.admin.MuleManagerComponent.onCall(MuleManagerComponent.java:95) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.mule.impl.model.resolvers.DynamicEntryPoint.invokeMethod(DynamicEntryPoint.java:313) at org.mule.impl.model.resolvers.DynamicEntryPoint.invoke(DynamicEntryPoint.java:260) at org.mule.impl.DefaultLifecycleAdapter.intercept(DefaultLifecycleAdapter.java:194) at org.mule.impl.InterceptorsInvoker.execute(InterceptorsInvoker.java:47) at org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:257) at org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:408) at org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:418) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:348) at org.mule.routing.inbound.InboundRouterCollection.send(InboundRouterCollection.java:197) at org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:163) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:268) at org.mule.providers.http.HttpMessageReceiver$HttpWorker.run(HttpMessageReceiver.java:269) at org.mule.impl.work.WorkerContext.run(WorkerContext.java:310) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528) at java.lang.Thread.run(Thread.java:619) Caused by: org.mule.umo.routing.RoutingException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='endpoint.vm.getAllQuizzes', type='receiver', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=null, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.routing.inbound.ForwardingConsumer.process(ForwardingConsumer.java:66) at org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:86) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:250) at org.mule.providers.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:105) at org.mule.providers.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:193) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223) ... 29 more Caused by: org.mule.umo.routing.RoutingException: Failed to route event via endpoint: null. Message payload is of type: HashMap at org.mule.routing.outbound.OutboundRouterCollection.route(OutboundRouterCollection.java:75) at org.mule.routing.inbound.ForwardingConsumer.process(ForwardingConsumer.java:51) ... 36 more Caused by: org.mule.umo.routing.CouldNotRouteOutboundMessageException: Failed to route event via endpoint: MuleEndpoint{connector=JdbcConnector{this=8fe392, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[jdbc], serviceOverrides={dispatcher.factory=org.mule.providers.jdbc.JdbcMessageDispatcherFactory}}, endpointUri=jdbc://getQuizzes, transformer=null, name='endpoint.jdbc.getQuizzes', type='senderAndReceiver', properties={BeanClassName=com.digilore.esb.model.Quiz}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:75) at org.mule.routing.outbound.OutboundPassThroughRouter.route(OutboundPassThroughRouter.java:79) at org.mule.routing.outbound.OutboundRouterCollection$1.doInTransaction(OutboundRouterCollection.java:66) at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:39) at org.mule.routing.outbound.OutboundRouterCollection.route(OutboundRouterCollection.java:71) ... 37 more Caused by: org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=JdbcConnector{this=8fe392, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[jdbc], serviceOverrides={dispatcher.factory=org.mule.providers.jdbc.JdbcMessageDispatcherFactory}}, endpointUri=jdbc://getQuizzes, transformer=null, name='endpoint.jdbc.getQuizzes', type='senderAndReceiver', properties={BeanClassName=com.digilore.esb.model.Quiz}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:251) at org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604) at org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:326) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:208) at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:121) at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:66) ... 41 more Caused by: java.lang.IllegalArgumentException: Write statement should be an insert / update / delete sql statement at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:81) at org.mule.providers.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:125) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223) ... 47 more Here is the what i configured <connector name="jdbcConnector" className="org.mule.providers.jdbc.JdbcConnector"> <properties> <property name="jndiInitialFactory" value="org.jnp.interfaces.NamingContextFactory" /> <property name="jndiProviderUrl" value="jnp://127.0.0.1:1099/" /> <property name="connectionFactoryJndiName" value="java:/ConnectionFactory" /> <property name="dataSourceJndiName" value="java:/JNDINAME" /> <map name="serviceOverrides"> <property name="dispatcher.factory" value="org.mule.providers.jdbc.JdbcMessageDispatcherFactory" /> </map> <map name="queries"> <property name="getQuizzes" value="SELECT id, name FROM Quiz" /> </map> </properties> </connector> <!-- global identifiers --> <endpoint-identifiers> <endpoint-identifier name="AllQuiz" value="vm://getAllQuizzes" /> </endpoint-identifiers> <transformers> <transformer name="ObjectToXml" className="org.mule.transformers.xml.ObjectToXml" returnClass="java.lang.String"> <properties> <map name="aliases"> <property name="item" value="com.digilore.esb.model.Quiz" /> </map> </properties> </transformer> </transformers> <mule-descriptor name="Quiz" implementation="org.mule.components.simple.BridgeComponent"> <inbound-router> <endpoint address="vm://Quiz1" /> </inbound-router> <outbound-router> <router className="org.mule.routing.outbound.OutboundPassThroughRouter"> <endpoint address="jdbc://getQuizzes" synchronous="true" connector="jdbcConnector"> <properties> <property name="BeanClassName" value="com.digilore.esb.model.Quiz" /> </properties> </endpoint> </router> </outbound-router> </mule-descriptor> <mule-descriptor name="Quiz1" implementation="org.mule.components.simple.BridgeComponent"> <inbound-router> <endpoint address="vm://getAllQuizzes" responseTransformers="ObjectToXml" /> </inbound-router> <outbound-router> <router className="org.mule.routing.outbound.OutboundPassThroughRouter"> <endpoint address="vm://Quiz1" /> </router> </outbound-router> </mule-descriptor> This used to be working on mule 1.3 rc 5, i did not change anything other than updating to latest mule instance 1.4.1. If you could send any help on this, it will be appreciated. It is not specific to the endpoint because all endpoints are failing. Ashwin

    MuleSoft JIRA | 9 years ago | suresh aa
    org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Here is the basic problem, i have been using mu1e 1.3 rc 4 for a while now, i had a couple of endpoints using jdbc, axis connectors setup. I recently moved to mule 1.4.1, my endpoints using the axis connectors all worked, but the ones connecting using the jdbc connectors are all failing. 16:26:43,585 ERROR [MuleManagerComponent] Failed to process admin request: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:251) at org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604) at org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:326) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:208) at org.mule.impl.MuleEventContext.sendEvent(MuleEventContext.java:247) at org.mule.impl.internal.admin.MuleManagerComponent.sendAction(MuleManagerComponent.java:175) at org.mule.impl.internal.admin.MuleManagerComponent.onCall(MuleManagerComponent.java:95) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.mule.impl.model.resolvers.DynamicEntryPoint.invokeMethod(DynamicEntryPoint.java:313) at org.mule.impl.model.resolvers.DynamicEntryPoint.invoke(DynamicEntryPoint.java:260) at org.mule.impl.DefaultLifecycleAdapter.intercept(DefaultLifecycleAdapter.java:194) at org.mule.impl.InterceptorsInvoker.execute(InterceptorsInvoker.java:47) at org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:257) at org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:408) at org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:418) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:348) at org.mule.routing.inbound.InboundRouterCollection.send(InboundRouterCollection.java:197) at org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:163) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:268) at org.mule.providers.http.HttpMessageReceiver$HttpWorker.run(HttpMessageReceiver.java:269) at org.mule.impl.work.WorkerContext.run(WorkerContext.java:310) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528) at java.lang.Thread.run(Thread.java:619) Caused by: org.mule.umo.routing.RoutingException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='endpoint.vm.getAllQuizzes', type='receiver', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=null, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.routing.inbound.ForwardingConsumer.process(ForwardingConsumer.java:66) at org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:86) at org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315) at org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:250) at org.mule.providers.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:105) at org.mule.providers.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:193) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223) ... 29 more Caused by: org.mule.umo.routing.RoutingException: Failed to route event via endpoint: null. Message payload is of type: HashMap at org.mule.routing.outbound.OutboundRouterCollection.route(OutboundRouterCollection.java:75) at org.mule.routing.inbound.ForwardingConsumer.process(ForwardingConsumer.java:51) ... 36 more Caused by: org.mule.umo.routing.CouldNotRouteOutboundMessageException: Failed to route event via endpoint: MuleEndpoint{connector=JdbcConnector{this=8fe392, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[jdbc], serviceOverrides={dispatcher.factory=org.mule.providers.jdbc.JdbcMessageDispatcherFactory}}, endpointUri=jdbc://getQuizzes, transformer=null, name='endpoint.jdbc.getQuizzes', type='senderAndReceiver', properties={BeanClassName=com.digilore.esb.model.Quiz}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:75) at org.mule.routing.outbound.OutboundPassThroughRouter.route(OutboundPassThroughRouter.java:79) at org.mule.routing.outbound.OutboundRouterCollection$1.doInTransaction(OutboundRouterCollection.java:66) at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:39) at org.mule.routing.outbound.OutboundRouterCollection.route(OutboundRouterCollection.java:71) ... 37 more Caused by: org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=JdbcConnector{this=8fe392, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[jdbc], serviceOverrides={dispatcher.factory=org.mule.providers.jdbc.JdbcMessageDispatcherFactory}}, endpointUri=jdbc://getQuizzes, transformer=null, name='endpoint.jdbc.getQuizzes', type='senderAndReceiver', properties={BeanClassName=com.digilore.esb.model.Quiz}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=null, remoteSyncTimeout=null, endpointEncoding=null}. Message payload is of type: HashMap at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:251) at org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604) at org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:326) at org.mule.impl.MuleSession.sendEvent(MuleSession.java:208) at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:121) at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:66) ... 41 more Caused by: java.lang.IllegalArgumentException: Write statement should be an insert / update / delete sql statement at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:81) at org.mule.providers.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:125) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223) ... 47 more Here is the what i configured <connector name="jdbcConnector" className="org.mule.providers.jdbc.JdbcConnector"> <properties> <property name="jndiInitialFactory" value="org.jnp.interfaces.NamingContextFactory" /> <property name="jndiProviderUrl" value="jnp://127.0.0.1:1099/" /> <property name="connectionFactoryJndiName" value="java:/ConnectionFactory" /> <property name="dataSourceJndiName" value="java:/JNDINAME" /> <map name="serviceOverrides"> <property name="dispatcher.factory" value="org.mule.providers.jdbc.JdbcMessageDispatcherFactory" /> </map> <map name="queries"> <property name="getQuizzes" value="SELECT id, name FROM Quiz" /> </map> </properties> </connector> <!-- global identifiers --> <endpoint-identifiers> <endpoint-identifier name="AllQuiz" value="vm://getAllQuizzes" /> </endpoint-identifiers> <transformers> <transformer name="ObjectToXml" className="org.mule.transformers.xml.ObjectToXml" returnClass="java.lang.String"> <properties> <map name="aliases"> <property name="item" value="com.digilore.esb.model.Quiz" /> </map> </properties> </transformer> </transformers> <mule-descriptor name="Quiz" implementation="org.mule.components.simple.BridgeComponent"> <inbound-router> <endpoint address="vm://Quiz1" /> </inbound-router> <outbound-router> <router className="org.mule.routing.outbound.OutboundPassThroughRouter"> <endpoint address="jdbc://getQuizzes" synchronous="true" connector="jdbcConnector"> <properties> <property name="BeanClassName" value="com.digilore.esb.model.Quiz" /> </properties> </endpoint> </router> </outbound-router> </mule-descriptor> <mule-descriptor name="Quiz1" implementation="org.mule.components.simple.BridgeComponent"> <inbound-router> <endpoint address="vm://getAllQuizzes" responseTransformers="ObjectToXml" /> </inbound-router> <outbound-router> <router className="org.mule.routing.outbound.OutboundPassThroughRouter"> <endpoint address="vm://Quiz1" /> </router> </outbound-router> </mule-descriptor> This used to be working on mule 1.3 rc 5, i did not change anything other than updating to latest mule instance 1.4.1. If you could send any help on this, it will be appreciated. It is not specific to the endpoint because all endpoints are failing. Ashwin

    MuleSoft JIRA | 9 years ago | suresh aa
    org.mule.umo.provider.DispatchException: Failed to route event via endpoint: MuleEndpoint{connector=VMConnector{this=b24759, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}, endpointUri=vm://getAllQuizzes, transformer=null, name='AllQuizzes', type='sender', properties={}, transactionConfig=Transaction{factory=null, action=NONE, timeout=30000}, filter=null, deleteUnacceptedMessages=false, initialised=false, securityFilter=null, synchronous=true, initialState=started, createConnector=0, remoteSync=true, remoteSyncTimeout=10000, endpointEncoding=null}. Message payload is of type: HashMap
  6. 0

    H2 Database - "java.lang.IllegalArgumentException: nanos > 999999999 or < 0"

    nabble.com | 11 months ago
    java.lang.IllegalArgumentException: nanos > 999999999 or < 0"; SQL statement: INSERT INTO MIB_RAW_ALM_HIS (SELECT * FROM MIB_RAW_ALM WHERE EVENT_ID BETWEEN ? AND ?) [50000-157]         at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalArgumentException

      Write statement should be an INSERT, UPDATE, or DELETE SQL statement.

      at com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch()
    2. com.webreach.mirth
      JdbcMessageDispatcher.doSend
      1. com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:110)
      2. com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:139)
      2 frames
    3. org.mule.providers
      AbstractMessageDispatcher.send
      1. org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:167)
      1 frame
    4. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.MuleSession.sendEvent(MuleSession.java:191)
      2. org.mule.impl.MuleSession.sendEvent(MuleSession.java:130)
      2 frames
    5. Mule Core
      OutboundMessageRouter.route
      1. org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:85)
      2. org.mule.routing.outbound.FilteringMulticastingRouter.route(FilteringMulticastingRouter.java:52)
      3. org.mule.routing.outbound.OutboundMessageRouter$1.doInTransaction(OutboundMessageRouter.java:78)
      4. org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:48)
      5. org.mule.routing.outbound.OutboundMessageRouter.route(OutboundMessageRouter.java:82)
      5 frames
    6. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:247)
      2. org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:209)
      3. org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:277)
      4. org.mule.impl.MuleSession.sendEvent(MuleSession.java:201)
      4 frames
    7. org.mule.routing
      InboundMessageRouter.route
      1. org.mule.routing.inbound.InboundMessageRouter.send(InboundMessageRouter.java:180)
      2. org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:147)
      2 frames
    8. org.mule.providers
      AbstractMessageReceiver.routeMessage
      1. org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:493)
      2. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:272)
      3. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:244)
      3 frames
    9. com.webreach.mirth
      MllpMessageReceiver$TcpWorker.run
      1. com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processHL7Data(MllpMessageReceiver.java:476)
      2. com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.processData(MllpMessageReceiver.java:436)
      3. com.webreach.mirth.connectors.mllp.MllpMessageReceiver$TcpWorker.run(MllpMessageReceiver.java:353)
      3 frames
    10. org.mule.impl
      WorkerContext.run
      1. org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
      1 frame
    11. Backport of JSR 166
      ThreadPoolExecutor$Worker.run
      1. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
      2. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
      2 frames
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame