Mysql failover - connection error
Posted by: Hajo Kliemeck
Date: March 31, 2010 03:20PM

Im trying to switch to another host with the failover feature when getting a connection error while executing:

Exception in thread "main" com.mysql.jdbc.CommunicationsException: Communications link failure.

How is it possible to use hibernate and a hot failover when getting a connection error WHILE updating or selecting data in a transaction. The manual says that failover is only possible with autocommit(true)?

Should i handle the connection error or is there a possibility to switch directly with/without noticing the application and proceeding the transaction?

thanks



Edited 1 time(s). Last edit at 03/31/2010 03:25PM by Hajo Kliemeck.

Options: ReplyQuote


Subject
Written By
Posted
Mysql failover - connection error
March 31, 2010 03:20PM


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.