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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Converting from BLOB to string" Watch "Converting from BLOB to string" New topic
Author

Converting from BLOB to string

Shane Lee
Ranch Hand

Joined: Mar 19, 2005
Posts: 63
Hi,
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: 3704
    
    5

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: http://www.google.com/search?q=jdbc+convert+blob+to+string

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: http://aspose.com/file-tools
 
subject: Converting from BLOB to string