convert a db blob of xml into a jdom XML object

[Christopher Whu]

i inherited a database that has full xml documents stored as blobs. The blobs look very similar to:
<?xml version="1.0"?> <catalog> <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description>An in-depth look at creating applications with XML.</description> </book> </catalog>

is there any easy way to convert this blob info into a jdom xml object? thanks in advance!

[Paul Clapham]

If you can convert it to something which JDOM can read from -- like an InputStream, for example -- then yes. And there is a way to get an InputStream from a PreparedStatement; check out the documentation for that class.

[Christopher Whu]

TY sir. This helped alot