Re: Creating XA Datasource in JBoss 7.1.1 for MySQL Cluster : Connection Read Only Error
Posted by: Manjunatha Nakshathri
Date: December 17, 2013 11:51AM

Hello Todd,

Thanks for your response. As you said, i did try with the loadbalance URL which resulted in classcast exception.

But with the failover configuration (which i am trying with), connection is not going on to the standby server if the master is down; And thats when its giving the exception "com.mysql.jdbc.jdbc2.optional.MysqlXAException: Connection is read-only. Queries leading to data modification are not allowed."

Can you please help me to get this right?


Options: ReplyQuote

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.