Problems with jdbc loadbalance
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?
Edited 1 time(s). Last edit at 09/12/2013 02:47AM by Egor Korobitsin.
Sorry, only registered users may post in this forum.
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.