topic Reading blob as XML in Talend Studio

Reading blob as XML

AbiJeev — Wed, 02 Apr 2014 13:25:11 GMT

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

Re: Reading blob as XML

AbiJeev — Thu, 03 Apr 2014 07:21:33 GMT

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?

Re: Reading blob as XML

Anonymous — Thu, 03 Apr 2014 08:19:05 GMT

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

Re: Reading blob as XML

AbiJeev — Thu, 03 Apr 2014 12:32:12 GMT

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

Re: Reading blob as XML

Anonymous — Mon, 07 Apr 2014 12:57:03 GMT

Hi,
have you checked - https://help.talend.com/search/all?query=tXSDValidator&content-lang=en
Thanks
Vaibhav