Re: Questions about connection and timeout with Connector/J - Mark Matthews - com.mysql.lists.java

11 messages in com.mysql.lists.javaRe: Questions about connection and ti...

From	Sent On	Attachments
LAFO...@lyon-partdieu.sema.slb.com)	12 Feb 2003 06:52
Mark Matthews	12 Feb 2003 06:58
LAFO...@lyon-partdieu.sema.slb.com)	12 Feb 2003 07:28
Mark Matthews	12 Feb 2003 08:19
Frank Gates	12 Feb 2003 08:37
LAFO...@lyon-partdieu.sema.slb.com)	12 Feb 2003 08:58
Frank Gates	12 Feb 2003 09:32
Christopher Taylor	12 Feb 2003 16:44
Shivani	16 Feb 2003 23:17
Alec...@Quantel.Com	17 Feb 2003 01:14
Shivan	17 Feb 2003 21:36

Subject:	Re: Questions about connection and timeout with Connector/J
From:	Mark Matthews (ma...@mysql.com)
Date:	02/12/2003 06:58:18 AM
List:	com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

LAFONTAINE Julien - LYO (jlaf...@lyon-partdieu.sema.slb.com) wrote:

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.

You get an SQLException.

This is covered in the README that comes with Connector/J :)

Look at the bottom, in the 'troubleshooting' section.

-Mark

- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

iD8DBQE+SmEhtvXNTca6JD8RAuZyAKCdmM1F0lMQsOVhj0v3+0gGjiX9zwCff1Sr VWAHQ3Op50bV4gf8p6+e+t0= =5od7 -----END PGP SIGNATURE-----