6 Replies Latest reply on Jul 24, 2012 11:05 AM by Stephen Coy

    jboss connection error

    ganesh kumar Newbie

      Hi,          

                I am using jboss 4.2 for my application, While running jboss server i am getting following connection error, This error is happening whenever i try to execute query but connection is created successfully with out any error. After this error connection is closing, I am not understanding what is this error and how to fix the error,any one please help

       

       

       

      i am adding stack trace of the error: 2012-07-24 11:39:24,368 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807 2012-07-24 11:39:24,368 DEBUG [org.jboss.resource.connectionmanager.IdleRemover]

      internalRegisterPool: about to notify thread: old next: 1343110614368, new next: 1343110614368

       

       

      2012-07-24 11:39:32,071 WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@be8216[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@f11bc handles=1 lastUse=1343110171617 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1557ee8 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1fef1a0 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@a97cec txSync=null] javax.resource.spi.ResourceAdapterInternalException: Unexpected error at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:293) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:273) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:553) at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:563) at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkException(WrappedResultSet.java:1922) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:514) at com.uboc.metacenter.db.DbQuery.getObjectTypeTabs(DbQuery.java:1246) at com.uboc.metacenter.util.GeneralConfig.retrieveService(GeneralConfig.java:70) at com.uboc.metacenter.util.GeneralConfig.fetchServices(GeneralConfig.java:182) at com.uboc.metacenter.util.GeneralConfig.(GeneralConfig.java:40) at com.uboc.metacenter.util.GeneralConfig.getInstance(GeneralConfig.java:32) at com.uboc.metacenter.db.DbQuery.(DbQuery.java:55) at com.uboc.metacenter.util.GeneralConfig.retrieveService(GeneralConfig.java:70) at com.uboc.metacenter.util.GeneralConfig.fetchServices(GeneralConfig.java:182) at com.uboc.metacenter.util.GeneralConfig.(GeneralConfig.java:40) at com.uboc.metacenter.util.GeneralConfig.getInstance(GeneralConfig.java:32) at com.uboc.metacenter.actions.SearchAction.(SearchAction.java:58) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at java.lang.Class.newInstance0(Class.java:350) at java.lang.Class.newInstance(Class.java:303) at org.apache.struts.util.RequestUtils.applicationInstance(RequestUtils.java:143) at org.apache.struts.action.RequestProcessor.processActionCreate(RequestProcessor.java:280) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:218) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:687) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:699) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:670) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.AbstractMethodError: oracle.jdbc.driver.OracleResultSetImpl.getClob(Ljava/lang/String;)Ljava/sql/Clob; at org.jboss.resource.adapter.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:510)

       

       

      Thanks in Advance

      ganesh