Read the Apache::DBI docs: it disables the disconnect method.
Tim.
On Fri, Jul 13, 2001 at 01:56:08PM +0100, Jules Beeston wrote:
> We are using Apache mod_perl, DBI and DBD::Sybase to connect to our Sybase
> db.
> Even though we are opening connections and then closing connections the
> TCP/IP connections are staying in an ESTABLISHED state for a long unknown
> period of time.
> >From looking at the DBD::Sybase disconnect code, it appears that the
> disconnect is not implemented (please correct me if I am wrong about this).
> i.e. we simply lose the handle to the connection. This causes the problem
> that once the maximum number of user connections has been reached we can
> longer connect to the Sybase server until these connections timeout.
> We have tried to implement DB pooling, but since Apache spawns and kills
> threads quite regularly, we still hit the same problem.
> Has anyone heard of or know about this? If so does anyone have a solution?
> Cheers
> Jules
