JB, this was cool, done very elegant implementation using saxon9-sql extension. Added ojdbc.jar and saxon9-sql.jar in smx main lib directory. It works fine.
but, currently I am hard-coding db url/user/pwd in xslt. If I can paramterise it would be great. Is there a way to specify parameter in properties file and refer the same in xslt? regards Brijesh N K Jean-Baptiste Onofré wrote: > > Thanks a lot Brijesh. > > Regards > JB > > brijesh wrote: >> 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-tp24592086p24697987.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
