olá…
estou tentando fazer a consulta no bd onde um campo é do tipo xmlType (CLOB), porém quando vou pegar o ResultSet para fazer a conversão para
OracleResultSet, eu recebo um belo ClassCastException… alguém pode me dar uma mão…
segue a parte do meu código…
[code]ResultSet rs = st.executeQuery();
C3P0NativeJdbcExtractor jdbc = new C3P0NativeJdbcExtractor();
OracleResultSet orset = (OracleResultSet) jdbc.getNativeResultSet(rs);
if(orset.next())
{
// get the XMLType
XMLType poxml = XMLType.createXML(orset.getOPAQUE("NFE_XML"));
xml = ((XMLType) poxml).getStringVal();
}[/code]
e minha exception:
java.lang.ClassCastException: com.mchange.v2.c3p0.impl.NewProxyResultSet cannot be cast to oracle.jdbc.OracleResultSet
at br.com.mili.dao.imp.nfe.ControleNFeDaoImp.findXMLByChaveAcesso(ControleNFeDaoImp.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy84.findXMLByChaveAcesso(Unknown Source)
at br.com.mili.dao.test.nfe.TestControleNFeDao.findByXML(TestControleNFeDao.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestMethod.java:198)
...