(Fwd) Oracle / Apache::DBI connection problems

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 05/18/04

  • Next message: v796: "Re: Perl pulling data from SQL Server" 
    Date: Tue, 18 May 2004 18:10:35 +0100
To: dbi-users@perl.org

    ----- Forwarded message from "Hartog C. de Mik" <hartog@2organize.com> -----

    Delivered-To: tim.bunce@pobox.com
    X-SPF-Guess: pass (seems reasonable for hartog@2organize.com to mail through 193.173.215.4)
    Date: Tue, 18 May 2004 17:07:44 +0200
    From: "Hartog C. de Mik" <hartog@2organize.com>
    To: Tim.Bunce@pobox.com
    Subject: Oracle / Apache::DBI connection problems

    This is a forward since the original message bounced. Figured it
    would, the address was 5 years old. :^)

    ----- Forwarded message from "Hartog C. de Mik" <hartog@2organize.com> -----

    From: "Hartog C. de Mik" <hartog@2organize.com>
    To: Tim.Bunce@ig.co.uk
    Date: Tue, 18 May 2004 16:58:19 +0200
    Subject: Oracle / Apache::DBI connection problems
    Message-ID: <20040518145819.GD6570@2organize.com>

    Hi,

    I read a thread (http://mathforum.org/epigone/modperl/spaxspandheh),
    initiated by you, on a problem I am currently having with
    (DBD::)Oracle.

    Whenever our DBA restarts a database used by one of my mod_perl
    scripts or the entire server the connection is permanently lost.

    The DB runs remote of the webserver which is a linux box. The DB runs
    on a windows box.

    I've tried virtually anything. Writing a wrapper for (Apache::)DBI
    which, in the end, had some pretty agressive methods of trying to get
    a re-connect. Methods used where along the lines of reading all the
    handles Apache::DBI had and undef'ing them, since the disconnect is
    overwritten and no other method of disconnect is provided (which is a
    poor feature).

    No matter what I try, I cant get (Apache::)DBI to connect to the
    server once it had been away without restarting Apache itself.

    Perhaps you have some advice?

    TIA,
    Grtz,
    Hartog. 

    -- 
UNIX developer && sysadmin
2organize
  http://leerquoten.nl/
----- End forwarded message -----
----- End forwarded message -----
  • Next message: v796: "Re: Perl pulling data from SQL Server"

    Relevant Pages

    • Re: server disconnects
      ... I tried to reach you via email twice, but each time the message was returned ... If you are having this disconnect problem after reading your email with ... > systems like yahoo messenger and msn messenger. ... then I have connection problems with all ...
      (rec.games.backgammon)
    • Re: Newbie: "You do not have access to logon....."
      ... Not *all* connection problems are ... MCSE,CCEA, Microsoft MVP - Terminal Server ... > with both RD Client and RD Web from variety of client Windows ... > Do we have to have a LS up and running during the 120 day grace? ...
      (microsoft.public.windows.terminal_services)
    • where are sshd log files located?
      ... but recently I started having connection problems from my work ... I am trying to locate the ssh server's ... laptop to the server within my home network. ... firewall/router but port forwarding is enabled. ...
      (SSH)
    • Re: SuperSocker Bind Failed on port TCP:1433 Error
      ... > We have a lot of connection problems lately. ... Bind failed on TCP port 1433. ... > We have a couple of IP Addresses configured on that server for SSL ... > the last entry is the SuperSocket Info: Bind failed on TCP port 1433. ...
      (microsoft.public.sqlserver.server)
    • Re: TcpClient read/write timeouts do not timeout
      ... read/write problems or connection problems? ... The server sees the connection. ... Writeshould end because there's NO server and because the timeout ...
      (microsoft.public.dotnet.languages.csharp)