Is your database and your client on the same physical network? We have an
el-cheapo firewall that automatically closes forwarded connections that are
inactive for more than a few minutes.
-Chris
----- Original Message -----
From: <jlafontaine@stripped>
To: "Mark Matthews" <mark@stripped>;
<jlafontaine@stripped>
Cc: <java@stripped>
Sent: Thursday, February 13, 2003 12:29 AM
Subject: RE: Questions about connection and timeout with Connector/J
Thanks for your answer Mark, and sorry for not checking the readme file
before.
But would it be possible that the connection is closed (or lost) if left
unused for only a few minutes (and not 8 hours or what else is specified by
wait_timeout or interactive_timeout)
I'm using Connector/J 2.13 and MySQL 2.23.49 but I haven't seen anything
about a bug that could cause that in the change log
of MySQL and Connector/J.
Thank you again for your answer.
Regards
Julien
-----Message d'origine-----
De : Mark Matthews [mailto:mark@stripped]
Envoyé : mercredi 12 février 2003 14:59
À : LAFONTAINE Julien - LYO (jlafontaine@stripped)
Cc : java@stripped
Objet : Re: Questions about connection and timeout with Connector/J
-----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-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <java-thread5031@stripped>
To unsubscribe, e-mail
<java-unsubscribe-jlafontaine=lyon-partdieu.sema.slb.com@stripped>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <java-thread5032@stripped>
To unsubscribe, e-mail
<java-unsubscribe-cstaylor=nanshu.com@stripped>
