Orphaned Oracle Connection

From: Joe Mack (jwm68_at_sbcglobal.net)
Date: 05/11/04

  • Next message: Ronald Cole: "Re: Reporting Tools" 
    Date: Tue, 11 May 2004 21:23:01 +0000 (UTC)

    Hopefully, someone can assist me.

    I have a Java application that is connecting to an Oracle repository and I
    need to incorporate some code to deal with my client taking down Oracle at
    a set time every week.

    I have a process that runs every hour, and when the client takes Oracle
    down, my process receives an error, which is expected. However, my code is
    written in such a way that the next hourly update should grab a fresh
    connection and process as designed. But, for some reason, I continue to
    get a "broken pipe" error every time I run my process. The only way we
    have found to fix this so far is to restart our application server
    (WebSphere).

    I have heard of an orphaned connection causing problems of this nature, but
    I have never seen one and therefore do not have a clue about how to fix the
    problem.

    Any help would be appreciated.

    Thank you.

    Joe
    jwm68@sbcglobal.net

  • Next message: Ronald Cole: "Re: Reporting Tools"

    Relevant Pages

    • Re: Orphaned Oracle Connection
      ... > I have a Java application that is connecting to an Oracle repository and I ... > connection and process as designed. ... > I have never seen one and therefore do not have a clue about how to fix the ...
      (comp.lang.java.databases)
    • Orphaned Oracle Connection
      ... I have a Java application that is connecting to an Oracle repository and I ... connection and process as designed. ... I have heard of an orphaned connection causing problems of this nature, ... I have never seen one and therefore do not have a clue about how to fix the ...
      (comp.lang.java.databases)
    • RE: ADO.Net Connection Pooling Problem with Oracle
      ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
      (microsoft.public.dotnet.framework.adonet)
    • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
      ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
      (microsoft.public.dotnet.languages.csharp)
    • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
      ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
      (microsoft.public.dotnet.framework.aspnet)