org.springframework.dao.DataAccessResourceFailureException

Could not create Oracle LOB; nested exception is 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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web209

  • via Spring JIRA by Abhishek Dhote, 1 year ago
    Could not create Oracle LOB; nested exception is 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
  • via Spring JIRA by Abhishek Dhote, 1 year ago
    Could not create Oracle LOB; nested exception is 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
  • via Coderanch by Kristof Camelbeke, 6 months ago
    Could not create Oracle LOB; nested exception is java.lang.NullPointerException: null java.lang.NullPointerException
  • Stack trace

    • org.springframework.dao.DataAccessResourceFailureException: Could not create Oracle LOB; nested exception is 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 at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:368)[na:na] at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setBlobAsBytes(OracleLobHandler.java:220)[na:na] at com.hp.exstream.cc.dao.util.BlobActionType.nullSafeSetInternal(BlobActionType.java:96)[na:na] at org.springframework.orm.hibernate3.support.AbstractLobType.nullSafeSet(AbstractLobType.java:180)[na:na] at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:169)[na:na] at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2025)[na:na] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2271)[na:na] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)[na:na] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)[na:na] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)[na:na] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)[na:na] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)[na:na] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)[na:na] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)[na:na] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)[na:na] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)[na:na] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)[na:na] at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)[org.springframework.orm-2.5.6.jar:2.5.6] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)[org.springframework.transaction-2.5.6.jar:2.5.6] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)[org.springframework.transaction-2.5.6.jar:2.5.6] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)[org.springframework.transaction-2.5.6.jar:2.5.6] at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:na] at java.lang.reflect.Method.invoke(Unknown Source)[na:1.5.0_11] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)[na:na] at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)[na:na] at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)[na:na] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)[na:na] at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)[na:na] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.transaction.support.TransactionTemplate$$EnhancerByCGLIB$$2e8c72f0.execute(<generated>)[na:na] at com.hp.exstream.cc.server.actions.chain.ActionHandlerTransactionProxy.handleAction(ActionHandlerTransactionProxy.java:49)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.chain.ActionHandlerTransactionProxy$$FastClassByCGLIB$$b074e067.invoke(<generated>)[na:na] at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)[com.springsource.net.sf.cglib-2.1.3.jar:na] at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)[na:na] at com.hp.exstream.cc.server.aspects.UserRightsChecker.handleCreateEntityAction(UserRightsChecker.java:656)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.aspects.UserRightsChecker.handleScheduleAction(UserRightsChecker.java:383)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.aspects.UserRightsChecker.checkActionHandling(UserRightsChecker.java:126)[cc-server-1.0.0.24.jar:1.0.0.24] at sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:na] at java.lang.reflect.Method.invoke(Unknown Source)[na:1.5.0_11] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)[na:na] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)[na:na] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)[na:na] at com.hp.exstream.cc.server.aspects.LicenseChecker.checkActionHandling(LicenseChecker.java:204)[cc-server-1.0.0.24.jar:1.0.0.24] at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:na] at java.lang.reflect.Method.invoke(Unknown Source)[na:1.5.0_11] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)[na:na] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)[na:na] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)[na:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)[org.springframework.aop-2.5.6.jar:2.5.6] at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)[org.springframework.aop-2.5.6.jar:2.5.6] at com.hp.exstream.cc.server.actions.chain.ActionHandlerTransactionProxy$$EnhancerByCGLIB$$88dc6775.handleAction(<generated>)[na:na] at com.hp.exstream.cc.server.actions.chain.AbstractActionHandler.handleAction(AbstractActionHandler.java:21)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.chain.ActionHandlerLockProxy.handleAction(ActionHandlerLockProxy.java:26)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.chain.ActionHandlerJamonProxy.handleAction(ActionHandlerJamonProxy.java:41)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.ActionExecutionServiceImpl.executeAction(ActionExecutionServiceImpl.java:68)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.ThreadPoolActionExecutionServiceImpl$1.call(ThreadPoolActionExecutionServiceImpl.java:71)[cc-server-1.0.0.24.jar:1.0.0.24] at com.hp.exstream.cc.server.actions.ThreadPoolActionExecutionServiceImpl$1.call(ThreadPoolActionExecutionServiceImpl.java:70)[cc-server-1.0.0.24.jar:1.0.0.24] at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)[na:1.5.0_11] at java.util.concurrent.FutureTask.run(Unknown Source)[na:1.5.0_11] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)[na:1.5.0_11] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[na:1.5.0_11] at java.lang.Thread.run(Unknown Source)[na:1.5.0_11] 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 at org.springframework.jdbc.support.lob.OracleLobHandler.initOracleDriverClasses(OracleLobHandler.java:164)[na:na] at org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.createLob(OracleLobHandler.java:339)[na:na] ... 80 more Caused by: java.lang.ClassNotFoundException: oracle.sql.BLOB at org.apache.felix.framework.searchpolicy.ModuleImpl.findClassOrResourceByDelegation(ModuleImpl.java:627)[na:na] at org.apache.felix.framework.searchpolicy.ModuleImpl.access$100(ModuleImpl.java:61)[na:na] at org.apache.felix.framework.searchpolicy.ModuleImpl$ModuleClassLoader.loadClass(ModuleImpl.java:1469)[na:na] at java.lang.ClassLoader.loadClass(Unknown Source)[na:1.5.0_11] at org.springframework.jdbc.support.lob.OracleLobHandler.initOracleDriverClasses(OracleLobHandler.java:150)[na:na] ... 81 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.