Questions about connection and timeout with Connector/J

[LAFONTAINE Julien - LYO ([e-mail])]

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