Re: debugger 'R'estart and open database connections

From: Andrew Pimlott (andrew_at_pimlott.net)
Date: 07/10/04

  • Next message: Bill Ricker N1VUX: "DB2 and "Upgrade" Re: Describe table" 
    Date: Fri, 9 Jul 2004 18:34:14 -0400
To: dbi-users@perl.org

    On Fri, Jul 09, 2004 at 08:08:37AM +0200, Michael Peppler wrote:
    > On Thu, 2004-07-08 at 21:42, Andrew Pimlott wrote:
    >
    > > - Have the database drivers set the close-on-exec flag of the fd used to
    > > connect to the database. This makes sense to me, because after an
    > > exec, there is usually no way to recover the connection (does any
    > > database library allow this?).
    >
    > Yes - Sybase OpenClient has always allowed the re-use of open
    > connections across forks (and hence across execs).

    So there is a call that takes an fd and creates a connection around it?
    Cool.

    Anyhow, I'm pretty convinced that closing the fds in the debugger is the
    cleaner solution, so this isn't an issue.

    Andrew

  • Next message: Bill Ricker N1VUX: "DB2 and "Upgrade" Re: Describe table"

    Relevant Pages

    • 1 port, listening and connecting, how to
      ... to have one port to connect to the server AND listen to incoming ... connections. ... Would I have to use threads, forks? ...
      (comp.os.linux.networking)
    • 1 Port, listening and connecting, how to?
      ... to have one port to connect to the server AND listen to incoming ... connections. ... Would I have to use threads, forks? ...
      (comp.unix.programmer)
    • Re: 1 Port, listening and connecting, how to?
      ... > to have one port to connect to the server AND listen to incoming ... > Would I have to use threads, forks? ... outgout connections on the same port. ...
      (comp.unix.programmer)
    • Re: System degrades after 49.71 days
      ... connections and they stay busy most of the time it shouldn't be a problem. ... Andrew J. Kelly SQL MVP ... > attaching to the database when it starts and remain constantly attached. ... >> Andrew J. Kelly SQL MVP ...
      (microsoft.public.sqlserver.server)
    • Re: Explain
      ... > In SQL 2000 any SPIDs below 50 are system connections. ... > Andrew J. Kelly SQL MVP ... >> number of users that currently are connected to SQL Server. ...
      (microsoft.public.sqlserver.clients)