XML transformation jdbc

[brijesh <br...@gmail.com>]

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 
 


-- 
View this message in context: http://www.nabble.com/XML-transformation-jdbc-tp20245216p20245216.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.

Re: XML transformation jdbc

[raulvk <ra...@gmail.com>]

You could use the iBATIS Framework to access the database.

iBATIS takes and returns the data in a Java Object, which you could marshal
and unmarshal using XStream.

Both frameworks are very lightweight and you could use them inside a Bean,
via the servicemix-bean component.

Another possibility is to use Camel, which already has support for iBATIS
and XStream. However, we ruled out this possibility because at the moment
there was a bug in Camel due to which a message received via JBI could not
be transformed to an Object. If I were you, I would check this out because
the bug has been resolved recently.

Hope this helps.


2008/10/30 Gert Vanthienen <ge...@skynet.be>

> 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
>>
>>
>>
>
>

Re: XML transformation jdbc

[Gert Vanthienen <ge...@skynet.be>]

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 
>  
>
>
>