Hi there, maybe I am running totally in the wrong direction because I'm a Camel rookie. But what I try to do is the following: I have database table of orders and a 2nd db table of order lines. A single order may have 100000 order lines. Each order with all its order lines has to be stored in single csv files.
My idea to achieve that was to use the Camel JPA component to read the orders. This is very suitable because the orders have a "status" field which can be updated by the JPA component. I've managed to build the individual csv files and to fill them with the order informations. But now I'm running into trouble. The table with the order lines can't be read by the JPA component because this component is only running in a sort of polling mode - it would be easier for me if this component could be started just like the jdcb or the sql component. So, I tried to implement a jdbc or a sql component. But now I don't know how to set up their connection parameters from the configuration of the JPA component. Is there a way to get the datasource of the JPA component and to stuck it into the SQL or der JDBC component? Or did I oversee something, and my problem could be solved in a completely different way? Many thanks in advance for any help! Christian -- View this message in context: http://camel.465427.n5.nabble.com/how-to-read-a-large-amount-of-data-in-a-2nd-step-tp5731752.html Sent from the Camel - Users mailing list archive at Nabble.com.
