I tend to agree with Doug on this. Also, I think it's reasonable that the pools be able to tell the difference between inability to create a new object (connection, in this case) and simple pool exhaustion - there's no reason to block startup of the whole server just because one datasource is bad - you could be taking 20 applications down just because 1 has a database that went down. This like inability to connect should also be logged at error level. If nobody objects, I'll take this on and add this feature for 3.0. -danch. Ferguson, Doug wrote: > Hi, > > This is a thread that I think needs to move to DEV... > > Basically I feel that it is a royal pain that jboss hangs whenever I try to > startup jboss when a datbase is down and I've set the mbean to blocking. > > I would like to see a timeout feature to where I can setup the mbean with a > timeout parameter for the blocking. I would also be nice to have a default > timeout. > > Other people brought up interesting issues... Please check the thread. > > Thanks, > d. > > -----Original Message----- > From: Kaseman, Mark T > To: '[EMAIL PROTECTED]' > Sent: 6/29/2001 11:40 AM > Subject: RE: [JBoss-user] Strange Behavior When DataSource goes down. > > Number 2 is a big issue for me and OS/390 DB2. DB2 has an idle thread > time > out parameter, that causes the datasource to become unusable once DB2 > kills > the inactive connection/thread. I then must reboot JBOSS. Orion server > recovers the connection with no problem. > > -----Original Message----- > From: danch (Dan Christopherson) [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 29, 2001 12:11 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Strange Behavior When DataSource goes down. > > > In this case, no query has been executed. > > What I'd change: > 1. In the pools, object factory create methods should throw an exception > > when they can't create an object - this way we can tell pool exhaustion > from inability to create a pooled resource. > 2. The pools should have an ability to test connections to determine if > they're still good (configurable, of course). This is for those whose > database thwacks them on the head after some period of time (and no > ability to turn that behavior off) > > others? > > -danch > > > David Jencks wrote: > > >> Well, I kind of agree, however I don't know how to distinguish between > > the > >> db crashing and executing a query whose first results are available in > > 3 > >> hours...and you're willing to wait. I think if the driver can > > distinguish > >> and throw an exception, you get to see the exception. Otherwise, what > > do > >> you do? Some kind of time awareness such as jini leases would be > > nice, > >> however there certainly isn't any support for them in jdbc. Any > > ideas? > >> david jencks >> >> On 2001.06.28 15:32:20 -0400 Richard Kasperowski wrote: >> >> >>> David Jencks wrote: >>> >>> >>> >>>> Hi, >>>> I find it hard to understand what you want. >>>> >>>> jboss does try out connections from configured datasources on >>> > startup, > >>> and >>> >>> >>>> hangs if they can't connect. >>>> >>>> I don't see how this is a severe problem: if your datasource isn't >>>> >>> >>> working, >>> >>> >>>> neither will your app. >>>> >>> >>> When a datasource becomes unavailable after startup, it might be >>> desirable for the application to tell the user, "sorry, the database >> > is > >>> unavailable."? A user might find that more satisfactory than being >>> denied service. >>> >> > > > > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user > > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
