An interesting topic.
We use a Veritas cluster to cluster our Oracle databases. It can do a hot fail-over, however the database connection is lost. The fail-over takes only about five minutes. Our goal is to make this temporary disruption transparent to the user. The only way (?) to get a hot failover for Oracle, that keeps the connection alive, is using Parallel Server, which is too expensive. I did some experiments by shutting down the Oracle server on my local Win box during database access and I got different exceptions, depending on the state the server was in (starting up, running, shutting down...). Now I am waiting for some time if I get an exception on the getConnection() call, then try again. It may not be bullet proof, but it's kind of funny if you can press the reload button while in your web application, shutdown the database, start it up again, and the web page appears (after many rotations of the logo in the upper right corner, of course). Is there any place inside JBoss where something like this would fit in? Regards Georg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Jencks Sent: Friday, May 24, 2002 20:19 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] auto restart connection pool How about setting the idle timeout? Or are you talking about a db error that breaks the connection? These are hard to deal with since SQLExceptions could be a constraint violation or a dead connection, and there's no way to distinguish them. david jencks On 2002.05.24 12:53:34 -0400 Mir Islam wrote: > Is there a way to restart the connection pool if the DB drops the > connection for some reason, without having to restart jboss ? > > From all mails I have been reading, it seems like the app server has > to > be restarted. > > Thanks > Mir > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
