wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes Blob formatted in XML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Blob formatted in XML" Watch "Blob formatted in XML" New topic
Author

Blob formatted in XML

vikranth patoju
Greenhorn

Joined: Nov 21, 2007
Posts: 3
Hi,
i wrote a code which gets the blob object from the database and using the bufferedinputstream i read the blob as bytestream.

Blob b = rs.getBlob("TCblob");
String XmlString = "";
BufferedInputStream bis = new BufferedInputStream(b.getBinaryStream());
byte []bt = new byte[50];
XmlString = "<Request><row>" + bt+ "</row></Request>";
System.out.println(XmlString);
processXml(XmlString);

In the method processXMl

NodeList ls1 = doc.getElementsByTagName("row");

String b = ls1.item(0).getFirstChild().getNodeValue();
byte [] bt = b.getBytes();
System.out.println(bt);

problem here is i found both byte arrays are different by printing on the console. So how to get the same data throught parsing the XML??
please reply..
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Blob formatted in XML