How to get Outputstream from oracle blob

[Faraz Ahmad]

Hi,

i am using oracle10g and Weblogic 10(Java 5)

Follwing is the snippet of code :

ResultSet rSet;
.
.
.
.
.
Blob blob1 = rSet.getBlob(1);

oracle.sql.BLOB blob2 = (oracle.sql.BLOB)blob1;

OutputStream os = blob2.getBinaryOutputStream();

Here is the exception i m getting.

java.lang.ClassCastException: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB

at line typecasting blob1 to blob2.

Can anyone help me out?

[Jeanne Boyarsky]

Faraz,
Welcome to JavaRanch!

This code snippet is dangerous as it relies on a specific implementation

Blob blob1 = rSet.getBlob(1);

oracle.sql.BLOB blob2 = (oracle.sql.BLOB)blob1;

OutputStream os = blob2.getBinaryOutputStream(); 

The ResultSet interface provides a method to get the binary stream directly. Why not just use that?

[Jan Cumps]

What Jeanne said. If you follow her approach, you 'll get your data.

About your error.
Blob blob1 can't be casted into an oracle.sql.BLOB.
The returned BLOB you got from rSet.getBlob(1) is not convertible to oracle.sql.BLOB.