java.lang.ClassCastException: oracle.sql.CLOB cannot be cast to oracle.sql.CLOB

[vandiesel]

Hi,

I have included ojdbc6.jar in global modules folder and in oracle module folder.

I am getting this exception. When I remove one copy of ojdbc6.jar from global modules jboss 7.1 server says NoClassDefFoundError

Caused by: java.lang.NoClassDefFoundError: oracle/sql/CLOB

    at com.mysedan.service.profile.dao.ProfileDAOImpl.updateProfile(ProfileDAOImpl.java:3764)

When I keep multiple copies , I get the following exception. Please let me know how to address the issue

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4) java.lang.ClassCastException: oracle.sql.CLOB cannot be cast to oracle.sql.CLOB

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.mysedan.service.profile.dao.ProfileDAOImpl.updateProfile(ProfileDAOImpl.java:3796)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.mysedan.service.profile.ejb.ProfileEJB.updateProfile(ProfileEJB.java:1288)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at java.lang.reflect.Method.invoke(Method.java:606)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,262 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:202)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:306)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:80)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,278 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$1.processInvocation(EjbExceptionTransformingInterceptorFactories.java:65)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:179)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:179)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:43)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:128)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:136)

18:12:10,293 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:121)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:104)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.sun.proxy.$Proxy25.updateProfile(Unknown Source)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.mysedan.application.limonet.control.ejb.AccountHandler.perform(AccountHandler.java:601)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.mysedan.application.limonet.control.ejb.StateMachine.handleEvent(StateMachine.java:103)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at com.mysedan.application.limonet.control.ejb.EJBControllerBean.handleEvent(EJBControllerBean.java:50)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

18:12:10,309 ERROR [stderr] (http-localhost-127.0.0.1-80-4)     at java.lang.reflect.Method.invoke(Method.java:606)

Regards,

Diesel

[smarlow]

Why do you have two copies of the ojdbc6.jar?

Do you also have a copy of ojdbc6.jar in your application?

Can you eliminate the duplicate copies of ojdbc6.jar?

[lafr]

Having two copies is no good idea. Seems both are loaded by different class loaders. Although the name of the class is the same, you get the CCE then.

What do you mean with "global modules folder" and "oracle modules folder"? What's the exact path?

The most easiest solution for me is, to simply drop the ojdbc6.jar into the deployments folder, e.g. standalone/deployments.

[vandiesel]

Hi All,

Yeah, I resolved by keeping only one copy of ojdbc6.jar and referring to that module for DataSource configuration and for my application.

Thank you,

Diesel