Re: Tomcat jdbc pool connection failover

2013-03-15 Thread amit shah
On Wed, Mar 13, 2013 at 12:52 PM, André Warnier wrote: > Rainer Frey wrote: > >> On 12.03.2013, at 17:14, Christopher Schultz < >> ch...@christopherschultz.net> wrote: >> >>> On 3/12/13 7:54 AM, amit shah wrote: >>> I am using Oracle. Oracle JDBC Driver provides the Oracle Universal Con

Re: Tomcat jdbc pool connection failover

2013-03-13 Thread André Warnier
Rainer Frey wrote: On 12.03.2013, at 17:14, Christopher Schultz wrote: On 3/12/13 7:54 AM, amit shah wrote: I am using Oracle. Oracle JDBC Driver provides the Oracle Universal Connection Pool (UCP) which includes this featureo

Re: Tomcat jdbc pool connection failover

2013-03-12 Thread Rainer Frey
On 12.03.2013, at 17:14, Christopher Schultz wrote: > On 3/12/13 7:54 AM, amit shah wrote: >> I am using Oracle. Oracle JDBC Driver provides the Oracle >> Universal Connection Pool (UCP) which includes this >> featureof >> >> >

Re: Tomcat jdbc pool connection failover

2013-03-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Amit, On 3/12/13 7:54 AM, amit shah wrote: > I am using Oracle. Oracle JDBC Driver provides the Oracle > Universal Connection Pool (UCP) which includes this > featureof > > connecti

Re: Tomcat jdbc pool connection failover

2013-03-12 Thread amit shah
I understand that unplanned outages are rare but we need a high availability solution which does not involve manual intervention. On Mon, Mar 11, 2013 at 9:05 PM, Shanti Suresh wrote: > On Mon, Mar 11, 2013 at 11:00 AM, André Warnier wrote: > > > > > amit shah wrote: > > > >> Apparently we use

Re: Tomcat jdbc pool connection failover

2013-03-12 Thread amit shah
I am using Oracle. Oracle JDBC Driver provides the Oracle Universal Connection Pool (UCP) which includes this featureof connection failover but since we use tomcat jdbc connection pool we cannot use UCP. Also UCP has lot of synchroni

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread Christopher Schultz
-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 > databas

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread Daniel Mikusa
On Mar 11, 2013, at 10:09 AM, amit shah wrote: > Apparently we use Oracle as our data store while the solution you mentioned > is for mysql. I'm not an Oracle guy, but I'm pretty sure that it supports failover. Not sure it's as simple as changing the JDBC URL though, you'll probably want to che

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread Shanti Suresh
On Mon, Mar 11, 2013 at 11:00 AM, André Warnier wrote: > > amit shah wrote: > >> Apparently we use Oracle as our data store while the solution you >> mentioned >> is for mysql. >> > > And did you check if the Oracle JDBC driver provides such an option ? > > > >> Is there a way tomcat can provide

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread André Warnier
Hi. Don't "top post". amit shah wrote: Apparently we use Oracle as our data store while the solution you mentioned is for mysql. And did you check if the Oracle JDBC driver provides such an option ? Is there a way tomcat can provide a notification after all its retries to the database serve

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread amit shah
Apparently we use Oracle as our data store while the solution you mentioned is for mysql. Is there a way tomcat can provide a notification after all its retries to the database server have failed? This way at least I can create a new connection pool configured to a different database server in ord

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread Daniel Mikusa
On Mar 11, 2013, at 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 data

Re: Tomcat jdbc pool connection failover

2013-03-11 Thread André Warnier
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 re