Oracle driver compatibility

[Former Member]

Hi,

We have an application which writes to Oracle BLOBs.

This is part of a stored procedure call from our application.

However, when trying to write the following exception is thrown:

java.lang.ClassCastException: class oracle.sql.BLOB:library:ORACLE_DRIVER@com.sap.engine.boot.loader.ResourceMultiParentClassLoader@4f4a1ab7@alive incompatible with class oracle.sql.BLOB:library:core_lib@com.sap.engine.boot.loader.ResourceMultiParentClassLoader@16ba8602@alive

It seems to me that there are multiple version of the oracle classes in the system, and this is causing issues.

ORACLE_DRIVER in the above error is the custom jdbc driver which was uploaded (ojdbc14.jar) which our datasource uses.

The datasource is working as data has been inserted into the database.

Any ideas?

Should we use a different driver? Should we be deploying different classes?

Regards,

Andrew

[Vlado · Accepted solution]

Please follow [this thread|;.