Re: [JBoss-user] reconnecting after a database failure?

[David J. <dav...@di...>]

varia/src/main/org/jboss/ant/package.html and the change note for it.

david jencks

On 2002.07.11 12:01:05 -0400 Greg Turner wrote:
> Where would one find more info about what this ant jmx task is.
> 
> David Jencks wrote:
> 
> > If you are intentionally shutting down the db and restarting, it should
> not
> > be that hard to also stop and (re)start the connection pools.  Which
> jboss
> > are you using?  One of my earliest contributions was a patch to make
> this
> > work in 2.x versions, but I don't remember if it got applied.  I also
> > haven't tested this lately in 3.x versions, so I don't know if it
> actually
> > works or not.  If you discover it does not please file a bug.  If you
> are
> > using 3.0.1 or later you might be able to use the ant jmx task to
> operate
> > on the mbeans.
> >
> > david jencks.
> >
> > On 2002.07.11 10:38:22 -0400 "Geer, Benjamin" wrote:
> > > We're developing an application using JBoss, and we have a client who
> > > wants to be able to shut down the database, restart it, and have our
> > > application automatically reconnect.
> > > Our experience with JDBC is that this is very difficult to do, mainly
> > > because there's no database-independent way to test a JDBC connection
> to
> > > see whether it's still alive, or to identify a SQLException caused by
> a
> > > lost connection.
> > >
> > > The client suggests that, if a connection is broken, we should just
> > > close it, make a new one, and retry.  But of course, JBoss is
> managing
> > > pooled connections for us, so this would have to be done by JBoss.
> > >
> > > Can anyone tell us whether JBoss provides a way to handle this
> > > situation?  If not, is there a way to approximate the desired
> behaviour?
> > >
> > > Benjamin Geer
> > > Misys International Banking Systems
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > PC Mods, Computing goodies, cases & more
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > JBoss-user mailing list
> > > JBo...@li...
> > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > >
> > >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > PC Mods, Computing goodies, cases & more
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > JBo...@li...
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> --
> Greg Turner, JBoss Authorized Consultant
> 
> Tiburon Enterprise Systems
> http://www.tiburon-e-systems.com
> Box 1171
> Tiburon, CA 94920
> 415-332-3363
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> PC Mods, Computing goodies, cases & more
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
>