This discussion is archived
3 Replies Latest reply: Nov 22, 2012 5:33 AM by 746690 RSS

i am getting JDBC error

958721 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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
    958721 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points