File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Blob formatted in XML" Watch "Blob formatted in XML" New topic

Blob formatted in XML

vikranth patoju

Joined: Nov 21, 2007
Posts: 3
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>";

In the method processXMl

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

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

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..
I agree. Here's the link:
subject: Blob formatted in XML
jQuery in Action, 3rd edition