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

    jboss connection error

    ganesh1012

      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

        • 1. Re: jboss connection error
          sfcoy

          We need to know:

          • Java version
          • Oracle JDBC driver version
          • Your complete datasource configuration
          • 2. Re: jboss connection error
            ganesh1012

            Hi,

             

                

                                             

            • Java version :jdk1.5.0_13
            • Oracle JDBC driver version:racle.jdbc.driver.OracleDriver(oracle 11g)

             

             

            • complete datasource configuration:oracle-ds.xml

             

             

             

             

             

             

                   <?xml version="1.0" encoding="UTF-8"?>

             

             

            <!DOCTYPE datasources
                PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
                "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
               
            <datasources>
              <local-tx-datasource>
                  <jndi-name>JndiRef</jndi-name>
               <connection-url>jdbc:oracle:oci:@dbname</connection-url>
                  <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                  <user-name>user name</user-name>
                  <password>pwd</password>
                </local-tx-datasource>
               
            </datasources>                

             

                       

             

            Thanks in Advance

            Ganesh

             

             

            • 3. Re: jboss connection error
              sfcoy

              What is the exact name of the Oracle JDBC driver jar?

              • 4. Re: jboss connection error
                sfcoy

                This looks like you might be trying to use a JDBC 4.0 driver (which is for Java 6). Chances are the jar name is ojdbc6.jar. You need the ojdbc5.jar.

                • 5. Re: jboss connection error
                  ganesh1012

                  DriverName: Oracle JDBC driver

                  DriverVersion: 9.2.0.1.0

                  Oracle JDBC driver jar : classes111

                  • 6. Re: jboss connection error
                    sfcoy

                    OK, seems like I got it backwards. Your driver is far too old. "classes11.jar" is for Java 1.1

                     

                    JBoss is trying to call methods that are not implemented in this jar.

                     

                    You still need to find and use ojdbc5.jar if you're using Java 5.