Use of BLOB giving "java.lang.ClassNotFoundException: oracle.sql.BLOB" in case of SPRING-Hibernate application in case of ORACLE as a database!

Question

Hi all,

I am using BLOBs in my SPRING-Hibernate application its, giving "java.lang.ClassNotFoundException: oracle.sql.BLOB" in case of ORACLE as a database!

Exactly I am getting following:

Caused by: 
org.springframework.dao.InvalidDataAccessApiUsageException: Couldn't initialize OracleLobHandler because Oracle driver classes are not available. Note that OracleLobHandler requires Oracle JDBC driver 9i or higher!
nested exception is java.lang.ClassNotFoundException: oracle.sql.BLOB

Answer 1

You need ojdbc.jar (or similar) on your classpath (this is the Oracle JDBC driver)

Here is a list of drivers, pick the one that suits your environment.

Answer 2

Maybe your OSGI manifest does not export the right packages?

Answer 3

I'm having the same problem :-\

Using:

ECLIPSE DN 2.2.0-m1 Oracle 10g Express Edition ojdbc6.jar (tried ojdbc14.jar)

Anyone resolved this issue?