I am new to camel.
I have a file that needs to be processed each day. It contains a list of members and it is in CSV (rob,12.30,yes,1). I want to iterate over each row in the file and insert the information into a sql DB. I am looking at using "unmarshal" and the "JDBC" in the route. What I am unsure on is the pattern for iterating over each line to do the insert. Should I be using "loop". Anybody got an example of iterating over a CSV file inserting rows into a DB? Thanks for your help.