>From my point of view, I think that a possible solution is to use routing of several cxfse components.
If you need basic XSL transformation on the XML, you can use the Saxon component. After this first transformation, you can route the message using Camel into several cxfse components containing POJO to query on the database. It's only an idea, I think that the SMX guys will give you a more concrete way to implements your solution. Regards JB -- Jean-Baptiste Onofré [EMAIL PROTECTED] BuildProcess/AutoDeploy Project Leader http://buildprocess.sourceforge.net On Thu 30/10/08 12:41, "brijesh" [EMAIL PROTECTED] wrote: > > Hello there , > > One of my integration scanario, i have following requirment > > I have xml file getting from external application, which i need to > convert into different format , but some of the element i need to pick from > database . eg, i would be getting an id ,for which i need to get mapping id > from staging database table. my requirment is conversion of xml structure > along with few of the data from database. > > I do understand , i can use xslt component for xml transformation, but > I also need to interact with database to get the mapping field values, > which component will i use for this?, is it possible to use xsql from oracle > for this scenario?. I searched in the website i couldn't see much > documentation on this, > > any thoughts on this? > > thanks > > brijesh > > > > -- > View this message in context: http://www.nabble.com/XML-transformation-jdbc-tp20245216p202452 > 16.html Sent from the ServiceMix - User mailing list archive at Nabble.com. > > > >