[jboss-jira] [JBoss JIRA] (AS7-3303) org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection
sekar sekar (JIRA)
jira-events at lists.jboss.org
Fri Jan 13 09:07:23 EST 2012
[ https://issues.jboss.org/browse/AS7-3303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
sekar sekar updated AS7-3303:
-----------------------------
Description:
Not Able to get Oracle Connection When Calling CLOB.CreateTamporary Function.
Tried the Following Example given in the Oracle Forum
//get the wrapped JBOSS connection
if(conn instanceof org.jboss.resource.adapter.jdbc.WrappedConnection){
WrappedConnection wc=(WrappedConnection)conn;
//with getUnderlying connection method , cast it to Oracle Connection
Connection oracleConnection=wc.getUnderlyingConnection();
}
The above example throwing following exception:
java.lang.ClassCastException: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection
at oracle.sql.CLOB.createTemporary(CLOB.java:754)
at oracle.sql.CLOB.createTemporary(CLOB.java:716)
at com.mgeretail.bo.master.RoleSMSReportService.doAuditTrail(RoleSMSReportService.java:150)
at com.mgeretail.modules.controller.RoleSmsReportAccessAllocationController.updateRoleSmsReportAccAllocation(RoleSmsReportAccessAllocationController.java:430)
at com.mgeretail.modules.controller.RoleSmsReportAccessAllocationController.update(RoleSmsReportAccessAllocationController.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at com.mgeretail.gateway.ClickJactFilter.doFilter(ClickJactFilter.java:22)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
at java.lang.Thread.run(Unknown Source)
So, Please fix the Issue
If possible then please add some Example in details or upload example source code
was:
Not Able to get Oracle Connection When Calling CLOB.CreateTamporary Function.
Tried the Following Example given in the Oracle Forum
//get the wrapped JBOSS connection
if(conn instanceof org.jboss.resource.adapter.jdbc.WrappedConnection){
WrappedConnection wc=(WrappedConnection)conn;
//with getUnderlying connection method , cast it to Oracle Connection
Connection oracleConnection=wc.getUnderlyingConnection();
}
If possible then please add some Example in details or upload example source code
Forum Reference: https://forums.oracle.com/forums/thread.jspa?threadID=279238 (was: https://forums.oracle.com/forums/thread.jspa?threadID=279238)
> org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection
> -----------------------------------------------------------------------------------------------------
>
> Key: AS7-3303
> URL: https://issues.jboss.org/browse/AS7-3303
> Project: Application Server 7
> Issue Type: Bug
> Components: Web
> Environment: JSP, SPRING, Oracle 10g,
> Reporter: sekar sekar
> Assignee: Remy Maucherat
> Priority: Critical
> Labels: jboss
> Fix For: 7.0.2.Final
>
>
> Not Able to get Oracle Connection When Calling CLOB.CreateTamporary Function.
> Tried the Following Example given in the Oracle Forum
> //get the wrapped JBOSS connection
> if(conn instanceof org.jboss.resource.adapter.jdbc.WrappedConnection){
> WrappedConnection wc=(WrappedConnection)conn;
> //with getUnderlying connection method , cast it to Oracle Connection
> Connection oracleConnection=wc.getUnderlyingConnection();
> }
> The above example throwing following exception:
> java.lang.ClassCastException: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection
> at oracle.sql.CLOB.createTemporary(CLOB.java:754)
> at oracle.sql.CLOB.createTemporary(CLOB.java:716)
> at com.mgeretail.bo.master.RoleSMSReportService.doAuditTrail(RoleSMSReportService.java:150)
> at com.mgeretail.modules.controller.RoleSmsReportAccessAllocationController.updateRoleSmsReportAccAllocation(RoleSmsReportAccessAllocationController.java:430)
> at com.mgeretail.modules.controller.RoleSmsReportAccessAllocationController.update(RoleSmsReportAccessAllocationController.java:295)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
> at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
> at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
> at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
> at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
> at com.mgeretail.gateway.ClickJactFilter.doFilter(ClickJactFilter.java:22)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
> at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
> at java.lang.Thread.run(Unknown Source)
> So, Please fix the Issue
> If possible then please add some Example in details or upload example source code
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the jboss-jira
mailing list