Re: JDBC close() exception?
Re: JDBC close() exception?
- Subject: Re: JDBC close() exception?
- From: Andrew Lindesay <email@hidden>
- Date: Wed, 2 Sep 2009 16:44:33 +1200
Hello Amiel & Bill;
Is it possible that there could be a bug in the data-source in the
container you are using -- assume you are servletting? I think MySQL
server does close the connection "overnight" if there is no traffic on
the connection, but I haven't experienced it doing this during
operational hours. I seem to remember the "autoReconnect" does work.
Maybe you could use a data source which runs a test query each time a
connection is taken from the pool?
Regards;
Did you find a solution to this? I'm afraid I am also being killed
by this.
Could it be a timeout problem and MySQL is closing the connection?
There is a MySQL option "autoReconnect" but I don't feel comfortable
with it.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden