wood burning stoves 2.0*
The moose likes JDBC and the fly likes Problem when readin blob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem when readin blob" Watch "Problem when readin blob" New topic
Author

Problem when readin blob

dnyan ginde
Ranch Hand

Joined: Jan 17, 2006
Posts: 68
Hello,

I am inserting a blob in my Oracle DB.I first insert an empty_blob() and then update this same empty_blob with a pdf file.This is how i update it:

I am then trying to read this blob with the following code:


the problem is that when i am reading the blob, the blob object is coming as null and hence i am getting a null pointer exception. Can anybody tell me where i am going wrong?
Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
have you tried the getBlob method of java.sql.ResultSet, or tried avoiding java.sql.Blob and using getBinaryStream or getBytes?


There is no emoticon for what I am feeling!
dnyan ginde
Ranch Hand

Joined: Jan 17, 2006
Posts: 68
Hello,

Yes i have tried using getBinaryStream() and getBytes() methods but the InputStream and the byte[] is coming as null. When i am inserting the blob into the DB i am getting no exception and that makes me feel asthough the blob is getting inserted properly. But then again when i am retrieving it why is it coming as null. Any suggestions?
dnyan ginde
Ranch Hand

Joined: Jan 17, 2006
Posts: 68
Guys, after struggling with the Blob for quite a long time ive finally inserted and retrieved the blob. Just for your information Oracle just accepts Blob/Clob instances created via its own proprietary BLOB/CLOB API, and additionally doesn't accept large streams for PreparedStatement's corresponding setter methods. So anybody out there facing problems with blob or clob please use Oracle API's if your database is Oracle.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem when readin blob