xml data from database using jdbc

[Former Member]

I should get the xml data from database. Is this scenario possible using jdbc adapter ? If possible, how can I get it ?. Plz help me

[baskar_gopalakrishnan2]

It is possible. What is the data type of the column in the table? You might be using varchar2 or clob or blob. If the volume of the data is small you can use simple XSD type string in the pi field and write into it. Use jdbc sender and write query to return the resultset of that field and map it to the string field on the target.

[Former Member]

I suppose that probably, xml data are stored in a BlobImage Field.

You can use a Stored Procedure on Database Side, to select and put out the xml data structured in output fields or structures.

From JDBC Sender channel, you can call the SP, that raise out a Structure formatted like the XML Data stored in Xml Database field.

In your opinion, this should be a possible way to achieve this issue?