I missed the original post... This is very odd. There is an idletimeout setting, as long as it is shorter than the time it takes the dba to do the backup all connections should have been discarded by the time the db is restored.
In cvs and thus in the next releases of 3.0/3.2/4 there is a "flush" operation on the pool mbean that you can use to manually discard all connections in the pool and as they are returned. Also in cvs and thus in the next releases is a feature whereby you can specify sql to run when the connection is taken out of the pool before it is given to the application. david jencks On 2003.02.16 14:30 Thorbj�rn Ravn Andersen wrote: > Haslbeck, J�rg wrote: > > >Hi, > > > >I have a, as far as I understand, common problem: My application is > based on JBoss and Oracle and the application data is backed up every > night. > > > >What happens is that the database department shuts down Oracle, runs the > backup, and brings the database server back on-line. > >Now, JBoss does not re-connect and the application is dead. > > > > > An untested idea for a work-around: > > Would it be possible to "touch ..../oracle-service.xml" when bringing > the database up again? This should redeploy the connection, which > should mean that JBoss reconnects to Oracle. > > -- > Thorbj�rn Ravn Andersen Scandiatransplant > Skejby Sygehus, indgang 3 > +45 89 49 53 01 DK-8200 �rhus N > http://biobase.dk/~tra > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > 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 Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
