I am using Oracle. Oracle JDBC Driver provides the Oracle Universal Connection Pool (UCP) which includes this feature<http://docs.oracle.com/cd/E11882_01/java.112/e16548/fstconfo.htm>of connection failover but since we use tomcat jdbc connection pool we cannot use UCP. Also UCP has lot of synchronized code which leads to blocking threads and less concurrency support.
Let me know your suggestions/thoughts. On Tue, Mar 12, 2013 at 1:54 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Amit, > > On 3/11/13 12:52 AM, amit shah wrote: > > Hello, I would like to know if the tomcat jdbc pool (7.0.34+) > > provides connection failover capabilities i.e. to transparently > > close all the open database connections and switch to a another > > database server on an planned/unplanned database server outage > > event. I read through the tomcat documentation but didn't find any > > details related to this. If this feature is not supported are there > > any recommended alternatives and any future plans to add this > > feature to the jdbc pool? > > This is usually done at the driver level. What database are you using? > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.17 (Darwin) > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iEYEAREIAAYFAlE+PYkACgkQ9CaO5/Lv0PAAtgCeIMaEODHLFvVqG5losN1EApM6 > CxMAnRyRG7Qdx3hI+uQ4pD4yx07p++tx > =UVeg > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
