From: Date: February 12 2003 3:53pm
Subject: Questions about connection and timeout with Connector/J
List-Archive: http://lists.mysql.com/java/5030
Message-Id: <1B9D8A2F7E92D611967D009027D0897E235478@lyomes01.lyon.eur.slb.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi everyone,
I've got a few questions about connection in MySQL and Connector/J. It would
help me a lot if someone could give me any information.
What happens if a Connection object is left unused for a few minutes. Could
the connection possibly be lost or at least closed by a MySQL server or the
driver? Then would a SQLException be thrown when a statement is created or a
query executed on a Statement object created by this connection? It seemed
to me that the MySQL server would closed the connection after "wait_timeout"
or "interactive_timeout" seconds.


Regards

Julien