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?
Joined: Jan 17, 2006
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.