Re: Connector/J Load Balancing in Master/Slave Environment
Posted by: Todd Farmer
Date: August 01, 2012 04:41PM

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/

Options: ReplyQuote


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.