Uploaded image for project: 'Application Server 7'
  1. Application Server 7
  2. AS7-3303

org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Critical Critical
    • 7.0.2.Final
    • None
    • None
    • JSP, SPRING, Oracle 10g,

      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

              Unassigned Unassigned
              v.sekargkm sekar sekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: