JB, thanks for the response & help, will try and update you.
regards Brijesh N K Jean-Baptiste Onofré wrote: > > Hi Brijesh, > > you have three ways to do it: > - in you saxon SU pom.xml, you can add a dependency to the saxon9-sql.jar. > - you can put the jar where you want and use the > <classpath><location>/path/to/saxon9-sql.jar</location></classpath> in > your saxon xbean.xml. > - you can put in the main SMX classpath (in the lib directory). > > Regards > JB > > brijesh wrote: >> 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-tp24592086p24624651.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
