3 Replies Latest reply: Nov 22, 2012 7:33 AM by 746690 RSS

    i am getting JDBC error

    Ikhan
      Hi,

      Can some one help me to troubleshoot the below errors?, i guess the error is from Database side, but i what to know what issue is could be from database side.

      one more thing the all JDBC connection is getting disconnect at a time with below exception.
      ####<Nov 19, 2012 5:36:43 AM CST> <Info> <JDBC> <hostname> <server1> <[ACTIVE] ExecuteThread: '1' for queue: 'we
      blogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-648F1CAA18EE77B4B0FF> <> <1353325003526> <BEA-001128> <Connection for pool "DECS Data Source" closed.>



      ####<Nov 20, 2012 4:04:38 AM CST> <Error> <JDBC> <hostname> <server1> <[ACTIVE] ExecuteThread: '3' for queue: 'w
      eblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1353405878616> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for
      pool "DECS Data Source" failed with exception: "java.sql.SQLException: ORA-03113: end-of-file on communication channel".>

      ####<Nov 19, 2012 5:36:43 AM CST> <Error> <JDBC><hostname> <server1> <[ACTIVE] ExecuteThread: '1' for queue: 'w
      eblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-648F1CAA18EE77B4B0FF> <> <1353325003525> <BEA-001112> <Test "SELECT
      1 FROM DUAL" set up for pool "DECS Data Source" failed with exception: "java.sql.SQLException: Closed Connection".>
      ####<Nov 19, 2012 5:36:43 AM CST> <Info> <JDBC> <hostname> <server1> <[ACTIVE] ExecuteThread: '1' for queue: 'we
      blogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-648F1CAA18EE77B4B0FF> <> <1353325003526> <BEA-001128> <Connection fo
      r pool "DECS Data Source" closed.>
      ####<Nov 19, 2012 5:36:48 AM CST> <Error> <JDBC> <hostname> <server1> <[ACTIVE] ExecuteThread: '9' for queue: 'w
      eblogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-64961CAA18EE77B4B0FF> <> <1353325008499> <BEA-001112> <Test "SELECT
      1 FROM DUAL" set up for pool "DECS Data Source" failed with exception: "java.sql.SQLException: Closed Connection".>
      ####<Nov 19, 2012 5:36:48 AM CST> <Info> <JDBC> <hostname> <server1> <[ACTIVE] ExecuteThread: '9' for queue: 'we
      blogic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-64961CAA18EE77B4B0FF> <> <1353325008499> <BEA-001128> <Connection fo
      r pool "DECS Data Source" closed.>

      ####<Nov 19, 2012 5:36:43 AM CST> <Info> <EJB> <hostname> <server1> <[ACTIVE] ExecuteThread: '2' for queue: 'web
      logic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-648E1CAA18EE77B4B0FF> <> <1353325003068> <BEA-010051> <EJB Exception
      occurred during invocation from home: com.dynamex.decs.model.facade.DataFacadeBean_fahzrs_HomeImpl@39540180 threw exception: j
      avax.ejb.EJBException: Could not execute query: ORA-03113: end-of-file on communication channel

      javax.ejb.EJBException: Could not execute query: ORA-03113: end-of-file on communication channel

      at com.dynamex.decs.model.facade.DataFacadeBean.query(DataFacadeBean.java:496)
      at com.dynamex.decs.model.facade.DataFacadeBean_fahzrs_ELOImpl.query(DataFacadeBean_fahzrs_ELOImpl.java:73)
      at com.dynamex.decs.model.dispatch.DispatchFacadeBean.getCreatedOrderIds(DispatchFacadeBean.java:2143)
      at com.dynamex.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl.getCreatedOrderIds(DispatchFacadeBean_yrkg54_EOImpl.java:1629)
      at com.dynamex.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl_WLSkel.invoke(Unknown Source)
      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:554)
      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:444)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:439)
      at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:61)
      at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:984)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

      ####<Nov 19, 2012 5:36:43 AM CST> <Info> <EJB> <<hostname> <server1> <[ACTIVE] ExecuteThread: '2' for queue: 'web
      logic.kernel.Default (self-tuning)'> <<anonymous>> <BEA1-648E1CAA18EE77B4B0FF> <> <1353325003068> <BEA-010051> <EJB Exception
      occurred during invocation from home: com.dynamex.decs.model.dispatch.DispatchFacadeBean_yrkg54_HomeImpl@39a7c535 threw except
      ion: javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: javax.ejb.EJBException: Could not ex
      ecute query: ORA-03113: end-of-file on communication channel

      javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: javax.ejb.EJBException: Could not execute query: ORA-03113: end-of-file on communication channel

      at weblogic.ejb.container.internal.EJBRuntimeUtils.throwTransactionRolledbackLocal(EJBRuntimeUtils.java:226)
      at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:671)
      at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:604)
      at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:347)
      at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:286)
      at com.dyna.decs.model.facade.DataFacadeBean_fahzrs_ELOImpl.query(DataFacadeBean_fahzrs_ELOImpl.java:88)
      at com.dyna.decs.model.dispatch.DispatchFacadeBean.getCreatedOrderIds(DispatchFacadeBean.java:2143)
      at com.dyna.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl.getCreatedOrderIds(DispatchFacadeBean_yrkg54_EOImpl.java:1629)
      at com.dyna.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl_WLSkel.invoke(Unknown Source)
      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:553)
      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:443)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:439)
      at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:61)
      at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:983)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
      javax.ejb.EJBException: Could not execute query: ORA-03113: end-of-file on communication channel

      at com.dynamddecs.model.facade.DataFacadeBean.query(DataFacadeBean.java:496)
      at com.dyna.ddecs.model.facade.DataFacadeBean_fahzrs_ELOImpl.query(DataFacadeBean_fahzrs_ELOImpl.java:73)
      at com.dyna.ddecs.model.dispatch.DispatchFacadeBean.getCreatedOrderIds(DispatchFacadeBean.java:2143)
      at com.dyna.ddecs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl.getCreatedOrderIds(DispatchFacadeBean_yrkg54_EOImp

      ####<Nov 19, 2012 5:36:43 AM CST> <Notice> <EJB> <<hostname> <server1> > <[ACTIVE] ExecuteThread: '2' for queue: 'w
      eblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1353325003069> <BEA-010014> <Error occurred while attempting to ro
      llback transaction: javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHa
      zard, (javax.transaction.xa.XAException: Closed Connection))
      javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))
      at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:406)
      at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:373)
      at weblogic.ejb.container.internal.BaseEJBObject.handleSystemException(BaseEJBObject.java:741)
      at weblogic.ejb.container.internal.BaseEJBObject.handleSystemException(BaseEJBObject.java:705)
      at weblogic.ejb.container.internal.BaseEJBObject.postInvoke1(BaseEJBObject.java:456)
      at weblogic.ejb.container.internal.StatelessEJBObject.postInvoke1(StatelessEJBObject.java:72)
      at weblogic.ejb.container.internal.BaseEJBObject.postInvokeTxRetry(BaseEJBObject.java:381)
      at com.dynamex.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl.getCreatedOrderIds(DispatchFacadeBean_yrkg54_EOImpl.java:1643)
      at com.dynamex.decs.model.dispatch.DispatchFacadeBean_yrkg54_EOImpl_WLSkel.invoke(Unknown Source)
      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:554)
      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:444)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:439)
      at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:61)
      at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:984)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)


      Thanks in Advance,
      imran khan.

      Edited by: Ikhan on Nov 20, 2012 8:14 AM

      Edited by: Ikhan on Nov 20, 2012 8:20 AM
        • 1. Re: i am getting JDBC error
          Joe Weinstein-Oracle
          Yes, it looks like something outside WebLogic and the driver severed the socket that was being used by the connection to talk to the DBMS. The first thing to check is the DBMS error log. If the DBMS-side process dies, you'd see that exception.
          • 2. Re: i am getting JDBC error
            Ikhan
            Thanks Joe,

            we are getting Archival error which we are getting in the database, below is the error.

            ==================================
            Alert Log details at Sun Nov 18 19:37:12 2012.
            ==================================
            Errors in file /opt/oracle/admin/decsp/bdump/decsp1_arc0_640.trc:
            ORA-16038: log 1 sequence# 31734 cannot be archived
            ORA-19504: failed to create file ""
            ORA-00312: online log 1 thread 1: '+DG_DATAFILE_DECSP/decsp/redo01a.log'
            ORA-00312: online log 1 thread 1: '+DG_DATAFILE_DECSP/decsp/redo01b.log'
            Sun Nov 18 19:37:12 2012
            Completed checkpoint up to RBA [0x7bf7.2.10], SCN: 9918684615429
            Sun Nov 18 19:37:28 2012
            ARCH: Archival stopped, error occurred. Will continue retrying
            Sun Nov 18 19:37:28 2012
            ORACLE Instance decsp1 - Archival Error
            Sun Nov 18 19:37:28 2012
            ORA-16014: log 1 sequence# 31734 not archived, no available destinations
            ORA-00312: online log 1 thread 1: '+DG_DATAFILE_DECSP/decsp/redo01a.log'
            ORA-00312: online log 1 thread 1: '+DG_DATAFILE_DECSP/decsp/redo01b.log'
            Sun Nov 18 19:37:28 2012
            Errors in file /opt/oracle/admin/decsp/bdump/decsp1_arc1_642.trc:
            ORA-16014: log 1 sequence# 31734 not archived, no available destinations
            ====================


            Thanks,
            imran khan
            • 3. Re: i am getting JDBC error
              746690
              Hello Imran,

              from logs - "ORA-03113: end-of-file on communication channel" error only an information due to, I would guess your DB got down intermittently or of any reasons and once up, a connection reset or refresh was happened and property TestConnectionsOnReserve is set to true and the connection test query fails. So it wouldn't be a issue. rest, few initial <error> for connection closed for datasource happened when your DB got down.

              further you can view my blog http://weblogicserveradministration.blogspot.in/ for weblogic issues and concerns, I hope you would get some useful stuff there.

              - Mukesh Negi