[mule-user] MULE_ERROR-84

25 views
Skip to first unread message

Rani Wilfred

unread,
Dec 13, 2010, 6:06:14 AM12/13/10
to us...@mule.codehaus.org
Hi,
Please help me in resolving the below error:
Iam using the mule enterprise edition.

INFO 2010-12-10 16:06:03,013 [main] org.mule.MuleServer: Mule Server initializing...
INFO 2010-12-10 16:06:03,748 [main] org.mule.config.spring.MuleApplicationContext: Refreshing org.mule.config.spring.MuleApplicationContext@1cb25f1: display name [org.mule.config.spring.MuleApplicationContext@1cb25f1]; startup date [Fri Dec 10 16:06:03 GMT+05:30 2010]; root of context hierarchy
INFO 2010-12-10 16:06:05,013 [main] org.mule.config.spring.MuleApplicationContext: Bean factory for application context [org.mule.config.spring.MuleApplicationContext@1cb25f1]: org.springframework.beans.factory.support.DefaultListableBeanFactory@701a27
INFO 2010-12-10 16:06:05,763 [main] org.mule.transport.jdbc.JdbcConnector: Initialising: JdbcConnector{this=17779e3, started=false, initialised=false, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-10 16:06:05,795 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@bf1d3b
INFO 2010-12-10 16:06:05,998 [main] org.mule.transport.vm.VMConnector: Initialising: VMConnector{this=19e09a4, started=false, initialised=false, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,013 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@e5355f
INFO 2010-12-10 16:06:06,013 [main] org.mule.component.simple.PassThroughComponent: Initialising: org.mule.component.simple.PassThroughComponent component for: SedaService{InboundSelectExample}
INFO 2010-12-10 16:06:06,029 [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-10 16:06:06,029 [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-10 16:06:06,029 [main] org.mule.MuleServer: Mule Server starting...
INFO 2010-12-10 16:06:06,029 [main] org.mule.transport.vm.VMConnector: Connected: VMConnector{this=19e09a4, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,029 [main] org.mule.transport.vm.VMConnector: Starting: VMConnector{this=19e09a4, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,045 [main] org.mule.transport.vm.VMConnector: Started: VMConnector{this=19e09a4, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
ERROR 2010-12-10 16:06:06,060 [main] org.mule.retry.notifiers.ConnectNotifier: Failed to connect/reconnect: JdbcConnector{this=17779e3, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}. Root Exception was: Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver(SQL Code: 0, SQL State: + null). Type: class java.sql.SQLException
ERROR 2010-12-10 16:06:06,060 [main] org.mule.MuleServer:
********************************************************************************
Message : Initialisation Failure: Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver
Type : org.mule.transport.ConnectException
Code : MULE_ERROR-84
JavaDoc : http://www.mulesource.org/docs/site/current2/apidocs/org/mule/transport/ConnectException.html
Object : JdbcConnector{this=17779e3, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
********************************************************************************
Exception stack is:
1. Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver(SQL Code: 0, SQL State: + null) (java.sql.SQLException)
org.enhydra.jdbc.standard.StandardDataSource:184 (null)
2. Initialisation Failure: Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver (org.mule.transport.ConnectException)
org.mule.transport.jdbc.JdbcConnector:242 (http://www.mulesource.org/docs/site/current2/apidocs/org/mule/transport/ConnectException.html)
********************************************************************************
Root Exception stack trace:
java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver
at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:184)
at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:144)
at org.mule.transport.jdbc.JdbcConnector.getConnection(JdbcConnector.java:238)
at org.mule.transport.jdbc.JdbcConnector.validateConnection(JdbcConnector.java:378)
at org.mule.transport.AbstractConnector$1.doWork(AbstractConnector.java:1554)
at org.mule.retry.policies.AbstractPolicyTemplate.execute(AbstractPolicyTemplate.java:59)
at org.mule.transport.AbstractConnector.connect(AbstractConnector.java:1549)
at org.mule.transport.AbstractConnector.start(AbstractConnector.java:396)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mule.lifecycle.DefaultLifecyclePhase.applyLifecycle(DefaultLifecyclePhase.java:272)
at org.mule.lifecycle.DefaultLifecyclePhase.applyLifecycle(DefaultLifecyclePhase.java:128)
at org.mule.lifecycle.GenericLifecycleManager.firePhase(GenericLifecycleManager.java:84)
at org.mule.DefaultMuleContext.start(DefaultMuleContext.java:186)
at org.mule.MuleServer.run(MuleServer.java:257)
at org.mule.MuleServer.start(MuleServer.java:242)
at org.mule.MuleServer.main(MuleServer.java:121)

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

ERROR 2010-12-10 16:06:06,060 [main] org.mule.MuleServer:
********************************************************************************
* A Fatal error has occurred while the server was running: *
* Error trying to load driver: oracle.jdbc.driver.OracleDriver : *
* oracle.jdbc.driver.OracleDriver (java.sql.SQLException) *
* *
* The error is fatal, the system must shutdown *
********************************************************************************
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.vm.VMConnector: Disposing: VMConnector{this=19e09a4, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.vm.VMConnector: Stopping: VMConnector{this=19e09a4, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.vm.VMConnector: Disconnected: VMConnector{this=19e09a4, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.vm.VMConnector: Stopped: VMConnector{this=19e09a4, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.vm.VMConnector: Disposed: VMConnector{this=19e09a4, started=false, initialised=false, name='connector.VM.0', disposed=true, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.config.spring.MuleApplicationContext: Closing org.mule.config.spring.MuleApplicationContext@1cb25f1: display name [org.mule.config.spring.MuleApplicationContext@1cb25f1]; startup date [Fri Dec 10 16:06:03 GMT+05:30 2010]; root of context hierarchy
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.jdbc.JdbcConnector: Disposing: JdbcConnector{this=17779e3, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-10 16:06:06,076 [main] org.mule.transport.jdbc.JdbcConnector: Disposed: JdbcConnector{this=17779e3, started=false, initialised=false, name='jdbcConnector', disposed=true, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-10 16:06:06,263 [main] org.mule.DefaultMuleContext:
**********************************************************************
* Mule shut down normally on: 12/10/10 4:06 PM *
* Server was up for: 0 days, 0 hours, 0 mins, 0.234 sec *
**********************************************************************
To resolve this error I have added ojdbc14.jar to the bulid path then i got the following message in below attachment:

INFO 2010-12-13 16:17:44,591 [main] org.mule.MuleServer: Mule Server initializing...
INFO 2010-12-13 16:17:45,201 [main] org.mule.config.spring.MuleApplicationContext: Refreshing org.mule.config.spring.MuleApplicationContext@1cb25f1: display name [org.mule.config.spring.MuleApplicationContext@1cb25f1]; startup date [Mon Dec 13 16:17:45 GMT+05:30 2010]; root of context hierarchy
INFO 2010-12-13 16:17:46,482 [main] org.mule.config.spring.MuleApplicationContext: Bean factory for application context [org.mule.config.spring.MuleApplicationContext@1cb25f1]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1d5a0
INFO 2010-12-13 16:17:47,185 [main] org.mule.transport.jdbc.JdbcConnector: Initialising: JdbcConnector{this=14a75bb, started=false, initialised=false, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-13 16:17:47,216 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@94cb8b
INFO 2010-12-13 16:17:47,435 [main] org.mule.transport.vm.VMConnector: Initialising: VMConnector{this=c92507, started=false, initialised=false, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=false, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-13 16:17:47,435 [main] org.mule.DefaultExceptionStrategy: Initialising exception listener: org.mule.DefaultExceptionStrategy@144b18f
INFO 2010-12-13 16:17:47,435 [main] org.mule.component.simple.PassThroughComponent: Initialising: org.mule.component.simple.PassThroughComponent component for: SedaService{InboundSelectExample}
INFO 2010-12-13 16:17:47,451 [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-13 16:17:47,451 [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-13 16:17:47,451 [main] org.mule.MuleServer: Mule Server starting...
INFO 2010-12-13 16:17:47,466 [main] org.mule.transport.vm.VMConnector: Connected: VMConnector{this=c92507, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-13 16:17:47,466 [main] org.mule.transport.vm.VMConnector: Starting: VMConnector{this=c92507, started=false, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-13 16:17:47,466 [main] org.mule.transport.vm.VMConnector: Started: VMConnector{this=c92507, started=true, initialised=true, name='connector.VM.0', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=true, connected=true, supportedProtocols=[vm], serviceOverrides=null}
INFO 2010-12-13 16:17:47,935 [main] org.mule.transport.jdbc.JdbcConnector: Connected: JdbcConnector{this=14a75bb, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-13 16:17:47,935 [main] org.mule.transport.jdbc.JdbcConnector: Starting: JdbcConnector{this=14a75bb, started=false, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-13 16:17:47,951 [main] org.mule.transport.jdbc.JdbcConnector: Started: JdbcConnector{this=14a75bb, started=true, initialised=true, name='jdbcConnector', disposed=false, numberOfConcurrentTransactedReceivers=4, createMultipleTransactedReceivers=false, connected=true, supportedProtocols=[jdbc], serviceOverrides=null}
INFO 2010-12-13 16:17:47,951 [main] org.mule.module.management.agent.JmxAgent: Creating and starting JMX agent connector Server
INFO 2010-12-13 16:17:47,951 [main] org.mule.component.simple.PassThroughComponent: Starting: org.mule.component.simple.PassThroughComponent component for: SedaService{InboundSelectExample}
INFO 2010-12-13 16:17:47,951 [main] org.mule.transport.jdbc.JdbcConnector: Registering listener: InboundSelectExample on endpointUri: jdbc://selectTest
INFO 2010-12-13 16:17:47,966 [main] org.mule.transport.jdbc.JdbcMessageReceiver: Connected: jdbc://selectTest
INFO 2010-12-13 16:17:47,982 [main] org.mule.model.seda.SedaService: Service InboundSelectExample has been started successfully
INFO 2010-12-13 16:17:47,982 [main] org.mule.util.queue.TransactionalQueueManager: Starting ResourceManager
INFO 2010-12-13 16:17:47,982 [main] org.mule.util.queue.TransactionalQueueManager: Started ResourceManager
INFO 2010-12-13 16:17:47,982 [main] org.mule.module.management.agent.WrapperManagerAgent: This JVM hasn't been launched by the wrapper, the agent will not run.
INFO 2010-12-13 16:17:48,091 [main] org.mule.module.management.agent.JmxAgent: Attempting to register service with name: Mule.6ae0ccb4-06a6-11e0-815a-ef09e175efed:type=org.mule.Endpoint,service="InboundSelectExample",connector=jdbcConnector,name="endpoint.jdbc.selectTest"
INFO 2010-12-13 16:17:48,091 [main] org.mule.module.management.agent.JmxAgent: Registered Endpoint Service with name: Mule.6ae0ccb4-06a6-11e0-815a-ef09e175efed:type=org.mule.Endpoint,service="InboundSelectExample",connector=jdbcConnector,name="endpoint.jdbc.selectTest"
INFO 2010-12-13 16:17:48,091 [main] org.mule.module.management.agent.JmxAgent: Registered Connector Service with name Mule.6ae0ccb4-06a6-11e0-815a-ef09e175efed:type=org.mule.Connector,name="connector.VM.0.1"
INFO 2010-12-13 16:17:48,091 [main] org.mule.module.management.agent.JmxAgent: Registered Connector Service with name Mule.6ae0ccb4-06a6-11e0-815a-ef09e175efed:type=org.mule.Connector,name="jdbcConnector.1"
INFO 2010-12-13 16:17:48,107 [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/13/10 4:17 PM *
* Server ID: 6ae0ccb4-06a6-11e0-815a-ef09e175efed *
* 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-13 16:17:49,482 [connector.VM.0.dispatcher.1] org.mule.transport.vm.VMMessageDispatcher: Connected: endpoint.outbound.vm://orders
WARN 2010-12-13 16:17:49,482 [connector.VM.0.dispatcher.1] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
INFO 2010-12-13 16:17:49,482 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: Connected: endpoint.outbound.vm://orders
WARN 2010-12-13 16:17:49,482 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,498 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,529 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,576 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,607 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,654 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders
WARN 2010-12-13 16:17:49,685 [connector.VM.0.dispatcher.2] org.mule.transport.vm.VMMessageDispatcher: No receiver for endpointUri: vm://orders


Thanks in advance

Lourdes wilfred.

samplejdbc-config.xml

Dirk Olmes

unread,
Dec 13, 2010, 6:39:14 AM12/13/10
to us...@mule.codehaus.org
> java.sql.SQLException: Error trying to load driver: oracle.jdbc.driver.OracleDriver : oracle.jdbc.driver.OracleDriver
> at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:184)
> at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:144)
> at org.mule.transport.jdbc.JdbcConnector.getConnection(JdbcConnector.java:238)
> at org.mule.transport.jdbc.JdbcConnector.validateConnection(JdbcConnector.java:378)
> at org.mule.transport.AbstractConnector$1.doWork(AbstractConnector.java:1554)
> at org.mule.retry.policies.AbstractPolicyTemplate.execute(AbstractPolicyTemplate.java:59)
> at org.mule.transport.AbstractConnector.connect(AbstractConnector.java:1549)
> at org.mule.transport.AbstractConnector.start(AbstractConnector.java:396)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.mule.lifecycle.DefaultLifecyclePhase.applyLifecycle(DefaultLifecyclePhase.java:272)
> at org.mule.lifecycle.DefaultLifecyclePhase.applyLifecycle(DefaultLifecyclePhase.java:128)
> at org.mule.lifecycle.GenericLifecycleManager.firePhase(GenericLifecycleManager.java:84)
> at org.mule.DefaultMuleContext.start(DefaultMuleContext.java:186)
> at org.mule.MuleServer.run(MuleServer.java:257)
> at org.mule.MuleServer.start(MuleServer.java:242)
> at org.mule.MuleServer.main(MuleServer.java:121)

This looks straightforward to me: you don't have the Oracle JDBC driver
on your classpath.

-dirk

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

http://xircles.codehaus.org/manage_email


Rani Wilfred

unread,
Dec 14, 2010, 12:38:44 AM12/14/10
to us...@mule.codehaus.org
Hi,

Thanks for helping me but i have added driver jar in the classpath iam getting the error as mention in below:

Same config file as mention in the above trace mail.

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

Rani Wilfred

unread,
Dec 14, 2010, 2:24:00 AM12/14/10
to us...@mule.codehaus.org
Hi,

I have resolved the error. I have missed this line <vm:connector name="vmConnector" queueEvents="true"/> in my config file.

Now it is working fine.

Regards,
Lourdes wilfred

Reply all
Reply to author
Forward
0 new messages