Thanks Claus, I realized that as well and adjusted the timeout settings.
However, I am getting a cryptic camel casting error now.
I have the camel processor/routes in its own bundle calling a separate
persistent services bundle to write off data to the db. From what I can tell
camel doesn't like this.
However, when the camel processor/routes were/are in the same bundle these
casting issues don't appear and it persists the data as expected.
Any idea why this cast exception would be happening?
Here is the error:
2015-07-13 11:50:03,271 | ERROR | #1 - timer://foo | DefaultErrorHandler
| 257 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for
(MessageId: ID-ALA-JPRATT-L2-56182-1436813364589-0-47 on ExchangeId:
ID-ALA-JPRATT-L2-56182-1436813364589-0-46). Exhausted after delivery attempt: 1
caught: java.lang.ClassCastException: Proxy22e97ab2_6214_4dc9_893d_39670338edbb
cannot be cast to dart.core.product.service.api.ProductLineService
Message History
---------------------------------------------------------------------------------------------------------------------------------------
RouteId ProcessorId Processor
Elapsed (ms)
[Noncache ] [Noncache ] [timer://foo?repeatCount=1
] [ 37183]
[Noncache ] [process3 ] [Processor@0x65cb9fe8
] [ 2]
[Noncache ] [to3 ] [jdbc:NonCache
] [ 13]
[Noncache ] [split3 ] [split[{body}]
] [ 37049]
[Noncache ] [process9 ] [Processor@0x1ecd4abc
] [ 36]
Exchange
---------------------------------------------------------------------------------------------------------------------------------------
Exchange[
Id ID-ALA-JPRATT-L2-56182-1436813364589-0-46
ExchangePattern InOnly
Headers {CamelJdbcColumnNames=[myKey, mPortfolio, id,
mName, mDeleted], CamelJdbcRowCount=2, CamelRedelivered=false,
CamelRedeliveryCounter=0}
BodyType java.util.ArrayList
Body [{myKey=CQ2, id=1, name=bench, folio=bench,
deleted=false}, {mKey=CQ2, id=4, name=debugging, folio=bench, deleted=false}]
]
Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
java.lang.ClassCastException: Proxy22e97ab2_6214_4dc9_893d_39670338edbb cannot
be cast to dart.core.product.service.api.ProductLineService
at Proxy2897d49f_3cca_4235_b5e6_89baf89c1782.saveOrUpdate(Unknown
Source)[:]
at
core.camel.product.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:71)[333:core-camel:1.0.0]
at
org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.Splitter.process(Splitter.java:104)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[257:org.apache.camel.camel-core:2.15.2]
at
org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[257:org.apache.camel.camel-core:2.15.2]
at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79]
at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79]
-----Original Message-----
From: Claus Ibsen [mailto:claus.ib...@gmail.com]
Sent: Wednesday, July 08, 2015 10:27 PM
To: users@camel.apache.org
Subject: Re: HELP camel-sql and jpa problem
Hi
That indicates you need to either limit the returned data set so you can
process it faster, or increase the TX timeout so it wont trigger a timeout
while you process the data.
On Wed, Jul 8, 2015 at 8:56 PM, Pratt, Jason <jason.pr...@windriver.com> wrote:
> This also happens if we have a LARGE dataset.
>
> 2015-07-07 21:07:31,969 | INFO | #1 - timer://foo | WpmToDartFinishProcessor
> | 315 - core-product - 1.0.1 | >>> getProductService =
> com.wrs.ept.dart.core.product.service.ProductLineServiceImpl@7dd31e8b
> 2015-07-07 21:40:39,928 | INFO | #1 - timer://foo |
> ticalLoggingSessionEventListener | 79 - org.jboss.logging.jboss-logging -
> 3.1.4.GA | Session Metrics {
> 639049432972 nanoseconds spent acquiring 116853 JDBC connections;
> 15578656409 nanoseconds spent releasing 116853 JDBC connections;
> 651493686650 nanoseconds spent preparing 116959 JDBC statements;
> 884948912356 nanoseconds spent executing 116852 JDBC statements;
> 357116928277 nanoseconds spent executing 688 JDBC batches;
> 0 nanoseconds spent performing 0 L2C puts;
> 0 nanoseconds spent performing 0 L2C hits;
> 0 nanoseconds spent performing 0 L2C misses;
> 378287504498 nanoseconds spent executing 3 flushes (flushing a total of
> 467401 entities and 180 collections);
> 42345 nanoseconds spent executing 1 partial-flushes (flushing a
> total of 0 entities and 0 collections) }
> 2015-07-07 21:40:40,003 | ERROR | #1 - timer://foo | DefaultErrorHandler
> | 264 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for
> (MessageId: ID-ala-pcheung-l3-63967-1436328423513-0-6 on ExchangeId: ID-
> ala-pcheung-l3-63967-1436328423513-0-5). Exhausted after delivery
> attempt: 1 caught:
> org.apache.aries.transaction.exception.TransactionRollbackException:
> javax.transaction.RollbackException: Unable to commit: transaction
> mark ed for rollback
>
> Message History
> ---------------------------------------------------------------------------------------------------------------------------------------
> RouteId ProcessorId Processor
> Elapsed (ms)
> [Noncache ] [wpmSuiteNoncache ] [timer://foo?repeatCount=1
> ] [ 2013785]
> [Noncache ] [process1 ] [Processor@0x726b22b
> ] [ 1]
> [Noncache ] [to2 ] [jdbc: NonCache
> ] [ 11]
> [Noncache ] [split2 ] [split[{body}]
> ] [ 20968]
> [Noncache ] [process7 ] [Processor@0x199a7572
> ] [ 1992771]
>
> Exchange
> ----------------------------------------------------------------------
> -----------------------------------------------------------------
> Exchange[
> Id ID-ala-pcheung-l3-63967-1436328423513-0-5
> ExchangePattern InOnly
> Headers {CamelJdbcColumnNames=[mKey, mPortfolio, mId,
> mName], CamelJdbcRowCount=1, CamelRedelivered=false, CamelRedeliveryCounter=0}
> BodyType java.util.ArrayList
> Body [{mKey=MYSQL1:25, mId=25, mName=xxx,
> mPortfolio=xxx}]
> ]
>
> Stacktrace
> ----------------------------------------------------------------------
> -----------------------------------------------------------------
> org.apache.aries.transaction.exception.TransactionRollbackException:
> javax.transaction.RollbackException: Unable to commit: transaction marked for
> rollback
> at
> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:91)[95:org.apache.aries.transaction.blueprint:1.0.2]
> at
> org.apache.aries.blueprint.proxy.Collaborator.postInvoke(Collaborator.java:105)[15:org.apache.aries.blueprint.core:1.4.3]
> at Proxyd0d0974b_705f_4ea5_b64e_a32066c869ca.saveOrUpdate(Unknown
> Source)[:]
> at
> com.wrs.ept.dart.core.product.camel.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:30)[315:core-product:1.0.1]
> at
> org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2]
> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79]
> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79]
> Caused by: javax.transaction.RollbackException: Unable to commit: transaction
> marked for rollback
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)[96:org.apache.aries.transaction.manager:1.1.1]
> at
> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)[96:org.apache.aries.transaction.manager:1.1.1]
> at Proxy13505eb8_8516_4525_ae35_742e7cb9e34d.commit(Unknown Source)[:]
> at
> org.apache.aries.transaction.TransactionAttribute$4.finish(TransactionAttribute.java:94)[95:org.apache.aries.transaction.blueprint:1.0.2]
> at
> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:85)[95:org.apache.aries.transaction.blueprint:1.0.2]
> ... 25 more
> Caused by: java.lang.Exception: Transaction has timed out
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)[96:org.apache.aries.transaction.manager:1.1.1]
> ... 29 more
> 2015-07-07 21:40:40,187 | WARN | #1 - timer://foo | TimerConsumer
> | 264 - org.apache.camel.camel-core - 2.15.2 | Error processing
> exchange. Exchange[Message: { "xxx": [{"id":1,"mKey":"xxx","uuid":"
> 7f694555-01c9-4ddd-9c4e- [Body clipped after xxx chars, total length
> is 32987]]. Caused by:
> [org.apache.aries.transaction.exception.TransactionRollbackException -
> javax.transaction.RollbackExc
> eption: Unable to commit: transaction marked for rollback]
> org.apache.aries.transaction.exception.TransactionRollbackException:
> javax.transaction.RollbackException: Unable to commit: transaction marked for
> rollback
> at
> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:91)[95:org.apache.aries.transaction.blueprint:1.0.2]
> at
> org.apache.aries.blueprint.proxy.Collaborator.postInvoke(Collaborator.java:105)[15:org.apache.aries.blueprint.core:1.4.3]
> at Proxyd0d0974b_705f_4ea5_b64e_a32066c869ca.saveOrUpdate(Unknown
> Source)[:]
> at
> com.wrs.ept.dart.core.product.camel.WpmToDartFinishProcessor.process(WpmToDartFinishProcessor.java:30)[315:core-product:1.0.1]
> at
> org.apache.camel.processor.DelegateSyncProcessor.process(DelegateSyncProcessor.java:63)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2]
> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79]
> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79]
> Caused by: javax.transaction.RollbackException: Unable to commit: transaction
> marked for rollback
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)[96:org.apache.aries.transaction.manager:1.1.1]
> at
> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)[96:org.apache.aries.transaction.manager:1.1.1]
> at Proxy13505eb8_8516_4525_ae35_742e7cb9e34d.commit(Unknown Source)[:]
> at
> org.apache.aries.transaction.TransactionAttribute$4.finish(TransactionAttribute.java:94)[95:org.apache.aries.transaction.blueprint:1.0.2]
> at
> org.apache.aries.transaction.TxInterceptorImpl.postCallWithReturn(TxInterceptorImpl.java:85)[95:org.apache.aries.transaction.blueprint:1.0.2]
> ... 25 more
> Caused by: java.lang.Exception: Transaction has timed out
> at
> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)[96:org.apache.aries.transaction.manager:1.1.1]
> ... 29 more
>
> -----Original Message-----
> From: Pratt, Jason [mailto:jason.pr...@windriver.com]
> Sent: Wednesday, July 08, 2015 11:18 AM
> To: users@camel.apache.org
> Subject: RE: HELP camel-sql and jpa problem
>
> A more complete stacktrace is listed below. It appears to be timing out, but
> I am not sure.
>
> Exchange
> ----------------------------------------------------------------------
> -----------------------------------------------------------------
> Exchange[
> Id ID-ALA-JPRATT-L2-57521-1436377974985-0-498020
> ExchangePattern InOnly
> Headers
> {breadcrumbId=ID-ALA-JPRATT-L2-57521-1436377974985-0-498019,
> CamelRedelivered=false, CamelRedeliveryCounter=0}
> BodyType String
> Body select envName, legacyEnvId from releaseToEnvName
> where releaseKey = "xxx";
> ]
>
> Stacktrace
> ----------------------------------------------------------------------
> -----------------------------------------------------------------
> java.sql.SQLException: java.lang.NoClassDefFoundError:
> javax/net/ssl/SSLException
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:904)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:894)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:407)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:338)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2237)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)[163:com.mysql.jdbc:5.1.35]
> at sun.reflect.GeneratedConstructorAccessor91.newInstance(Unknown
> Source)[:1.7.0_79]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_79]
> at
> java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_79]
> at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:389)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:422)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:134)[163:com.mysql.jdbc:5.1.35]
> at
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:105)[163:com.mysql.jdbc:5.1.35]
> at Proxy799360c1_2c24_4e0e_b421_2593c684b8e5.getConnection(Unknown
> Source)[:]
> at Proxyfaee2ad9_ba00_4d29_a45f_81e9105c0467.getConnection(Unknown
> Source)[:]
> at
> org.apache.camel.component.jdbc.JdbcProducer.processingSqlBySettingAutoCommit(JdbcProducer.java:78)[291:org.apache.camel.camel-jdbc:2.15.2]
> at
> org.apache.camel.component.jdbc.JdbcProducer.process(JdbcProducer.java:65)[291:org.apache.camel.camel-jdbc:2.15.2]
> at
> org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.SendProcessor.process(SendProcessor.java:129)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.FilterProcessor.process(FilterProcessor.java:58)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:652)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.doProcessSequential(MulticastProcessor.java:580)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.MulticastProcessor.process(MulticastProcessor.java:227)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Splitter.process(Splitter.java:104)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:118)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer.sendTimerExchange(TimerConsumer.java:165)[264:org.apache.camel.camel-core:2.15.2]
> at
> org.apache.camel.component.timer.TimerConsumer$1.run(TimerConsumer.java:73)[264:org.apache.camel.camel-core:2.15.2]
> at java.util.TimerThread.mainLoop(Timer.java:555)[:1.7.0_79]
> at java.util.TimerThread.run(Timer.java:505)[:1.7.0_79]
> Caused by: java.lang.NoClassDefFoundError: javax/net/ssl/SSLException
> at
> com.mysql.jdbc.SQLError.createLinkFailureMessageBasedOnHeuristics(SQLError.java:1174)
> at
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException.<init>(CommunicationsException.java:45)
> at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown
> Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_79]
> at
> java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_79]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
> ... 82 more
> 2015-07-08 10:56:55,522 | ERROR | #1 - timer://foo | DefaultErrorHandler
> | 264 - org.apache.camel.camel-core - 2.15.2 | Failed delivery for
> (MessageId: ID-ALA-JPRATT-L2-57521-1436377974985-0-498024 on ExchangeId:
> ID-ALA-JPRATT-L2-57521-1436377974985-0-498025). Exhausted after delivery
> attempt: 1 caught: java.sql.SQLException: java.lang.NoClassDefFoundError:
> javax/net/ssl/SSLException
>
> Message History
> ---------------------------------------------------------------------------------------------------------------------------------------
> RouteId ProcessorId Processor
> Elapsed (ms)
> [Noncache ] [Noncache ] [timer://foo?fixedRate=true&period=900000
> ] [ 238712]
> [Noncache ] [filter1 ] [filter[{body contains Milestone}]
> ] [ 5]
> [Noncache ] [to4 ] [jdbc: mydb] [ 4]
>
>
>
>
> -----Original Message-----
> From: Claus Ibsen [mailto:claus.ib...@gmail.com]
> Sent: Wednesday, July 08, 2015 12:29 AM
> To: users@camel.apache.org
> Subject: Re: HELP camel-sql and jpa problem
>
> Hi
>
> Is there more of that stacktrace?
>
> Though OSGi can be tricky with classloading.
>
> On Tue, Jul 7, 2015 at 10:00 PM, Pratt, Jason <jason.pr...@windriver.com>
> wrote:
>> Hello - I just started seeing this in my logs and haven't seen it happening
>> before. I am running:
>>
>> Karaf-3.0.4
>> Camel-2.15.2
>>
>> I am at a loss for what could be causing this. Its basically stopping during
>> a run after writing some items to the database, but dropping most of the
>> balance.
>>
>>
>>
>> Message History
>> ---------------------------------------------------------------------------------------------------------------------------------------
>> RouteId ProcessorId Processor
>> Elapsed (ms)
>> [Noncache ] [Noncache ] [timer://foo?fixedRate=true&period=900000
>> ] [ 234744]
>> [Noncache ] [process1 ] [Processor@0x2cf91aaf
>> ] [ 0]
>> [Noncache ] [to2 ] [jdbc:mydb
>> ] [ 5]
>>
>> Exchange
>> ---------------------------------------------------------------------
>> ------------------------------------------------------------------
>> Exchange[
>> Id ID-ALA-JPRATT-L2-64645-1436297885034-0-489002
>> ExchangePattern InOnly
>> Headers {CamelRedelivered=false,
>> CamelRedeliveryCounter=0}
>> BodyType String
>> Body select key, id, name, ppp from pl
>> where ppp = 'MyProd';
>> ]
>>
>> Stacktrace
>> ---------------------------------------------------------------------
>> ------------------------------------------------------------------
>> java.sql.SQLException: java.lang.NoClassDefFoundError:
>> javax/net/ssl/SSLException
>
>
>
> --
> Claus Ibsen
> -----------------
> Red Hat, Inc.
> Email: cib...@redhat.com
> Twitter: davsclaus
> Blog: http://davsclaus.com
> Author of Camel in Action: http://www.manning.com/ibsen
> hawtio: http://hawt.io/
> fabric8: http://fabric8.io/
--
Claus Ibsen
-----------------
Red Hat, Inc.
Email: cib...@redhat.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
hawtio: http://hawt.io/
fabric8: http://fabric8.io/
