Michael O'Connor

Lines 26 - 32 were there so I could print out as a string what I was reading back from the database to check if it was valid.

Line 33 introduced a new stream to read the data again as you cannot reuse the existing stream as it has already read the data, this was giving another error.

While aesthetically correct neither of these points are relevant to the issue at hand.

I did manage to fix this however by changing how I was reading the stream in & also by fixing up my data.

Thanks for the comments.

Hi Guys,

I have a simple webservice which has one method which saves an xml 'string' as a blob.
Another method then reads this back in, attempts to parse it & then change a value in it.
Once this is done I want to pass this string on to another class. I do not want to create any files.

However when parsing the XML I have been getting constant errors, the latest of which is:

SAXParseException: XML document structures must start and end within the same entity.

This gets thrown by the line: Document doc = builder.parse(newInputStream);

I have read the input in as a string so I can see that the data looks ok & is all present.

Any help would be greatly appreciated.

The code is below:
Connection conn = null; Statement stmt = null; ResultSet rs = null; int returnValue = 0; java.sql.Blob blob; String blobData="Unset"; InputStream inputStream = null; InputStream newInputStream = null; try { DriverManager.registerDriver(new OracleDriver()); conn = DriverManager.getConnection("jdbc:oracle:thin:@dbname:port#:dev", "user", "pwd"); conn.setAutoCommit(false); stmt = conn.createStatement(); String query = "SELECT FileName, FileData FROM tblBlobDemo WHERE FileName= \'" + fileName + "\'"; rs = stmt.executeQuery(query); if(rs.next()) { blob = ((ResultSet)rs).getBlob("FileData"); //Read Input stream from blob data inputStream =blob.getBinaryStream(); //Reading the inputstream of data into an array of bytes. byte[] bytes = new byte[(int)blob.length()]; inputStream.read(bytes); //Get the String object from byte array. blobData = new String(bytes); newInputStream =blob.getBinaryStream(); // Read xml and build a DOM document DocumentBuilder builder = DocumentBuilderFactory.newInstance().newDocumentBuilder(); //The exception is thrown at this line //Document doc = builder.parse(new InputSource(newInputStream)); Document doc = builder.parse(newInputStream); // Use XPath to find all nodes named 'IsAlternateOutputPath' XPath xpath = XPathFactory.newInstance().newXPath(); NodeList nodes = (NodeList)xpath. evaluate("//IsAlternateOutputPath", doc, XPathConstants.NODESET); // Rename these nodes for (int idx = 0; idx < nodes.getLength(); idx++) { nodes.item(idx).setTextContent("1"); } // Write the DOM document to the file Transformer xformer = TransformerFactory.newInstance().newTransformer(); xformer. transform(new DOMSource(doc), new StreamResult(blobData)); } return blobData; } catch (Exception e) { Log.error(this, e); throw e;