Re: problem processing CSV to Database (camel-csv and camel-sql)

Hello Claus... thank you very much. That worked like a charm. My best regards. Vinícius. -- View this message in context: http://camel.465427.n5.nabble.com/problem-processing-CSV-to-Database-camel-csv-and-camel-sql-tp5735821p5735852.html Sent from the Camel - Users mailing list archive at

Re: problem processing CSV to Database (camel-csv and camel-sql)

irst_name` varchar(45) CHARACTER SET latin1 NOT NULL, > `last_name` varchar(45) CHARACTER SET latin1 DEFAULT NULL, > `email` varchar(45) CHARACTER SET latin1 NOT NULL, > `active` bit(1) DEFAULT b'1', > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$ > >

problem processing CSV to Database (camel-csv and camel-sql)

s message in context: http://camel.465427.n5.nabble.com/problem-processing-CSV-to-Database-camel-csv-and-camel-sql-tp5735821.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

It looks really odd for me... 1) You select the Customers twice (in your polling JPA endpoint and in your processor) 2) You create a new EntityManagerFactory each time the processor is called. All what you should have to do is: from("jpa://Customer") .process(new MyConverter()) .to("jpa://Cus

Re: CSV to database

-- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5041482.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

va: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_01] > > Thanks, > Best, > Idriss > > -- > View this message in context: > http://c

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

utureTask.java:334)[:1.7.0_01] >        at java.util.concurrent.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$Wor

Re: CSV to database

1] Thank you very much for your help. Best, Idriss -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5038173.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

amel-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 - Users mailing list archive at Nabble.com. >

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

tBody(PccCommoncard.class); > > > > Then I instanciate OcPccCommoncard : > > OcPccCommoncard opcc = new OcPccCommoncard(); > > > > Then I fill the fields of this instance (opcc). > > > > > > -- > > View this message in context: > > http://camel.4

Re: CSV to database

ommoncard.class); > > Then I instanciate OcPccCommoncard : > OcPccCommoncard opcc = new OcPccCommoncard(); > > Then I fill the fields of this instance (opcc). > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/CSV-to-database-tp44357

Re: CSV to database

instance (opcc). -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5018527.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

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 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

at > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)[:1.7.0_01] >at > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)[: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_01] > > > Best, > > -- > View this message in context: > http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5018419.html > Sent from the Camel - Users mailing list archive at Nabble.com. >

Re: CSV to database

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_01] Best, -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5018419.html Sent from the Camel - Users ma

Re: CSV to database

t(DefaultRouteContext.java:110) >at > > org.apache.camel.impl.DefaultRouteContext.resolveEndpoint(DefaultRouteContext.java:116) >at > > org.apache.camel.model.SendDefinition.resolveEndpoint(SendDefinition.java:61) >at > > org.apache.camel.model.SendDefinition.createProcessor(SendDefinitio

Re: CSV to database

his 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

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

ger.begin() and > myTransManager.commit(), > and I think that 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

n the class MyProcess I'm using EntityManagerFactory, EntityManager > and > TransactionManager (with myTransManager.begin() and > myTransManager.commit(), > and I think that is the cause of low performance?). > > > > Best, > > Idriss > > -- > View this message in

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

ing 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 context: > http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5010354.html > Sent from the Camel - Users mailing list archive at Nabble.com. >

Re: CSV to database

context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p5010354.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

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 list archive at Nabble.com. >

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

Re: CSV to database

Thanks Claus... I was able to do that everything is working fine now :) -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p4437055.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

t; -- > View this message in context: > http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p4436846.html > Sent from the Camel - Users mailing list archive at Nabble.com. > -- Claus Ibsen - FuseSource Email: cib...@fusesource.com Web: http://fusesource.com C

Re: CSV to database

;beans)? If yes can you provide me some sample code snippet for the route?? Thanks in advance -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p4436846.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: CSV to database

ot;camelinaction") .split(body()) .to("jpa:camelinaction.PurchaseOrder"); Something like above, where we use the split and tell Camel to split the message body. (It knows how to iterate the list from the body) > thanks in advance > > -- > View this messag

CSV to database

ot;jpa:camelinaction.PurchaseOrder") Its giving type mismatch error as the bindy is returning list and jpa component is awaiting a bean. Any help will be appreciated... thanks in advance -- View this message in context: http://camel.465427.n5.nabble.com/CSV-to-database-tp4435750p4435750.h