JB, just a thought , can't we use Saxon's SQL extensions with xslt ?? .
regards Brijesh N K Jean-Baptiste Onofré wrote: > > Hi Brijesh, > > Saxon provides support XSLT, XPath and XQuery. So it works only on the > XML message content. If you want to get an id from the XML, query a > database to get data corresponding to the id, and add in the output XML, > you can't do it only with saxon. > > Nevertheless, you can use servicemix-bean to add a home made endpoint > querying on the database and return back a XML. This servicemix-bean > endpoint can be called by a saxon endpoint that parse/extract data from > the in XML. The out XML can be routed to another saxon endpoint to apply > some transformation. > > I have added a sample to query a database using servicemix-bean > component (waiting for the servicemix-jdbc component :)). > It's here: > http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/ > > Regards > JB > > brijesh wrote: >> hello , >> >> one of my usecase , i use smx saxon component for data transformation. >> While transformation I need to get the data mapping id from a database, >> Need >> to substitute internal id to external id. >> >> Is this possible same smx saxon component?. Anybody tried to implement >> this? >> >> >> regards >> Brijesh N K > > -- > Jean-Baptiste Onofré > --------------------------------- > HomePage > http://www.nanthrax.net > --------------------------------- > Contacts > [email protected] > [email protected] > --------------------------------- > OpenSource > BuildProcess/AutoDeploy > http://buildprocess.sourceforge.net > Apache ServiceMix > http://servicemix.apache.org > ----------------------------------- > PGP : 17D4F086 > > -- View this message in context: http://www.nabble.com/smx-saxon-and-jdbc-tp24592086p24597202.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
