Brijesh,
For this use case, you could use servicemix-bean or servicemix-camel
service to get the required field values from the database and add them
to the message before sending it to the xsl endpoint.
I don't know about Oracle XSQL, but if you start and control this from
Java code, you could use that as well from within servicemix-bean.
Regards,
Gert
brijesh schreef:
Hello there ,
One of my integration scanario, i have following requirment
I have xml file getting from external application, which i need to convert
into different format , but some of the element i need to pick from database
. eg, i would be getting an id ,for which i need to get mapping id from
staging database table. my requirment is conversion of xml structure along
with few of the data from database.
I do understand , i can use xslt component for xml transformation, but I
also need to interact with database to get the mapping field values, which
component will i use for this?, is it possible to use xsql from oracle for
this scenario?. I searched in the website i couldn't see much documentation
on this,
any thoughts on this?
thanks
brijesh
