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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
