-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Bill Ataras wrote:
> Thanks. Yeah I saw the section on failover. I guess I didn't understand
> that autoreconnect in the url is now used for failover to another server
> rather than reconnecting to the same server. Is that what you mean? If
> that's the case I can move to dbcp or something that should handle stale
> connections.
If you only have one host listed, autoReconnect attempts to fail-over
back to the same host (just like before).
The change is in the semantics of _when_ reconnect can happen. It is
really only safe to reconnect when you are not in a transaction (and
even then, it could be risky if it happens at an inoportune time, which
only _your_ application can deduce, not the driver). That's why the
driver now _requires_ autoCommit to be 'true' to be able to reconnect.
It's also why I've been recommending for over a year or so now (check
the mailing list archives, or even the 'Troubleshooting' section of the
README), that developers should really be handling this case themselves
(i.e. stale connection), because only they have the knowledge of their
application that allows them to determine what is the correct action to
take to recover a 'stale' connection.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
www.mysql.com
Are you MySQL Certified?
http://www.mysql.com/certification/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQE/4x34tvXNTca6JD8RAtzLAKCDqzcU/p0VIaxR9okz7/t2+VsryQCfR3wW
lvkGVCFVjOAWINWnu8PSMYA=
=T5p6
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
