You could write a jca-jdbc wrapper with this functionality in it. It's going to be a pain IMO since I believe one of the failures you have to deal with is nothing happening....
so for every request you have to execute it in a separate thread so timeouts can throw away the initial thread/request and try again. How do you propose to deal transparently with transactions in such a scenario without good cooperation from the db?? david jencks On 2002.05.24 16:20:21 -0400 Georg Schmid wrote: > > 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 > > _______________________________________________________________ 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
