Tuesday 5 August 2014

Solution for weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB cannot be cast to oracle.sql.BLOB

 

If you have a web application and it uses SQL to work with BLOB data types, you may run into the following error:

weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB cannot be cast to oracle.sql.BLOB

This is because Weblogic wrappes data types for some reason with his own classes. The solution is very simple . Go to the connection pool of your data source –> Advanced and uncheck “Wrap Data Types” check box

image