[ https://issues.jboss.org/browse/AS7-3303?page=com.atlassian.jira.plugin.s... ] 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) -- 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

[ https://issues.jboss.org/browse/AS7-3303?page=com.atlassian.jira.plugin.s... ] Stuart Douglas resolved AS7-3303. --------------------------------- Resolution: Rejected As Remy says you should ask your questions on the community forum, giving examples of your 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