Problems with jdbc loadbalance
Posted by: Egor Korobitsin
Date: September 12, 2013 02:45AM

Hi to all. I encountered on the problem, solution for which I can't find a long. I have application, which works on Tomcat, uses Apache DBCP and JDBC connector 5.1.25, Spring Framework and hibernate. I have 2 MySQL Servers, where replication is set. In JDBC's connection string I insert "loadbalance" and two out MySQL serveres as hosts. When I turn off first server (just shut down for example), my application hangs, and it seems that is tries to connect to offline MySQL server. And it lasts a long time.

I tried to configure connectTimeout and socketTimeout in JDBC's connection string, but it didn't help :(
Could anybody tell me where is a problem?

Thanks!



Edited 1 time(s). Last edit at 09/12/2013 02:47AM by Egor Korobitsin.

Options: ReplyQuote


Subject
Written By
Posted
Problems with jdbc loadbalance
September 12, 2013 02:45AM
September 12, 2013 08: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.