May be related to https://issues.apache.org/jira/browse/CAMEL-6918 ? Can you double check on the next snapshot and see if it's any better?
On Mon, Nov 4, 2013 at 12:38 PM, jguerra <jg.gue...@gmail.com> wrote: > Hi, > > I've just upgraded from Camel 2.7.0 (ActiveMQ 5.5.0) to 2.12.1 (ActiveMQ > 5.9.0) and it seems the exception handler is broken in somehow. This DSL > route works nicely on 2.7.0 but it doesn't work on 2.12.X. I also posted the > ActiveMQ 5.9 exception. > I've also noticed that other routes using exception handlers fail as well. I > am not sure whether is something wrong with either ActiveMQ or Camel. > > The point is that the exception handlers work very well on Camel > 2.7.0/ActiveMQ5.5.0 and the same routes seem to be broken on Camel > 2.12.X/ActivemMQ 5.9.0 because of the onExcpetion. > > > Thank you > > <route> > <description>NTCS Oracle Insertion Queue</description> > <from uri="seda:insertion.queue"/> > <onException> > <exception>java.sql.SQLException</exception> > <handled> > <constant>true</constant> > </handled> > <process ref="telemetryFailureProcessor"/> > <to uri="seda:insertion.failure.queue"/> > </onException> > <transacted/> > <split> > <xpath>/ntcs-telemetry/telemetry</xpath> > <bean ref="insertTransactedTelemetry"/> > </split> > </route> > > > > 2013-11-04 18:58:42,225 | WARN | Error processing exchange. > Exchange[JmsMessage[JmsMessageID: > ID:tcs-amq-dev-54407-1383591485625-5:1:1:1:1]]. Caused by: > [org.springframework.transaction.CannotCreateTransactionException - Could > not open JDBC Connection for transaction; nested exception is > java.sql.SQLException: Unable to start the Universal Connection Pool: > oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from > Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter > could not establish the connection] | > org.apache.camel.component.seda.SedaConsumer | Camel (camel) thread #1 - > seda://insertion.queue > org.springframework.transaction.CannotCreateTransactionException: Could not > open JDBC Connection for transaction; nested exception is > java.sql.SQLException: Unable to start the Universal Connection Pool: > oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from > Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter > could not establish the connection > at > org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:241) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:372) > at > org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) > at > org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.java:174) > at > org.apache.camel.spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:134) > at > org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:103) > at > org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:112) > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) > at > org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) > at > org.apache.camel.component.seda.SedaConsumer.sendToConsumers(SedaConsumer.java:291) > at > org.apache.camel.component.seda.SedaConsumer.doRun(SedaConsumer.java:200) > at > org.apache.camel.component.seda.SedaConsumer.run(SedaConsumer.java:147) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.sql.SQLException: Unable to start the Universal Connection > Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection > from Datasource: java.sql.SQLRecoverableException: IO Error: The Network > Adapter could not establish the connection > at > oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488) > at > oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163) > at > oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:643) > at > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:878) > at > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:845) > at > oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:839) > at > org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:203) > ... 14 more > Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get > Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The > Network Adapter could not establish the connection > at > oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368) > at > oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49) > at > oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80) > at > oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:102) > at > oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1584) > at > oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1420) > at > oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:498) > at > oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:127) > at > oracle.ucp.common.UniversalConnectionPoolImpl.addNewConnections(UniversalConnectionPoolImpl.java:984) > at > oracle.ucp.common.UniversalConnectionPoolBase.getInitialConnections(UniversalConnectionPoolBase.java:549) > at > oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:657) > at > oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:149) > at > oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:637) > ... 18 more > > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Problem-with-exception-handler-onException-on-Camel-2-12-X-routes-tp5742605.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Christian Posta http://www.christianposta.com/blog twitter: @christianposta
