12 messages in com.mysql.lists.javaRe: Connection Pooling Timeout with M...
FromSent OnAttachments
Mark Matthews31 May 2000 18:15 
Karsten Spriestersbach01 Jun 2000 04:37 
Steven C. Hittle01 Jun 2000 04:46 
Matt Goss01 Jun 2000 06:36 
Carlos Proal01 Jun 2000 07:08 
David E. Storey01 Jun 2000 07:15 
Tim Endres01 Jun 2000 08:27 
Suresh R. Joshee01 Jun 2000 22:01 
Nick Betteridge02 Jun 2000 04:05 
rj...@typeline.com02 Jun 2000 13:38 
rj...@typeline.com02 Jun 2000 13:46 
Sinisa Milivojevic03 Jun 2000 05:29 
Subject:Re: Connection Pooling Timeout with MySQL
From:Sinisa Milivojevic (sin@mysql.com)
Date:06/03/2000 05:29:45 AM
List:com.mysql.lists.java

On Fri, 02 Jun 2000, rj@typeline.com wrote:

I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages. The JSP/Servlet engine I'm running (iServer) has connection pooling built in along with Java
wrappers to set it up. When I start the servlet engine, the pool is created. The problem is, the
pool of open connections times out after 8 hours. I noticed in the mysqld documentation that
the wait_timeout is set to 28800 by default.

What do I need to do to keep the initial connections open in the pool? Is it a
JDBC driver issue or MySQL issue?

Thanks Bob

Hi!

Set a wait_timeout to a very large value. It can go up to UINT_MAX on your system.

Regards,

Sinisa

+----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mys@tcx.se | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+