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