I am using ha-jdbc2.0.15 with MySQL5.1.58. I have a system with three nodes each nodes has a database and Tomcat server running web application. The web application communicate all three database on each nodes. When I power off the second node, the database on third node is deactivated as well due to the error "Can't call commit when autocommit=true". After more investigation, the connection has autoCommit=false before execute commit method. It looks like the ha-jdbc reset that value or recreate new jdbc connection during deactivating another database.
I tried add <property name="relaxAutoCommit">true</property> as a MySQL JDBC connection property in ha-jdbc configuration, however that attribute is still false after the underneath jdbc connection created.
Does anybody has any idea or same issue?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using ha-jdbc2.0.15 with MySQL5.1.58. I have a system with three nodes each nodes has a database and Tomcat server running web application. The web application communicate all three database on each nodes. When I power off the second node, the database on third node is deactivated as well due to the error "Can't call commit when autocommit=true". After more investigation, the connection has autoCommit=false before execute commit method. It looks like the ha-jdbc reset that value or recreate new jdbc connection during deactivating another database.
I tried add <property name="relaxAutoCommit">true</property> as a MySQL JDBC connection property in ha-jdbc configuration, however that attribute is still false after the underneath jdbc connection created.
Does anybody has any idea or same issue?