Getting java.sql.SQLException: could not retrieve transation read-only status server
Posted by: Kapil Nimje
Date: June 19, 2015 10:28AM

We are having the MYSQL RDS instance running on AWS with Server version 5.6.21. We are having the JAVA application which uses this RDS MYSQL DB using java connector driver mysql-connector-java:5.1.34 and C3P0 ComboPooledDataSource connection pooling mechanism. We are getting SQL Exception intermittently when inserting the data into MYSQL table. The error is "java.sql.SQLException: Could not retrieve transaction read-only status server". Could you please help us here what could be the best approach to resolve this error?

Options: ReplyQuote


Subject
Written By
Posted
Getting java.sql.SQLException: could not retrieve transation read-only status server
June 19, 2015 10:28AM


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.