Re: Questions about connection and timeout with Connector/J

[Mark Matthews]

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

LAFONTAINE Julien - LYO (jlafontaine@stripped) 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

     __  ___     ___ ____  __
    /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
   / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
  /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
         <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

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