[mule-user] mule jdbc connection - not able to see the output

Rani Wilfred

unread,

Dec 14, 2010, 5:39:34 AM12/14/10

to us...@mule.codehaus.org

Hi,

I have used the muleconfig file for jdbc connection with oracle. In that config file iam using the select query to retrive the data used in inbound and used vm out in the outbound. I started the mule server.

It run successfully but i dont know were will be the output saved or how do i see the retrived data from the database.

Please i need to know the output. Please help me in resolving this issue.

<jdbc:connector name="jdbcConnector" pollingFrequency="10000" dataSource-ref="jdbcDataSource">
<jdbc:query key="selectTest"
value="select * from testing"/>
</jdbc:connector>
<vm:connector name="vmConnector" queueEvents="true"/>

<model name="ExampleModel">
<service name="InboundSelectExample">
<inbound>
<jdbc:inbound-endpoint queryKey="selectTest"/>
</inbound>
<outbound>
<pass-through-router>
<vm:outbound-endpoint path="out"/>
</pass-through-router>
</outbound>
</service>
</model>

</mule>

/**** server output ***************/

INFO 2010-12-14 16:00:34,389 [main] org.mule.MuleServer: Mule Server initializing...
INFO 2010-12-14 16:00:34,920 [main] org.mule.config.spring.MuleApplicationContext: Refreshing org.mule.config.spring.MuleApplicationContext@2808b3: display name [org.mule.config.spring.MuleApplicationContext@2808b3]; startup date [Tue Dec 14 16:00:34 GMT+05:30 2010]; root of context hierarchy
INFO 2010-12-14 16:00:36,201 [main] org.mule.config.spring.MuleApplicationContext: Bean factory for application context [org.mule.config.spring.MuleApplicationContext@2808b3]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1cd107f
INFO 2010-12-14 16:00:36,904 [main] org.mule.transport.jdbc.JdbcConnector: Initialising: JdbcConnector{this=e3570c, started=false, initialised=false, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-14 16:00:36,936 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@118278a
INFO 2010-12-14 16:00:36,951 [main] org.mule.transport.vm.VMConnector: Initialising: VMConnector{this=9fa8f, started=false, initialised=false, name='vmConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-14 16:00:36,983 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@1701bdc
INFO 2010-12-14 16:00:37,092 [main] org.mule.component.simple.PassThroughComponent: Initialising: org.mule.component.simple.PassThroughComponent component for: SedaService{InboundSelectExample}
INFO 2010-12-14 16:00:37,108 [main] org.mule.config.builders.AutoConfigurationBuilder: Configured Mule using "org.mule.config.spring.SpringXmlConfigurationBuilder" with configuration resource(s): "[ConfigResource{resourceName='/C:/MuleTestJdbc/samplejdbc/samplejdbc-config.xml'}]"
INFO 2010-12-14 16:00:37,108 [main] org.mule.config.builders.AutoConfigurationBuilder: Configured Mule using "org.mule.config.builders.AutoConfigurationBuilder" with configuration resource(s): "[ConfigResource{resourceName='/C:/MuleTestJdbc/samplejdbc/samplejdbc-config.xml'}]"
INFO 2010-12-14 16:00:37,108 [main] org.mule.MuleServer: Mule Server starting...
INFO 2010-12-14 16:00:37,514 [main] org.mule.transport.jdbc.JdbcConnector: Connected: JdbcConnector{this=e3570c, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-14 16:00:37,514 [main] org.mule.transport.jdbc.JdbcConnector: Starting: JdbcConnector{this=e3570c, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-14 16:00:37,529 [main] org.mule.transport.jdbc.JdbcConnector: Started: JdbcConnector{this=e3570c, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-14 16:00:37,529 [main] org.mule.transport.vm.VMConnector: Connected: VMConnector{this=9fa8f, started=false, initialised=true, name='vmConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-14 16:00:37,529 [main] org.mule.transport.vm.VMConnector: Starting: VMConnector{this=9fa8f, started=false, initialised=true, name='vmConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-14 16:00:37,545 [main] org.mule.transport.vm.VMConnector: Started: VMConnector{this=9fa8f, started=true, initialised=true, name='vmConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-14 16:00:37,545 [main] org.mule.module.management.agent.JmxAgent: Creating and starting JMX agent connector Server
INFO 2010-12-14 16:00:37,545 [main] org.mule.component.simple.PassThroughComponent: Starting: org.mule.component.simple.PassThroughComponent component for: SedaService{InboundSelectExample}
INFO 2010-12-14 16:00:37,545 [main] org.mule.transport.jdbc.JdbcConnector: Registering listener: InboundSelectExample on endpointUri: jdbc://selectTest
INFO 2010-12-14 16:00:37,561 [main] org.mule.transport.jdbc.JdbcMessageReceiver: Connected: jdbc://selectTest
INFO 2010-12-14 16:00:37,576 [main] org.mule.model.seda.SedaService: Service InboundSelectExample has been started successfully
INFO 2010-12-14 16:00:37,576 [main] org.mule.util.queue.TransactionalQueueManager: Starting ResourceManager
INFO 2010-12-14 16:00:37,592 [main] org.mule.util.queue.TransactionalQueueManager: Started ResourceManager
INFO 2010-12-14 16:00:37,592 [main] org.mule.module.management.agent.WrapperManagerAgent: This JVM hasn't been launched by the wrapper, the agent will not run.
INFO 2010-12-14 16:00:37,670 [main] org.mule.module.management.agent.JmxAgent: Attempting to register service with name: Mule.2f349689-076d-11e0-bbed-4bec19557fb1:type=org.mule.Endpoint,service="InboundSelectExample",connector=jdbcConnector,name="endpoint.jdbc.selectTest"
INFO 2010-12-14 16:00:37,670 [main] org.mule.module.management.agent.JmxAgent: Registered Endpoint Service with name: Mule.2f349689-076d-11e0-bbed-4bec19557fb1:type=org.mule.Endpoint,service="InboundSelectExample",connector=jdbcConnector,name="endpoint.jdbc.selectTest"
INFO 2010-12-14 16:00:37,670 [main] org.mule.module.management.agent.JmxAgent: Registered Connector Service with name Mule.2f349689-076d-11e0-bbed-4bec19557fb1:type=org.mule.Connector,name="jdbcConnector.1"
INFO 2010-12-14 16:00:37,670 [main] org.mule.module.management.agent.JmxAgent: Registered Connector Service with name Mule.2f349689-076d-11e0-bbed-4bec19557fb1:type=org.mule.Connector,name="vmConnector.1"
INFO 2010-12-14 16:00:37,686 [main] org.mule.DefaultMuleContext:
**********************************************************************
* Mule ESB and Integration Platform *
* Version: 2.2.6 Build: 18824 *
* MuleSoft, Inc. *
* For more information go to http://www.mulesoft.org *
* *
* Server started: 12/14/10 4:00 PM *
* Server ID: 2f349689-076d-11e0-bbed-4bec19557fb1 *
* JDK: 1.6.0_18 (mixed mode, sharing) *
* OS encoding: UTF-8, Mule encoding: UTF-8 *
* OS: Windows XP - Service Pack 3 (5.1, x86) *
* Host: 01hw074647 (172.20.32.35) *
* *
* Agents Running: *
* JMX Agent *
**********************************************************************
INFO 2010-12-14 16:00:39,029 [vmConnector.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: Connected: endpoint.outbound.vm://out

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

Dirk Olmes

unread,

Dec 14, 2010, 7:37:50 AM12/14/10

to us...@mule.codehaus.org

On 12/14/2010 11:39 AM, Rani Wilfred wrote:
> Hi,
>
> I have used the muleconfig file for jdbc connection with oracle. In
> that config file iam using the select query to retrive the data used
> in inbound and used vm out in the outbound. I started the mule
> server.
>
> It run successfully but i dont know were will be the output saved or
> how do i see the retrived data from the database.
>
> Please i need to know the output. Please help me in resolving this
> issue.

Well the Maps that make up the results from your fetch end up on the vm
queue. But it seems nothing is picking them up from there.

For testing purposes you can just route them to a stdio endpoint. Or add
a logging component ....

-dirk

Rani Wilfred

unread,

Dec 15, 2010, 5:30:41 AM12/15/10

to us...@mule.codehaus.org

Thanks i got the output but i want to get the data from the vm connector and send it to another table in the database.
I need to retrive the data and place it in vm queue and how to insert the same data into another table using vm connector

Dirk Olmes

unread,

Dec 15, 2010, 6:59:48 AM12/15/10

to us...@mule.codehaus.org

On 12/15/2010 11:30 AM, Rani Wilfred wrote:
> Thanks i got the output but i want to get the data from the vm
> connector and send it to another table in the database. I need to
> retrive the data and place it in vm queue and how to insert the same
> data into another table using vm connector

I don't really understand your question. If you want to consume those
messages, create a flow that picks up messages via vm inbound endpoint
and bridge them to a JDBC outbound endpoint. If you need to use a
separate database connection, specify a second jdbc:connector and use
connector="" on your endpoints.

-dirk

Rani Wilfred

unread,

Dec 16, 2010, 5:57:03 AM12/16/10

to us...@mule.codehaus.org

Hi Dirk,

Please find the config file below for retriving the data and insert the same via vm connector

I have used vm inbound endpoint and bridge them to a JDBC outbound endpoint as shown in the below config file but it is not working iam not able to insert the data which is retrived from the database into the table.

I have tried using different service but then also it is not working. Please help me in resolving this issue.

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesource.org/schema/mule/core/2.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:stdio="http://www.mulesource.org/schema/mule/stdio/2.2"
xmlns:spring="http://www.springframework.org/schema/beans"
xmlns:file="http://www.mulesource.org/schema/mule/file/2.2"

xmlns:jdbc="http://www.mulesource.org/schema/mule/jdbc/2.2"
xmlns:vm="http://www.mulesource.org/schema/mule/vm/2.2"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.mulesource.org/schema/mule/jdbc/2.2 http://www.mulesource.org/schema/mule/jdbc/2.2/mule-jdbc.xsd
http://www.mulesource.org/schema/mule/core/2.2 http://www.mulesource.org/schema/mule/core/2.2/mule.xsd

http://www.mulesource.org/schema/mule/file/2.2 http://www.mulesource.org/schema/mule/file/2.2/mule-file.xsd
http://www.mulesource.org/schema/mule/stdio/2.2 http://www.mulesource.org/schema/mule/stdio/2.2/mule-stdio.xsd

http://www.mulesource.org/schema/mule/vm/2.2 http://www.mulesource.org/schema/mule/vm/2.2/mule-vm.xsd">
<spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
<spring:property name="driverName" value="oracle.jdbc.driver.OracleDriver"/>
<spring:property name="url" value="jdbc:oracle:thin:emonsony/em...@172.20.46.54:1521:nastrad"/>
</spring:bean>

<jdbc:connector name="jdbcConnector" pollingFrequency="10000" dataSource-ref="jdbcDataSource">
<jdbc:query key="selectTest"

value="select * from testmule"/>
<jdbc:query key="commitMules"
value="insert into mule (ID, NAME) values
(#[map-payload:ID], #[map-payload:NAME])"></jdbc:query>

</jdbc:connector>
<vm:connector name="vmConnector" queueEvents="true" />

<vm:inbound-endpoint path="out" connector-ref="vmConnector"/>

</pass-through-router>
</outbound>
</service>
<service name="outboundSelectExample">
<inbound>
<vm:inbound-endpoint path="in" connector-ref="vmConnector"/>

</inbound>
<outbound>
<pass-through-router>
<jdbc:outbound-endpoint queryKey="commitMules" synchronous="true"/>

</pass-through-router>
</outbound>
</service>
</model>

</mule>

---------------------------------------------------------------------

Dirk Olmes

unread,

Dec 16, 2010, 6:06:57 AM12/16/10

to us...@mule.codehaus.org

> <model name="ExampleModel">
> <service name="InboundSelectExample">
> <inbound>
> <jdbc:inbound-endpoint queryKey="selectTest"/>
> </inbound>
> <outbound>
> <pass-through-router>
> <vm:inbound-endpoint path="out" connector-ref="vmConnector"/>

... so fetch results to go the "out" queue.

> </pass-through-router>
> </outbound>
> </service>
> <service name="outboundSelectExample">
> <inbound>
> <vm:inbound-endpoint path="in" connector-ref="vmConnector"/>

... stuff to be inserted is expected on the "in" queue. You need to use
the same queue for the search results or the "outboundSelectExample"
service will never see any data.

-dirk

Rani Wilfred

unread,

Dec 20, 2010, 2:30:14 AM12/20/10

to us...@mule.codehaus.org

Hi dirk,

I have used the same vm queue as mention in the below config file. Iam getting exception as

INFO 2010-12-20 12:26:35,782 [vmConnector.dispatcher.1] org.mule.transport.vm.VMMessageDispatcher: Connected: endpoint.outbound.vm://doInsert
INFO 2010-12-20 12:26:35,829 [outboundSelectExample.3] org.mule.transaction.TransactionTemplate: Exception Caught in Transaction template without any exception listeners defined, exception is rethrown.
INFO 2010-12-20 12:26:35,829 [outboundSelectExample.2] org.mule.transaction.TransactionTemplate: Exception Caught in Transaction template without any exception listeners defined, exception is rethrown.
INFO 2010-12-20 12:26:35,829 [outboundSelectExample.4] org.mule.transaction.TransactionTemplate: Exception Caught in Transaction template without any exception listeners defined, exception is rethrown.
ERROR 2010-12-20 12:26:35,829 [outboundSelectExample.3] org.mule.service.DefaultServiceExceptionStrategy:
********************************************************************************
Message : Connector that caused exception is: null. Connector that caused exception is: JdbcConnector{this=14a75bb, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
Type : org.mule.api.transport.ConnectorException
Code : MULE_ERROR-68033
JavaDoc : http://www.mulesource.org/docs/site/current2/apidocs/org/mule/api/transport/ConnectorException.html
********************************************************************************
Exception stack is:
1. org.mule.transport.jdbc.JdbcConnector cannot be cast to com.mulesource.mule.transport.jdbc.EEJdbcConnector (java.lang.ClassCastException)
com.mulesource.mule.transport.jdbc.EEJdbcMessageDispatcher:28 (null)
2. Connector that caused exception is: null. Connector that caused exception is: JdbcConnector{this=14a75bb, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null} (org.mule.api.transport.ConnectorException)
org.mule.transport.AbstractConnector:1043 (http://www.mulesource.org/docs/site/current2/apidocs/org/mule/api/transport/ConnectorException.html)
********************************************************************************
Root Exception stack trace:
java.lang.ClassCastException: org.mule.transport.jdbc.JdbcConnector cannot be cast to com.mulesource.mule.transport.jdbc.EEJdbcConnector
at com.mulesource.mule.transport.jdbc.EEJdbcMessageDispatcher.<init>(EEJdbcMessageDispatcher.java:28)
at com.mulesource.mule.transport.jdbc.EEJdbcMessageDispatcherFactory.create(EEJdbcMessageDispatcherFactory.java:26)
at org.mule.transport.KeyedPoolMessageDispatcherFactoryAdapter.makeObject(KeyedPoolMessageDispatcherFactoryAdapter.java:58)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:964)
at org.mule.transport.DefaultConfigurableKeyedObjectPool.borrowObject(DefaultConfigurableKeyedObjectPool.java:40)
at org.mule.transport.AbstractConnector.getDispatcher(AbstractConnector.java:1030)
at org.mule.transport.AbstractConnector.send(AbstractConnector.java:2166)
at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:97)
at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:332)
at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:216)
at org.mule.routing.outbound.AbstractOutboundRouter$2.doInTransaction(AbstractOutboundRouter.java:152)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:117)
at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:159)
at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:79)
at org.mule.routing.outbound.OutboundPassThroughRouter.route(OutboundPassThroughRouter.java:69)
at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:86)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:50)
at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:91)
at org.mule.service.AbstractService.dispatchToOutboundRouter(AbstractService.java:864)
at org.mule.model.seda.SedaService.dispatchToOutboundRouter(SedaService.java:554)
at org.mule.model.seda.SedaService$ComponentStageWorker.doRun(SedaService.java:576)
at org.mule.work.AbstractMuleEventWork.run(AbstractMuleEventWork.java:41)
at org.mule.work.WorkerContext.run(WorkerContext.java:310)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
at java.lang.Thread.run(Unknown Source)

********************************************************************************

Please find the config file:

<jdbc:connector name="jdbcConnector" pollingFrequency="10000" dataSource-ref="jdbcDataSource">
<jdbc:query key="selectTest"
value="select * from testmule"/>
<jdbc:query key="commitMules"
value="insert into mule (ID, NAME) values

(#map-payload:ID, #map-payload:NAME)"></jdbc:query>

</jdbc:connector>
<vm:connector name="vmConnector" queueEvents="true" />

<vm:outbound-endpoint address="vm://doInsert" />

</pass-through-router>
</outbound>
</service>
<service name="outboundSelectExample">
<inbound>

<vm:inbound-endpoint address="vm://doInsert" />

</inbound>
<outbound>
<pass-through-router>
<jdbc:outbound-endpoint queryKey="commitMules" synchronous="true"/>

</pass-through-router>
</outbound>
</service>
</model>

</mule>

Please help me in resolving this issue.

Regards,
lourdes wilfred

Dirk Olmes

unread,

Dec 20, 2010, 3:18:31 AM12/20/10

to us...@mule.codehaus.org

> xmlns:jdbc="http://www.mulesource.org/schema/mule/jdbc/2.2"

You refer to the CE JDBC connector while you have the EE one on the
classpath. Use the correct schema reference:

xmlns:jdbc="http://www.mulesource.org/schema/mule/ee/jdbc" and
http://www.mulesource.org/schema/mule/ee/jdbc
http://www.mulesource.org/schema/mule/ee/jdbc/2.2/mule-jdbc-ee.xsd">

-dirk

Rani Wilfred

unread,

Dec 20, 2010, 4:42:18 AM12/20/10

to us...@mule.codehaus.org

Hi Dirk,

I have repleace the schema with ee as you mention then iam getting the following error as show below:

INFO 2010-12-20 15:03:05,566 [main] org.mule.MuleServer: Mule Server initializing...
INFO 2010-12-20 15:03:06,081 [main] org.mule.config.spring.MuleApplicationContext: Refreshing org.mule.config.spring.MuleApplicationContext@2808b3: display name [org.mule.config.spring.MuleApplicationContext@2808b3]; startup date [Mon Dec 20 15:03:06 GMT+05:30 2010]; root of context hierarchy
ERROR 2010-12-20 15:03:07,159 [main] org.mule.config.spring.SpringXmlConfigurationBuilder: Configuration with "org.mule.config.spring.SpringXmlConfigurationBuilder" failed.
org.mule.api.lifecycle.InitialisationException: Initialisation Failure: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:76)
at org.mule.config.spring.SpringXmlConfigurationBuilder.createSpringRegistry(SpringXmlConfigurationBuilder.java:110)
at org.mule.config.spring.SpringXmlConfigurationBuilder.doConfigure(SpringXmlConfigurationBuilder.java:73)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.config.builders.AutoConfigurationBuilder.autoConfigure(AutoConfigurationBuilder.java:112)
at org.mule.config.builders.AutoConfigurationBuilder.doConfigure(AutoConfigurationBuilder.java:58)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.context.DefaultMuleContextFactory.createMuleContext(DefaultMuleContextFactory.java:177)
at org.mule.MuleServer.initialize(MuleServer.java:348)
at org.mule.MuleServer.run(MuleServer.java:255)
at org.mule.MuleServer.start(MuleServer.java:242)
at org.mule.MuleServer.main(MuleServer.java:121)
Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:404)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310)
at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143)
at org.mule.config.spring.MuleApplicationContext.loadBeanDefinitions(MuleApplicationContext.java:105)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at org.mule.config.spring.SpringRegistry.doInitialise(SpringRegistry.java:90)
at org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:68)
... 13 more
Caused by: org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaErr(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.constructTrees(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.parseSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaLoader.loadSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.findSchemaGrammar(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396)
... 22 more
ERROR 2010-12-20 15:03:07,159 [main] org.mule.config.builders.AutoConfigurationBuilder: Configuration with "org.mule.config.builders.AutoConfigurationBuilder" failed.
org.mule.api.config.ConfigurationException: Initialisation Failure: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. (org.mule.api.lifecycle.InitialisationException)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:46)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.config.builders.AutoConfigurationBuilder.autoConfigure(AutoConfigurationBuilder.java:112)
at org.mule.config.builders.AutoConfigurationBuilder.doConfigure(AutoConfigurationBuilder.java:58)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.context.DefaultMuleContextFactory.createMuleContext(DefaultMuleContextFactory.java:177)
at org.mule.MuleServer.initialize(MuleServer.java:348)
at org.mule.MuleServer.run(MuleServer.java:255)
at org.mule.MuleServer.start(MuleServer.java:242)
at org.mule.MuleServer.main(MuleServer.java:121)
Caused by: org.mule.api.lifecycle.InitialisationException: Initialisation Failure: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:76)
at org.mule.config.spring.SpringXmlConfigurationBuilder.createSpringRegistry(SpringXmlConfigurationBuilder.java:110)
at org.mule.config.spring.SpringXmlConfigurationBuilder.doConfigure(SpringXmlConfigurationBuilder.java:73)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
... 10 more
Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:404)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310)
at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143)
at org.mule.config.spring.MuleApplicationContext.loadBeanDefinitions(MuleApplicationContext.java:105)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at org.mule.config.spring.SpringRegistry.doInitialise(SpringRegistry.java:90)
at org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:68)
... 13 more
Caused by: org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaErr(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.constructTrees(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.parseSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaLoader.loadSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.findSchemaGrammar(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396)
... 22 more
ERROR 2010-12-20 15:03:07,191 [main] org.mule.MuleServer:
********************************************************************************
Message : Initialisation Failure: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
Type : org.mule.api.lifecycle.InitialisationException
Code : MULE_ERROR-72085
JavaDoc : http://www.mulesource.org/docs/site/current2/apidocs/org/mule/api/lifecycle/InitialisationException.html
Object : org.mule.config.spring.SpringRegistry@b60b93
********************************************************************************
Exception stack is:
1. TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. (org.xml.sax.SAXParseException)
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper:-1 (null)
2. Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. (org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException)
org.springframework.beans.factory.xml.XmlBeanDefinitionReader:404 (null)
3. Initialisation Failure: Line 7 in XML document from URL [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid; nested exception is org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. (org.mule.api.lifecycle.InitialisationException)
org.mule.registry.AbstractRegistry:76 (http://www.mulesource.org/docs/site/current2/apidocs/org/mule/api/lifecycle/InitialisationException.html)

********************************************************************************
Root Exception stack trace:

org.xml.sax.SAXParseException: TargetNamespace.1: Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace of the schema document is 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaErr(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.reportSchemaError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.constructTrees(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.traversers.XSDHandler.parseSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaLoader.loadSchema(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.findSchemaGrammar(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310)
at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143)
at org.mule.config.spring.MuleApplicationContext.loadBeanDefinitions(MuleApplicationContext.java:105)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at org.mule.config.spring.SpringRegistry.doInitialise(SpringRegistry.java:90)
at org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:68)
at org.mule.config.spring.SpringXmlConfigurationBuilder.createSpringRegistry(SpringXmlConfigurationBuilder.java:110)
at org.mule.config.spring.SpringXmlConfigurationBuilder.doConfigure(SpringXmlConfigurationBuilder.java:73)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.config.builders.AutoConfigurationBuilder.autoConfigure(AutoConfigurationBuilder.java:112)
at org.mule.config.builders.AutoConfigurationBuilder.doConfigure(AutoConfigurationBuilder.java:58)
at org.mule.config.builders.AbstractConfigurationBuilder.configure(AbstractConfigurationBuilder.java:39)
at org.mule.config.builders.AbstractResourceConfigurationBuilder.configure(AbstractResourceConfigurationBuilder.java:78)
at org.mule.context.DefaultMuleContextFactory.createMuleContext(DefaultMuleContextFactory.java:177)
at org.mule.MuleServer.initialize(MuleServer.java:348)
at org.mule.MuleServer.run(MuleServer.java:255)
at org.mule.MuleServer.start(MuleServer.java:242)
at org.mule.MuleServer.main(MuleServer.java:121)

********************************************************************************

ERROR 2010-12-20 15:03:07,191 [main] org.mule.MuleServer:
********************************************************************************
* A Fatal error has occurred while the server was running: *
* TargetNamespace.1: Expecting namespace *
* 'http://www.mulesource.org/schema/mule/ee/jdbc', but the target namespace *
* of the schema document is *
* 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. *
* (org.xml.sax.SAXParseException) *
* *
* The error is fatal, the system must shutdown *
********************************************************************************

Config file:

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesource.org/schema/mule/core/2.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:stdio="http://www.mulesource.org/schema/mule/stdio/2.2"
xmlns:spring="http://www.springframework.org/schema/beans"
xmlns:file="http://www.mulesource.org/schema/mule/file/2.2"

xmlns:jdbc="http://www.mulesource.org/schema/mule/ee/jdbc"

xmlns:vm="http://www.mulesource.org/schema/mule/vm/2.2"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

http://www.mulesource.org/schema/mule/core/2.2 http://www.mulesource.org/schema/mule/core/2.2/mule.xsd
http://www.mulesource.org/schema/mule/file/2.2 http://www.mulesource.org/schema/mule/file/2.2/mule-file.xsd
http://www.mulesource.org/schema/mule/stdio/2.2 http://www.mulesource.org/schema/mule/stdio/2.2/mule-stdio.xsd
http://www.mulesource.org/schema/mule/vm/2.2 http://www.mulesource.org/schema/mule/vm/2.2/mule-vm.xsd

http://www.mulesource.org/schema/mule/ee/jdbc http://www.mulesource.org/schema/mule/ee/jdbc/2.2/mule-jdbc-ee.xsd">

</mule>

Regards,
Lourdes wilfred.

Dirk Olmes

unread,

Dec 20, 2010, 5:37:10 AM12/20/10

to us...@mule.codehaus.org

On 12/20/2010 10:42 AM, Rani Wilfred wrote:
> Hi Dirk,
>
> I have repleace the schema with ee as you mention then iam getting
> the following error as show below:
>
> INFO 2010-12-20 15:03:05,566 [main] org.mule.MuleServer: Mule Server
> initializing... INFO 2010-12-20 15:03:06,081 [main]
> org.mule.config.spring.MuleApplicationContext: Refreshing
> org.mule.config.spring.MuleApplicationContext@2808b3: display name
> [org.mule.config.spring.MuleApplicationContext@2808b3]; startup date
> [Mon Dec 20 15:03:06 GMT+05:30 2010]; root of context hierarchy ERROR
> 2010-12-20 15:03:07,159 [main]
> org.mule.config.spring.SpringXmlConfigurationBuilder: Configuration
> with "org.mule.config.spring.SpringXmlConfigurationBuilder" failed.
> org.mule.api.lifecycle.InitialisationException: Initialisation
> Failure: Line 7 in XML document from URL
> [file:/C:/test/muletest/testJdbc/testconfig-config.xml] is invalid;
> nested exception is org.xml.sax.SAXParseException: TargetNamespace.1:
> Expecting namespace 'http://www.mulesource.org/schema/mule/ee/jdbc',
> but the target namespace of the schema document is
> 'http://www.mulesource.org/schema/mule/ee/jdbc/2.2'. at
> org.mule.registry.AbstractRegistry.initialise(AbstractRegistry.java:76)

The error message says it all ... you need /2.2 at the end of the
namespace ID.

-dirk

Rani Wilfred

unread,

Dec 20, 2010, 6:17:11 AM12/20/10

to us...@mule.codehaus.org

Hi dirik,

Iam getting exception as shown below:

INFO 2010-12-20 16:42:46,309 [outboundSelectExample.10] com.mulesource.mule.transport.jdbc.EEJdbcMessageDispatcher: Connected: endpoint.outbound.jdbc://commitMules
ERROR 2010-12-20 16:42:46,371 [outboundSelectExample.9] org.mule.DefaultExceptionStrategy: Caught exception in Exception Strategy: Missing IN or OUT parameter at index:: 1 Query: insert into mule (ID, NAME) values (#map-payload:ID, #map-payload:NAME) Parameters: []
java.sql.SQLException: Missing IN or OUT parameter at index:: 1 Query: insert into mule (ID, NAME) values (#map-payload:ID, #map-payload:NAME) Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:428)
at org.mule.transport.jdbc.sqlstrategy.SimpleUpdateSqlStatementStrategy.executeStatement(SimpleUpdateSqlStatementStrategy.java:69)
at org.mule.transport.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:66)
at org.mule.transport.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:167)
at org.mule.transport.AbstractConnector.send(AbstractConnector.java:2167)

at org.mule.endpoint.DefaultOutboundEndpoint.send(DefaultOutboundEndpoint.java:97)
at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:332)
at org.mule.DefaultMuleSession.sendEvent(DefaultMuleSession.java:216)
at org.mule.routing.outbound.AbstractOutboundRouter$2.doInTransaction(AbstractOutboundRouter.java:152)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:117)
at org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:159)
at org.mule.routing.outbound.FilteringOutboundRouter.route(FilteringOutboundRouter.java:79)
at org.mule.routing.outbound.OutboundPassThroughRouter.route(OutboundPassThroughRouter.java:69)
at org.mule.routing.outbound.DefaultOutboundRouterCollection$1.doInTransaction(DefaultOutboundRouterCollection.java:86)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:50)
at org.mule.routing.outbound.DefaultOutboundRouterCollection.route(DefaultOutboundRouterCollection.java:91)
at org.mule.service.AbstractService.dispatchToOutboundRouter(AbstractService.java:864)
at org.mule.model.seda.SedaService.dispatchToOutboundRouter(SedaService.java:554)
at org.mule.model.seda.SedaService$ComponentStageWorker.doRun(SedaService.java:576)
at org.mule.work.AbstractMuleEventWork.run(AbstractMuleEventWork.java:41)
at org.mule.work.WorkerContext.run(WorkerContext.java:310)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
at java.lang.Thread.run(Unknown Source)

----------------------------------------------

config file:

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesource.org/schema/mule/core/2.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:stdio="http://www.mulesource.org/schema/mule/stdio/2.2"
xmlns:spring="http://www.springframework.org/schema/beans"
xmlns:file="http://www.mulesource.org/schema/mule/file/2.2"

xmlns:jdbc="http://www.mulesource.org/schema/mule/ee/jdbc/2.2"

http://www.mulesource.org/schema/mule/ee/jdbc/2.2 http://www.mulesource.org/schema/mule/ee/jdbc/2.2/mule-jdbc-ee.xsd">

<spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
<spring:property name="driverName" value="oracle.jdbc.driver.OracleDriver"/>
<spring:property name="url" value="jdbc:oracle:thin:emonsony/em...@172.20.46.54:1521:nastrad"/>
</spring:bean>

<jdbc:connector name="jdbcConnector" pollingFrequency="10000" dataSource-ref="jdbcDataSource">
<jdbc:query key="selectTest"
value="select * from testmule"/>
<jdbc:query key="commitMules"
value="insert into mule (ID, NAME) values
(#map-payload:ID, #map-payload:NAME)"></jdbc:query>
</jdbc:connector>
<vm:connector name="vmConnector" queueEvents="true" />

<vm:outbound-endpoint path="test" />

</pass-through-router>
</outbound>
</service>
<service name="outboundSelectExample">
<inbound>

<vm:inbound-endpoint path="test" />

</inbound>
<outbound>
<pass-through-router>
<jdbc:outbound-endpoint queryKey="commitMules" synchronous="true"/>

</pass-through-router>
</outbound>
</service>
</model>

</mule>

Regards,
Lourdes wilfred

Pablo Kraan

unread,

Dec 20, 2010, 6:28:07 AM12/20/10

to us...@mule.codehaus.org

Wrong parameter format: #map-payload:ID should be #[map-payload:ID]

Take a look at the documentation for more information.

Pablo

Barys_Il...@troika.ru

unread,

Dec 20, 2010, 7:26:36 AM12/20/10

to us...@mule.codehaus.org

Greeting,

I would like to use MessageNotificationListener described in
http://www.mulesoft.org/documentation/display/MULE3USER/Mule+Server+Notifications#MuleServerNotifications-interfaces

BUT. I can't find such class (or interface) in Mule 3.1.0-RC1

Where can I find MessageNotificationListener?

Best Regards,
Barys Ilyushonak

_______________________________________________________

The information contained in this message may be privileged and conf idential and protected from disclosure. If you are not the original intended recipient, you are hereby notified that any review, retransmission, dissemination, or other use of, or taking of any action in reliance upon, this information is prohibited. If you have received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. Thank you for your cooperation. Troika Dialog, Russia.

If you need assistance please contact our Contact Center (+7495) 258 0500 or go to www.troika.ru/eng/Contacts/system.wbp

Dirk Olmes

unread,

Dec 20, 2010, 7:47:34 AM12/20/10

to us...@mule.codehaus.org

On 12/20/2010 01:26 PM, Barys_Il...@troika.ru wrote:
>
> Greeting,
>

> I would like to use *MessageNotificationListener *described in

> http://www.mulesoft.org/documentation/display/MULE3USER/Mule+Server+Notifications#MuleServerNotifications-interfaces
>
> BUT. I can't find such class (or interface) in Mule 3.1.0-RC1
>
> Where can I find MessageNotificationListener?

That's either ComponentMessageNotificationListener or
EndpointMessageNotificationListener

I'll update the documentation ...

-dirk

Rani Wilfred

unread,

Dec 20, 2010, 7:57:01 AM12/20/10

to us...@mule.codehaus.org

HI,

I have used the same format then also i got the same exception please find it below:
INFO 2010-12-20 18:23:40,102 [outboundSelectExample.3] org.mule.transaction.TransactionTemplate: Exception Caught in Transaction template without any exception listeners defined, exception is rethrown.
ERROR 2010-12-20 18:23:40,149 [outboundSelectExample.10] org.mule.DefaultExceptionStrategy: Caught exception in Exception Strategy: Missing IN or OUT parameter at index:: 1 Query: insert into mule (ID, NAME) values (#map-payload:ID,#map-payload:NAME) Parameters: []
java.sql.SQLException: Missing IN or OUT parameter at index:: 1 Query: insert into mule (ID, NAME) values (#map-payload:ID,#map-payload:NAME) Parameters: []

config file:

(#map-payload:ID,#map-payload:NAME)"></jdbc:query>

</mule>

Please help me in resolving this.

Barys_Il...@troika.ru

unread,

Dec 20, 2010, 8:56:52 AM12/20/10

to us...@mule.codehaus.org, us...@mule.codehaus.org

It diesn't work
I can't see notification from static-component, custom-processor, message-properties-transformer and so on.

How can I get an notification from this components?

I have tried several ways:
1. Use AOP on MessageProcessor. It doesn't work because MessageProcessor implementation hasn't default constructor
2. Use message interceptor. It doesn't work, because, for example custom transformer doesn't implement InterceptingMessageProcessor. And some othe processors too (for example static-component)
3. Use notifications. It doesn't work - there is no notifications from static-component, custom-processor, message-properties-transformer and so on
I have tried the following config

<notifications>
<notification event="COMPONENT-MESSAGE"/>
<notification event="CONNECTION"/>
<notification event="CONTEXT"/>
<notification event="CUSTOM"/>
<notification event="ENDPOINT-MESSAGE"/>
<notification event="EXCEPTION"/>
<notification event="MANAGEMENT"/>
<notification event="MESSAGE-PROCESSOR"/>
<notification event="MODEL"/>
<notification event="REGISTRY"/>
<notification event="ROUTING"/>
<notification event="SECURITY"/>
<notification event="SERVICE"/>
<notification event="TRANSACTION"/>
<notification-listener ref="notificationLogger"/>
</notifications>

and class

public class NotificationLogger
implements
ComponentMessageNotificationListener
, ConnectionNotificationListener
, CustomNotificationListener
, EndpointMessageNotificationListener
, ExceptionNotificationListener
, ManagementNotificationListener
, ModelNotificationListener
, MuleContextNotificationListener
, RegistryNotificationListener
, RoutingNotificationListener
, SecurityNotificationListener
, ServerNotificationListener
, ServiceNotificationListener
, TransactionNotificationListener
...

Dirk Olmes <dirk....@mulesoft.com>

20.12.2010 15:49

Please respond to
us...@mule.codehaus.org

To	us...@mule.codehaus.org
cc
Subject	Re: [mule-user] Mule 3 MessageNotificationListener

Andrew Perepelytsya

unread,

Dec 20, 2010, 9:15:13 AM12/20/10

to us...@mule.codehaus.org

On Mon, Dec 20, 2010 at 8:56 AM, <Barys_Il...@troika.ru> wrote:

It diesn't work
I can't see notification from static-component, custom-processor, message-properties-transformer and so on.

How can I get an notification from this components?

Custom-processor is not a component, it fires MessageProcessorNotification and does it only starting with Mule 3.1.0
The transformer is not a component either, currently has no dedicated notifications (but does fire MPNotification)
static-component - not sure, need more details to verify.

Andrew

Barys_Il...@troika.ru

unread,

Dec 20, 2010, 9:20:25 AM12/20/10

to us...@mule.codehaus.org, us...@mule.codehaus.org

As I said I use 3.1.0-RC1

Custom-processor doesn't fire anything

Andrew Perepelytsya <aper...@gmail.com>

20.12.2010 17:15

Please respond to
us...@mule.codehaus.org

To	us...@mule.codehaus.org
cc
Subject	Re: [mule-user] Mule 3 MessageNotificationListener

Rani Wilfred

unread,

Dec 21, 2010, 1:44:26 AM12/21/10

to us...@mule.codehaus.org

Hi,
Sorry for saying this Please create a new thread for your queries as this is not relavant to the query posted by me. Please dont mistake me.

Thanks and Regards,
Lourdes wilfred.

Rani Wilfred

unread,

Dec 21, 2010, 5:11:12 AM12/21/10

to us...@mule.codehaus.org

Hi,

I got the output please find the correct config file.

<spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
<spring:property name="driverName" value="oracle.jdbc.driver.OracleDriver"/>
<spring:property name="url" value="jdbc:oracle:thin:emonsony/em...@172.20.46.54:1521:nastrad"/>
</spring:bean>

<jdbc:connector name="jdbcConnector" pollingFrequency="100000000" dataSource-ref="jdbcDataSource">

<jdbc:query key="selectTest"
value="select * from testmule"/>
<jdbc:query key="commitMules"

value="insert into samplemule (ID, MULE_NAME) values
(#[map-payload:ID], #[map-payload:Name])"></jdbc:query>