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 order to simulate a automatic connection failover from the application side. I understand that this step would require time for the retries and creation of new pool. Thanks. On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa <dmik...@vmware.com> wrote: > 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 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? > > You might want to see if your JDBC driver will handle this for you. I > know that some do, like MySQL [1]. > > Dan > > [1] - > https://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html > > > > > Thank you, > > Amit > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
