aspose file tools*
The moose likes JDBC and the fly likes Converting from BLOB to string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Converting from BLOB to string" Watch "Converting from BLOB to string" New topic

Converting from BLOB to string

Shane Lee
Ranch Hand

Joined: Mar 19, 2005
Posts: 63
Im selecting back from oracle database a blob value which is my xml message.
My code to transform the blob to a string is:

This does work, Im just wondering if this is the most efficient/correct way of coverting the byte array to a string?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710

Some drivers support getString() on blobs although its risky to use because of encoding. In short, blob code is never that pretty. In your case, it does seem a little long. There's a number of examples available via Google:

I'm recommend trying the simplest one with your JDBC driver and goes whatever works. Keep in mind, string encoding can get ugly for reading blob data.

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: Converting from BLOB to string