Reading blob as XML

One Star

Reading blob as XML

HI,
I dont know whether this topic has been discussed. I want to extract the xml file which is stored as blob. I have wriiten a Java code for that (GetBlobfrommysql) in tjava and passing into tFileOutputXML, but am getting output as
<?xml version="1.0" encoding="ISO-8859-15"?>
<root>
<row>
<id>1</id>
<xmlfile>[B@1e3d24a</xmlfile>
</row>
</root>
the field xmlfile should return entire xml content but it is giving me some blob value [B@1e3d24a. Kindly help.

Thanks
One Star

Re: Reading blob as XML

Hi,
Now am able to get the file as xml in the given path using the code from http://www.talendforge.org/forum/viewtopic.php?pid=32862#p32862 . But i want to use the file in XSD validator as flow mode, instead of writing the file in some path in fileoutput stream, can we pass it to next flow?
Four Stars

Re: Reading blob as XML

Hi,
Can you create a simple getter setter routine, then you can pass it to even subjob...
Thanks
Vaibhav
One Star

Re: Reading blob as XML

Thanks Vaibhav, i will try that.
How to validate single xml file with multiple XSD using txsdvalidator. Am new to xml concepts.
Thanks
Four Stars

Re: Reading blob as XML