Re: Connector/J Load Balancing in Master/Slave Environment
Hi William,
I understand the spec the same way you do: Connection.setReadOnly() should only be set at the start of a transaction and left unchanged for the duration.
However, my reading of the code makes be believe there's no protection against calls to setReadOnly() at inappropriate times, which can produce problematic behavior. I'm in the process of testing this further, and will open bug reports if appropriate and update this thread.
Regardless, I think the conclusion you reached is correct - you don't want to try to set read-only state mid-transaction.
--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/
Subject
Written By
Posted
Re: Connector/J Load Balancing in Master/Slave Environment
August 01, 2012 04:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.