Java.lang.ClassCastException: oracle.sql.BLOB cannot be cast to oracle.sql.BLOB

blobjavaoracle

I have problem retrieving a blob object from oracle DB to java API with jdbc.
The problem is when I execute a Collable statement with a function from the db which return me a blob field this exception is thrown on the line :

tempBlob = (oracle.sql.BLOB)cstmt.getObject(1);

with this error message :

java.lang.ClassCastException: oracle.sql.BLOB cannot be cast to oracle.sql.BLOB. 

The object which I get from the DB is a instance of oracle.sql.BLOB. The tempBlob
variable is a object oracle.sql.BLOB. Where is the problem?

Best Answer

Two oracle jar files may be in your classpath. Please remove one jar and deploy again.