JB, Will try and get back to you
regards Brijesh N K Jean-Baptiste Onofré wrote: > > Hi Brijesh, > > Good idea. > I never try it but I don't see any reason why you couldn't :) > > Regards > JB > > brijesh wrote: >> 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-tp24592086p24601484.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
