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 > [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
