Re: CSV to database

toCustomer.setCity(fromCustomer.getCity()); toCustomer.setStreet(fromCustomer.getStreet()); em.persist(toCustomer); } trans.commit(); em.close(); } And it works perfectly. Thank you for your help. Best, Idriss

Re: CSV to database

cutor$Worker.run(ThreadPoolExecutor.java:603)[:1.7.0_01] at java.lang.Thread.run(Thread.java:722)[:1.7.0_01] Thanks, Best, Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5039874.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

ent.FutureTask.run(FutureTask.java:166)[:1.7.0_01] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.7.0_01] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.7.0_01] at java.lang.Thread.run(Thread.java:722)[:1.7.0_0

Re: CSV to database

Of course. you find in attchement the source code for my example. http://camel.465427.n5.nabble.com/file/n5023529/camel-example-etl2.zip camel-example-etl2.zip Best, -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5023529.html Sent from the Camel -

Re: CSV to database

What I do in my processor is : I get the message using this: Message message = exchange.getIn(); PccCommoncard pcc = message.getBody(PccCommoncard.class); Then I instanciate OcPccCommoncard : OcPccCommoncard opcc = new OcPccCommoncard(); Then I fill the fields of this insta

Re: CSV to database

I don't know how I will do that. Can you explain that to me, please? Best, -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5018467.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

I tried with this : to("jpa:org.apache.camel.example.etl.IWIBO.OcPccCommoncard") But I have the following error : [ample.etl.BOPDEV.PccCommoncard] DefaultErrorHandlerERROR Failed delivery for exchangeId: ID-oulmakhzoune-PC-52598-1322086931344-0-459. Exhausted after delivery attempt:

Re: CSV to database

Hi Romain, Yes, in my processor I create EntityManagerFactory, EntityManager and EntityTransaction for each message. Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5017515.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

e.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:817) ... 31 more Do you know how I can resolve this? Thanks, Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5017505.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

is the cause of low performance?). Best, Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5015124.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

Thank you for your reply Christian, I managed to extract data from a database using JPA and insert them into another database using a Processor, but this procedure is very long. Is there a way to optimize the insertion of these data in the database? Regards Idriss -- View this message in

Re: CSV to database

Hi all, I try to extract data from a database and load it in an other database. I want to know is there a way to do this with came? Thank you Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5005300.html Sent from the Camel - Users mailing