Re: how to build a sql insert route from xml payload

2012-03-02 Thread shin938
Thanks. I did try it with setting headers first but then I had a problem: because I transformed the pax logging event to a pojo and then to xml with xstream, if for example there was no exception then there was no field in the xml and I wouldn't know how to design the query. at the end I did it wit

Re: how to build a sql insert route from xml payload

2012-03-02 Thread Babak Vahdat
The Fusesource video is fŠ awsome! Unbelievable what James & Co. has made out of the Fuse-IDE Tool! Congratulations :-) I'm really impressed! Babak Am 02.03.12 09:20 schrieb "Claus Ibsen" unter : >On Thu, Mar 1, 2012 at 7:23 PM, shin938 wrote: >> Hi Claus >> Thank you for the quick response.

Re: how to build a sql insert route from xml payload

2012-03-02 Thread Claus Ibsen
On Thu, Mar 1, 2012 at 7:23 PM, shin938 wrote: > Hi Claus > Thank you for the quick response. > aside from mybatis or velocity , I understand it wouldn't be possible > with the xpath language? You may be able to do some pieces with a scripting language ala groovy, but it will just get a bit messy

Re: how to build a sql insert route from xml payload

2012-03-01 Thread shin938
Hi Claus Thank you for the quick response. aside from mybatis or velocity , I understand it wouldn't be possible with the xpath language? if I had a java bean in my queue I could do it with the in.body language right? Thanks. On 03/01/12 19:52, Claus Ibsen-2 [via Camel] wrote: > Hi > > Just use a

Re: how to build a sql insert route from xml payload

2012-03-01 Thread Claus Ibsen
Hi Just use a java bean and use java code to build the SQL. Or a template language such as velocity / freemarker. But often a java bean can do the trick in 5 lines of code. For more complicated SQL, then MyBatis have a java based SQL builder which looks cool. They also offer a XML templates to b