kostya kote wrote:
> and more.
> I quote from
>
http://dev.mysql.com/doc/connector/j/en/cj-configu
> ration-properties.html
> "...
> If the URL property "autoReconnect" is true:
> Failover happens when the driver determines that
> the connection has failed (before every query),
> and falls back to the first host when it
> determines that the host has become available
> again (after queriesBeforeRetryMaster queries have
> been issued)...." (с)
>
> So, is it wrong ? or in which cases can it happens
> "that driver determines before every query.."
>
>
>
> Edited 1 times. Last edit at 09/19/05 09:43AM by
> kostya kote.
Kostya,
That information is slightly wrong. We'll correct the documentation. It should state re-connect only happens when autoCommit=false, which means reconnection won't happen in the middle of a transaction, only at the _beginning_ of a transaction. If the connection fails in the _middle_ of a transaction, you need to set the connection back to autoCommit=true, and start the transaction over again.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html