I updated the default oracle-service.xml but the only changes were to the driver URL and the credentials. Do we need to specify a connection test query or does that come with the existing oracle jca adapter/wrapper? Using the default 15 minute idle period but not supplying a query.
----- Original Message ----- From: "David Jencks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 3:14 PM Subject: Re: [JBoss-user] jboss backup management: howto? On 2003.02.16 16:52 Rod Macpherson wrote: > I caught some of the conversation: dead connections are not being > ressurected. The following settings are used iff a test table is > specified > in weblogic: > > testConnsOnReserve > testConnsOnRelease > refreshPeriod (must be non-zero, yep, non-zero if either of the above are > defined) > > Weblogic does not specify a "test" table by default so all of these > settings > are moot. Everybody gets burned by that at least once. Not sure why but a > refresh period must be specified even for on-release and on-reserve > checks. > Will test the JBoss timeout thing Tuesday. Why does weblogic need a table > to > check a connection's pulse? Well, IMO the driver should be a jca adapter and notify the app server via connectionErrorOccurred events as soon as it notices something is amiss. If the app server has to check, then it needs to know something it can do on the connection to test it. WL seems to have chosen select count(*) from @supplied-table-name@. My implementation in the jca-jdbc wrappers asks you to provide an entire sql statement in case you can find something quicker than a select count(*). david jencks > > http://e-docs.bea.com/wls/docs61/jdbc/programming.html > > > ----- Original Message ----- > From: "David Jencks" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, February 16, 2003 11:45 AM > Subject: Re: [JBoss-user] jboss backup management: howto? > > > 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 > > > > > ------------------------------------------------------- > 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 ------------------------------------------------------- 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
