JB, I was trying with saxon SQL engine, But It require to have an additional jar (saxon9-sql.jar). Where will put this jars to have reference in smx-saxon JBI component , while running smx. thanks & regards Brijesh N K
brijesh wrote: > > JB , > > thanks a lot for the response , will look into the link you provided. > > thanks & 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-tp24592086p24624428.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
