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

MuleSoft JIRA | suresh aa | 9 years ago
  1. 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
  2. 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
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 0

    Hibernate JPQL throws Update/delete queries cannot be typed

    Stack Overflow | 2 years ago | Jan Vladimir Mostert
    java.lang.IllegalArgumentException: Update/delete queries cannot be typed

    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 / delete sql statement

      at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch()
    2. org.mule.providers
      AbstractConnector.send
      1. org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:81)
      2. org.mule.providers.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:125)
      3. org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223)
      4. org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604)
      4 frames
    3. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920)
      2. org.mule.impl.MuleSession.sendEvent(MuleSession.java:326)
      3. org.mule.impl.MuleSession.sendEvent(MuleSession.java:208)
      3 frames
    4. Mule Core
      OutboundRouterCollection.route
      1. org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:121)
      2. org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:66)
      3. org.mule.routing.outbound.OutboundPassThroughRouter.route(OutboundPassThroughRouter.java:79)
      4. org.mule.routing.outbound.OutboundRouterCollection$1.doInTransaction(OutboundRouterCollection.java:66)
      5. org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:39)
      6. org.mule.routing.outbound.OutboundRouterCollection.route(OutboundRouterCollection.java:71)
      6 frames
    5. org.mule.routing
      InboundRouterCollection.route
      1. org.mule.routing.inbound.ForwardingConsumer.process(ForwardingConsumer.java:51)
      2. org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:86)
      2 frames
    6. org.mule.providers
      AbstractConnector.send
      1. org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573)
      2. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315)
      3. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:250)
      4. org.mule.providers.vm.VMMessageReceiver.onCall(VMMessageReceiver.java:105)
      5. org.mule.providers.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:193)
      6. org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:223)
      7. org.mule.providers.AbstractConnector.send(AbstractConnector.java:1604)
      7 frames
    7. org.mule.impl
      MuleManagerComponent.onCall
      1. org.mule.impl.ImmutableMuleEndpoint.send(ImmutableMuleEndpoint.java:920)
      2. org.mule.impl.MuleSession.sendEvent(MuleSession.java:326)
      3. org.mule.impl.MuleSession.sendEvent(MuleSession.java:208)
      4. org.mule.impl.MuleEventContext.sendEvent(MuleEventContext.java:247)
      5. org.mule.impl.internal.admin.MuleManagerComponent.sendAction(MuleManagerComponent.java:175)
      6. org.mule.impl.internal.admin.MuleManagerComponent.onCall(MuleManagerComponent.java:95)
      6 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    9. Annotations
      DynamicEntryPoint.invoke
      1. org.mule.impl.model.resolvers.DynamicEntryPoint.invokeMethod(DynamicEntryPoint.java:313)
      2. org.mule.impl.model.resolvers.DynamicEntryPoint.invoke(DynamicEntryPoint.java:260)
      2 frames
    10. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.DefaultLifecycleAdapter.intercept(DefaultLifecycleAdapter.java:194)
      2. org.mule.impl.InterceptorsInvoker.execute(InterceptorsInvoker.java:47)
      3. org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:257)
      4. org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:408)
      5. org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:418)
      6. org.mule.impl.MuleSession.sendEvent(MuleSession.java:348)
      6 frames
    11. org.mule.routing
      InboundRouterCollection.route
      1. org.mule.routing.inbound.InboundRouterCollection.send(InboundRouterCollection.java:197)
      2. org.mule.routing.inbound.InboundRouterCollection.route(InboundRouterCollection.java:163)
      2 frames
    12. org.mule.providers
      HttpMessageReceiver$HttpWorker.run
      1. org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:573)
      2. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:315)
      3. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:268)
      4. org.mule.providers.http.HttpMessageReceiver$HttpWorker.run(HttpMessageReceiver.java:269)
      4 frames
    13. org.mule.impl
      WorkerContext.run
      1. org.mule.impl.work.WorkerContext.run(WorkerContext.java:310)
      1 frame
    14. Backport of JSR 166
      ThreadPoolExecutor$Worker.run
      1. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
      2. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
      2 frames
    15. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame