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
