MySQL Connector/J for Failover

Hi,  

I am using MySQL Connector/J 3.1.x on Windows using MySQL 5.0.x. I am trying to achieve HA in MySQL.  

I have setup Master-Master Replication in two machines both running on windows. This works fine for me, any updation on any one of the machine is replicated on other.  

The url I am using is something like this-  

jdbc:mysql://host1,host2:3306/abc?&zeroDateTimeBehavior=convertToNull&autoReconnect=true&failOverReadOnly=false&reconnectAtTxEnd=true  

In this case my problem is - if I shutdown the mysql service on first host ie.- host1, the Driver does not connects to the second host, and the application gives SQL exceptions like -  

Communications link failure due to underlying exception:  

java.net.SocketExceptionMESSAGE: Connection reset  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

If anyone can help me on this? Please let me know where I am going wrong.  

Thanks  

Vishal