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
