2

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
Improve this question
5
  • I tried with all the ORACLE JDBC dirver versions [9i and 10g] almost all the releases! If you can tell me the specific version then that will be great! Commented Feb 24, 2010 at 9:12
  • 1
    how did you try? How do you put them on your classpath? Where is your configuration? Commented Feb 24, 2010 at 9:15
  • In fact I am using OSGI, so I create a bundle wrapper and put it into the classpath! Commented Feb 24, 2010 at 9:21
  • then you have classpath issues with OSGi. Commented Feb 24, 2010 at 9:29
  • But it is able to load other classes from ORACLE jdbc driver! I mean everything else apart from BLOB stuff works properly! Commented Feb 24, 2010 at 10:03

2 Answers 2

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Maybe your OSGI manifest does not export the right packages?

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.