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

2 comments:

  1. do I need to restart the server, after changes. Because I change it but still the same exception

    ReplyDelete