• Post Reply Bookmark Topic Watch Topic
  • New Topic

convert a db blob of xml into a jdom XML object

 
Christopher Whu
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i inherited a database that has full xml documents stored as blobs. The blobs look very similar to:


is there any easy way to convert this blob info into a jdom xml object? thanks in advance!
 
Paul Clapham
Sheriff
Posts: 21972
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
TY sir. This helped alot
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!