Hey Robbin, Have you read http://camel.apache.org/bean-integration.html ? If so, could you explain a bit more about which part of bean invocation you find confusing?
Kind regards, Geert Schuring. 2011/8/21 Robbin <[email protected]> > Hello, > > I've been struggling for a week or two to find an example that fits my > situation. > > I've successfully written a number of camel routes and deployed them in > servicemix 4.3. > > I wrote a camel route that receives an email with XML paragraphs in it. > Another camel route splits the XML into individual paragraphs and sends > each > one to a seda queue for use in another camel route. > > I want write that other camel route to receive that message and create a > record in a mysql table. Eventually I want to write other consumers of that > paragraph, but I'm starting with this task. > > I think I want servicemix to manage the connections to the database and not > just use JDBC inside my bean which would sort of defeat the point of using > an ESB. > > Since there are multiple data items, I can't substitute using "#" in a sql > component. I read that a bean that emits the insert command would be easy. > Not for me. I've seen an example where an XPath annotation preceding the > arguments in the bean would decode each data item, and in the java code I > construct the insert statement in a single line of code. That looks like > the > ticket. > > I think I need to: > > 1. Use maven to create a java project > 2. Write my pojo with the XPath decoding the body and then construct the > sql > insert command > 3. Use maven install to create my jar file > 4. Copy the jar file to servicemix/deploy > 5. Write a camel DSL route: > <from uri="seda://myqueue" /> > <bean sqlinsert ... confuses me /> > <to sql ... confuses me more /> > 6. Copy it to servicemix/deploy > 7. use it > > I've read about idempotent, jdbc, jpa, ibatis and probably more. I just > can't get my head around linking the method in my pojo to a route in my > Camel DSL. > > Please suggest a way forward. The only way through learning servicemix and > camel may be to keep trying until I succeed, but after a week or two of > trying, I need a little help. > > Kind regards, > RC > > PS, I was hoping that using XML would make it easy to inspect and > manipulate > the data elements from inside a camel route via simple EL, but that is > beyond me as well. > > -- > View this message in context: > http://servicemix.396122.n5.nabble.com/servicemix-camel-and-a-bean-tp4720609p4720609.html > Sent from the ServiceMix - User mailing list archive at Nabble.com. > > >
