If a dead connection is used an exception will be thrown and caught. When the dead connection is discovered by the watchdog it will be replaced with a new one. What happens now is that dead connections stay dead until you bounce the appserver. I will take the non-fool-proof solution over that any day!
----- Original Message ----- From: "Guy Rouillier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 8:00 PM Subject: Re: [JBoss-user] jboss backup management: howto? > > ----- Original Message ----- > From: "Rod Macpherson" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, February 06, 2003 10:37 AM > Subject: Re: [JBoss-user] jboss backup management: howto? > > > >>Noticed the same thing. WebLogic has a watch-dog that does a SELECT * > FROM > FOO where you supply the table name (e.g., DUAL) and if it fails the > connection is re-established. This is a critical feature for databases > that > tear down connections prior to backup.<< > > Unfortunately, that approach is not fool-proof. The connection can drop > at any time, i.e., in the time between when the watchdog last verified > it and the time when you want to use it. As far as I know, there is no > way to guarantee that your next SQL will make it to the database. > > > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > http://www.vasoftware.com > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
