camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pratt, Jason" <Jason.Pr...@windriver.com>
Subject RE: HELP camel-sql and jpa problem
Date Mon, 13 Jul 2015 19:14:28 GMT
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.ibsen@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.Pratt@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.Pratt@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.ibsen@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.Pratt@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: cibsen@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: cibsen@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/
Mime
View raw message