Camel Tracer example - Database

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Camel Tracer example - Database

Gnanaguru S

Hi

In camel-example-tracer it uses HSQL database at runtime when I do mvn camel:run.

Now I want to bundle the same example as a WAR file. I was successful in changing the directory structure, pom. Now the WAR builds fine.

But the database used in the example was a IN-MEMORY database. If want to trace the message to my own custom database, just changing the data source name in persistence.xml will do for a derby/mysql?

If I am right. It will create table and store the data in the database.

It uses JPA. So it there any other way to store, may be using JDBC. ? But I am not sure how tracer gives way to configure how/what to store in DB.

regards
Guru
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Claus Ibsen-2
On Thu, Oct 4, 2012 at 11:59 AM, Gnanaguru S
<[hidden email]> wrote:

>
> Hi
>
> In camel-example-tracer it uses HSQL database at runtime when I do mvn
> camel:run.
>
> Now I want to bundle the same example as a WAR file. I was successful in
> changing the directory structure, pom. Now the WAR builds fine.
>
> But the database used in the example was a IN-MEMORY database. If want to
> trace the message to my own custom database, just changing the data source
> name in persistence.xml will do for a derby/mysql?
>
> If I am right. It will create table and store the data in the database.
>

Yes its using standard JPA, so configure your database in the persistence.xml.
It should be able to connect to a remote JDBC. You would possible need
to create the table schema up front, unless the JPA driver for your
database can do that automatic (some can do).

> It uses JPA. So it there any other way to store, may be using JDBC. ? But I
> am not sure how tracer gives way to configure how/what to store in DB.
>

You can also just trace to a custom destination, eg to a Camel
endpoint, and then do whatever you want.
Or use a custom traceHandler and implement logic to persist the
message using JDBC etc.

See some details at:
http://camel.apache.org/tracer

> regards
> Guru
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Camel-Tracer-example-Database-tp5720552.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



--
Claus Ibsen
-----------------
Red Hat, Inc.
FuseSource is now part of Red Hat
Email: [hidden email]
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Gnanaguru S

Thanks Claus I understood. Do you have any idea whether Apache Derby supports that ?

Such that I can configure Apache derby in persistance.xml and write the trace messages to it.

It may reduce the effort.

Thanks,
Guru
@gnanagurus
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Christian Mueller
Administrator
Try it out or check the Derby documentation...

Sent from a mobile device
Am 04.10.2012 14:19 schrieb "Gnanaguru S" <[hidden email]>:

>
> Thanks Claus I understood. Do you have any idea whether Apache Derby
> supports that ?
>
> Such that I can configure Apache derby in persistance.xml and write the
> trace messages to it.
>
> It may reduce the effort.
>
> Thanks,
> Guru
> @gnanagurus
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Camel-Tracer-example-Database-tp5720552p5720559.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Gnanaguru S

Hello Christian,

After verifying with Derby. I altered the configuration in persistence.xml for derby. Now the application is connected with Derby. I can see the connectivity log.

But when I run the example, Tracer was not able to store the message into the database. It throws this error message. Please let me know your thoughts.

2012-10-08 11:29:32,869 [2 - stream://in] INFO  SchemaExport                   - Running hbm2ddl schema export
2012-10-08 11:29:32,869 [2 - stream://in] INFO  SchemaExport                   - exporting generated schema to database
2012-10-08 11:29:33,070 [2 - stream://in] INFO  SchemaExport                   - schema export complete
2012-10-08 11:29:33,568 [read #3 - Split] WARN  JDBCExceptionReporter          - SQL Error: 20000, SQLState: XSDA4
2012-10-08 11:29:33,568 [read #3 - Split] ERROR JDBCExceptionReporter          - An unexpected exception was thrown
2012-10-08 11:29:33,568 [read #3 - Split] WARN  JDBCExceptionReporter          - SQL Error: 0, SQLState: XJ001
2012-10-08 11:29:33,569 [read #3 - Split] ERROR JDBCExceptionReporter          - Java exception: 'A truncation error was encou
ntered trying to shrink CLOB '<stream-value>' to length 255.: org.apache.derby.iapi.services.io.DerbyIOException'.
2012-10-08 11:29:33,573 [read #3 - Split] ERROR DefaultTraceEventHandler       - Error processing trace event (original Exchan
ge will continue): Exchange[Message: TraceEventMessage[ID-D-113042471-63072-1349675952241-0-4] on node: bean://quoteService?me
thod=quote]
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: could not insert: [org.apache.ca
mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is javax.persistence.PersistenceException: org.hibernate
.exception.GenericJDBCException: could not insert: [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
        at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
.java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
ASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
:80)[camel-jpa-2.10.0.jar:2.10.0]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
ELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
mel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:117)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor.doProcessParallel(MulticastProcessor.java:715)[camel-core-2.10.0.jar:
2.10.0]
        at org.apache.camel.processor.MulticastProcessor.access$200(MulticastProcessor.java:80)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:297)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:282)[camel-core-2.10.0.jar:2.10.0]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
        at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
2012-10-08 11:29:33,592 [read #3 - Split] WARN  JDBCExceptionReporter          - SQL Error: 20000, SQLState: XSDA4
2012-10-08 11:29:33,592 [read #3 - Split] ERROR JDBCExceptionReporter          - An unexpected exception was thrown
2012-10-08 11:29:33,593 [read #3 - Split] WARN  JDBCExceptionReporter          - SQL Error: 0, SQLState: XJ001
2012-10-08 11:29:33,593 [read #3 - Split] ERROR JDBCExceptionReporter          - Java exception: 'A truncation error was encou
ntered trying to shrink CLOB '<stream-value>' to length 255.: org.apache.derby.iapi.services.io.DerbyIOException'.
2012-10-08 11:29:33,594 [read #3 - Split] ERROR DefaultTraceEventHandler       - Error processing trace event (original Exchan
ge will continue): Exchange[Message: TraceEventMessage[ID-D-113042471-63072-1349675952241-0-4] on node: ]
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: could not insert: [org.apache.ca
mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is javax.persistence.PersistenceException: org.hibernate
.exception.GenericJDBCException: could not insert: [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
        at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
.java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
ASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
:80)[camel-jpa-2.10.0.jar:2.10.0]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
ELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
mel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:117)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor.doProcessParallel(MulticastProcessor.java:715)[camel-core-2.10.0.jar:
2.10.0]
        at org.apache.camel.processor.MulticastProcessor.access$200(MulticastProcessor.java:80)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:297)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:282)[camel-core-2.10.0.jar:2.10.0]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
        at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
2012-10-08 11:29:35,439 [eTimeoutChecker] WARN  JDBCExceptionReporter          - SQL Error: 20000, SQLState: XSDA4
2012-10-08 11:29:35,439 [eTimeoutChecker] ERROR JDBCExceptionReporter          - An unexpected exception was thrown
2012-10-08 11:29:35,439 [eTimeoutChecker] WARN  JDBCExceptionReporter          - SQL Error: 0, SQLState: XJ001
2012-10-08 11:29:35,440 [eTimeoutChecker] ERROR JDBCExceptionReporter          - Java exception: 'A truncation error was encou
ntered trying to shrink CLOB '<stream-value>' to length 255.: org.apache.derby.iapi.services.io.DerbyIOException'.
2012-10-08 11:29:35,441 [eTimeoutChecker] ERROR DefaultTraceEventHandler       - Error processing trace event (original Exchan
ge will continue): Exchange[Message: TraceEventMessage[ID-D-113042471-63072-1349675952241-0-5] on node: stream://out]
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: could not insert: [org.apache.ca
mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is javax.persistence.PersistenceException: org.hibernate
.exception.GenericJDBCException: could not insert: [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
        at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
.java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
ASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
:80)[camel-jpa-2.10.0.jar:2.10.0]
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
ELEASE.jar:3.0.7.RELEASE]
        at org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
mel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
jar:2.10.0]
        at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
.10.0.jar:2.10.0]
        at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
10.0]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
]
        at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:86)[camel-core-2.10.0.jar:2.1
0.0]
        at org.apache.camel.processor.aggregate.AggregateProcessor$1.run(AggregateProcessor.java:425)[camel-core-2.10.0.jar:2.
10.0]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[:1.6.0_17]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
        at org.apache.camel.util.concurrent.SynchronousExecutorService.execute(SynchronousExecutorService.java:62)[camel-core-
2.10.0.jar:2.10.0]
        at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:78)[:1.6.0_17]
        at org.apache.camel.processor.aggregate.AggregateProcessor.onSubmitCompletion(AggregateProcessor.java:417)[camel-core-
2.10.0.jar:2.10.0]
        at org.apache.camel.processor.aggregate.AggregateProcessor.onCompletion(AggregateProcessor.java:401)[camel-core-2.10.0
.jar:2.10.0]
        at org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.onEviction(AggregateProcessor.java:69
2)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.onEviction(AggregateProcessor.java:65
9)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.support.DefaultTimeoutMap.purge(DefaultTimeoutMap.java:203)[camel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.purge(AggregateProcessor.java:671)[ca
mel-core-2.10.0.jar:2.10.0]
        at org.apache.camel.support.DefaultTimeoutMap.run(DefaultTimeoutMap.java:159)[camel-core-2.10.0.jar:2.10.0]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[:1.6.0_17]
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)[:1.6.0_17]
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)[:1.6.0_17]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98
)[:1.6.0_17]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:1
81)[:1.6.0_17]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)[:1.6
.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
        at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
No quote found for the input: Guru
Enter some words:

Best regards
Guru
@gnanagurus



Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Christian Mueller
Administrator
This is a known issue for OpenJPA + Derby.
You can find an example how to work around at [1] and [2].

[1]
https://svn.apache.org/repos/asf/camel/trunk/examples/camel-example-tracer/
[2]
https://svn.apache.org/repos/asf/camel/trunk/examples/camel-example-tracer/src/main/java/org/apache/camel/example/tracer/FixedDerbyDialect.java

Best,
Christian

On Mon, Oct 8, 2012 at 8:05 AM, Gnanaguru S <[hidden email]
> wrote:

>
> Hello Christian,
>
> After verifying with Derby. I altered the configuration in persistence.xml
> for derby. Now the application is connected with Derby. I can see the
> connectivity log.
>
> But when I run the example, Tracer was not able to store the message into
> the database. It throws this error message. Please let me know your
> thoughts.
>
> 2012-10-08 11:29:32,869 [2 - stream://in] INFO  SchemaExport
> - Running hbm2ddl schema export
> 2012-10-08 11:29:32,869 [2 - stream://in] INFO  SchemaExport
> - exporting generated schema to database
> 2012-10-08 11:29:33,070 [2 - stream://in] INFO  SchemaExport
> - schema export complete
> 2012-10-08 11:29:33,568 [read #3 - Split] WARN  JDBCExceptionReporter
> - SQL Error: 20000, SQLState: XSDA4
> 2012-10-08 11:29:33,568 [read #3 - Split] ERROR JDBCExceptionReporter
> - An unexpected exception was thrown
> 2012-10-08 11:29:33,568 [read #3 - Split] WARN  JDBCExceptionReporter
> - SQL Error: 0, SQLState: XJ001
> 2012-10-08 11:29:33,569 [read #3 - Split] ERROR JDBCExceptionReporter
> - Java exception: 'A truncation error was encou
> ntered trying to shrink CLOB '<stream-value>' to length 255.:
> org.apache.derby.iapi.services.io.DerbyIOException'.
> 2012-10-08 11:29:33,573 [read #3 - Split] ERROR DefaultTraceEventHandler
> - Error processing trace event (original Exchan
> ge will continue): Exchange[Message:
> TraceEventMessage[ID-D-113042471-63072-1349675952241-0-4] on node:
> bean://quoteService?me
> thod=quote]
> org.springframework.orm.jpa.JpaSystemException:
> org.hibernate.exception.GenericJDBCException: could not insert:
> [org.apache.ca
> mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is
> javax.persistence.PersistenceException: org.hibernate
> .exception.GenericJDBCException: could not insert:
> [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
>         at
>
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
> .java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
> .0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
> ASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
> .7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
> :80)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
> ELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
> -jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
> mel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
> jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
> .10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
> ]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.Pipeline.process(Pipeline.java:117)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
> .10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor.doProcessParallel(MulticastProcessor.java:715)[camel-core-2.10.0.jar:
> 2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor.access$200(MulticastProcessor.java:80)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:297)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:282)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
>         at
> java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
>         at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
> 2012-10-08 11:29:33,592 [read #3 - Split] WARN  JDBCExceptionReporter
> - SQL Error: 20000, SQLState: XSDA4
> 2012-10-08 11:29:33,592 [read #3 - Split] ERROR JDBCExceptionReporter
> - An unexpected exception was thrown
> 2012-10-08 11:29:33,593 [read #3 - Split] WARN  JDBCExceptionReporter
> - SQL Error: 0, SQLState: XJ001
> 2012-10-08 11:29:33,593 [read #3 - Split] ERROR JDBCExceptionReporter
> - Java exception: 'A truncation error was encou
> ntered trying to shrink CLOB '<stream-value>' to length 255.:
> org.apache.derby.iapi.services.io.DerbyIOException'.
> 2012-10-08 11:29:33,594 [read #3 - Split] ERROR DefaultTraceEventHandler
> - Error processing trace event (original Exchan
> ge will continue): Exchange[Message:
> TraceEventMessage[ID-D-113042471-63072-1349675952241-0-4] on node: ]
> org.springframework.orm.jpa.JpaSystemException:
> org.hibernate.exception.GenericJDBCException: could not insert:
> [org.apache.ca
> mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is
> javax.persistence.PersistenceException: org.hibernate
> .exception.GenericJDBCException: could not insert:
> [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
>         at
>
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
> .java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
> .0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
> ASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
> .7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
> :80)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
> ELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
> -jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
> mel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
> jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
> .10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
> ]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.Pipeline.process(Pipeline.java:117)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.Pipeline.process(Pipeline.java:80)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
> .10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor.doProcessParallel(MulticastProcessor.java:715)[camel-core-2.10.0.jar:
> 2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor.access$200(MulticastProcessor.java:80)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:297)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.MulticastProcessor$1.call(MulticastProcessor.java:282)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
>         at
> java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
>         at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
> 2012-10-08 11:29:35,439 [eTimeoutChecker] WARN  JDBCExceptionReporter
> - SQL Error: 20000, SQLState: XSDA4
> 2012-10-08 11:29:35,439 [eTimeoutChecker] ERROR JDBCExceptionReporter
> - An unexpected exception was thrown
> 2012-10-08 11:29:35,439 [eTimeoutChecker] WARN  JDBCExceptionReporter
> - SQL Error: 0, SQLState: XJ001
> 2012-10-08 11:29:35,440 [eTimeoutChecker] ERROR JDBCExceptionReporter
> - Java exception: 'A truncation error was encou
> ntered trying to shrink CLOB '<stream-value>' to length 255.:
> org.apache.derby.iapi.services.io.DerbyIOException'.
> 2012-10-08 11:29:35,441 [eTimeoutChecker] ERROR DefaultTraceEventHandler
> - Error processing trace event (original Exchan
> ge will continue): Exchange[Message:
> TraceEventMessage[ID-D-113042471-63072-1349675952241-0-5] on node:
> stream://out]
> org.springframework.orm.jpa.JpaSystemException:
> org.hibernate.exception.GenericJDBCException: could not insert:
> [org.apache.ca
> mel.processor.interceptor.jpa.JpaTraceEventMessage]; nested exception is
> javax.persistence.PersistenceException: org.hibernate
> .exception.GenericJDBCException: could not insert:
> [org.apache.camel.processor.interceptor.jpa.JpaTraceEventMessage]
>         at
>
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils
> .java:321)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)[spring-orm-3
> .0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[spring-tx-3.0.7.RELE
> ASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)[spring-orm-3.0.7.RELEASE.jar:3.0
> .7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:188)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:146)[spring-orm-3.0.7.RELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy$1.doInTransaction(JpaTemplateTransactionStrategy.java
> :80)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[spring-tx-3.0.7.R
> ELEASE.jar:3.0.7.RELEASE]
>         at
>
> org.apache.camel.component.jpa.JpaTemplateTransactionStrategy.execute(JpaTemplateTransactionStrategy.java:78)[camel
> -jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.component.jpa.JpaProducer.process(JpaProducer.java:50)[camel-jpa-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultTraceEventHandler.traceExchange(DefaultTraceEventHandler.java:117)[ca
> mel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.traceExchange(TraceInterceptor.java:291)[camel-core-2.10.0.
> jar:2.10.0]
>         at
>
> org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:151)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:330)[camel-core-2
> .10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:303)[camel-core-2.10.0.jar:2.10.0
> ]
>         at
>
> org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:45)[camel-core-2.10.0.jar:2
> .10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:86)[camel-core-2.10.0.jar:2.1
> 0.0]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor$1.run(AggregateProcessor.java:425)[camel-core-2.10.0.jar:2.
> 10.0]
>         at
>
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[:1.6.0_17]
>         at
>
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[:1.6.0_17]
>         at
> java.util.concurrent.FutureTask.run(FutureTask.java:138)[:1.6.0_17]
>         at
>
> org.apache.camel.util.concurrent.SynchronousExecutorService.execute(SynchronousExecutorService.java:62)[camel-core-
> 2.10.0.jar:2.10.0]
>         at
>
> java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:78)[:1.6.0_17]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor.onSubmitCompletion(AggregateProcessor.java:417)[camel-core-
> 2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor.onCompletion(AggregateProcessor.java:401)[camel-core-2.10.0
> .jar:2.10.0]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.onEviction(AggregateProcessor.java:69
> 2)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.onEviction(AggregateProcessor.java:65
> 9)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.support.DefaultTimeoutMap.purge(DefaultTimeoutMap.java:203)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.processor.aggregate.AggregateProcessor$AggregationTimeoutMap.purge(AggregateProcessor.java:671)[ca
> mel-core-2.10.0.jar:2.10.0]
>         at
>
> org.apache.camel.support.DefaultTimeoutMap.run(DefaultTimeoutMap.java:159)[camel-core-2.10.0.jar:2.10.0]
>         at
>
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[:1.6.0_17]
>         at
>
> java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)[:1.6.0_17]
>         at
> java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)[:1.6.0_17]
>         at
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98
> )[:1.6.0_17]
>         at
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:1
> 81)[:1.6.0_17]
>         at
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)[:1.6
> .0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[:1.6.0_17]
>         at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[:1.6.0_17]
>         at java.lang.Thread.run(Thread.java:619)[:1.6.0_17]
> No quote found for the input: Guru
> Enter some words:
>
> Best regards
> Guru
> @gnanagurus
>
>
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Camel-Tracer-example-Database-tp5720552p5720722.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>



--
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Gnanaguru S

Great Information Christian. It works fine with Derby now.



Best regards
Guru
@gnanaguru
Reply | Threaded
Open this post in threaded view
|

Re: Camel Tracer example - Database

Gnanaguru S
In reply to this post by Christian Mueller

Great Information Christian. It works fine with Derby now.



Best regards
Guru
@gnanagurus