Frequently firewalls, routers, servers and databases can be set up to time out a socket connection based on inactivity. You can:
1. Check to see if they are live on checkout with DBCP by having it ping the database before giving you the connection (expensive but almost foolproof) 2. Kill them after a certain period of inactivity in the pool to deal with timeouts (better bet for most cases where performance is the primary concern) and put retry logic in to get a live connection if the connection is dead for some other reason (AspectJ has a place here) --- Joao Batistella <[EMAIL PROTECTED]> wrote: > Thanks. > I do that. I only deal with the connection returned by DBCP. Is there a > timeout attribute (or anyother thing) that can close the connection? > > -----Original Message----- > From: Stephen Westbom [mailto:[EMAIL PROTECTED] > Sent: segunda-feira, 29 de mar�o de 2004 12:47 > To: Jakarta Commons Users List > Subject: Re: Connection is closed > > > Just a guess, but after your last question, don't ever call the close() > method > on the underlying connection object. That truly closes the connection and > you > will have a dead one in the pool. Only call close() on the DBCP connection > object decorator which simply returns the connection to the pool. > > --- Joao Batistella <[EMAIL PROTECTED]> wrote: > > Hello! > > > > I started using DBCP with Oracle 8i and I'm having the error "Connection > is > > closed" sometimes. How can I change the DBCP configuration to avoid this > > kind of error? > > > > Thanks, > > JP > > > > > ===== > Your source for complex solutions to simple problems > > __________________________________ > Do you Yahoo!? > Yahoo! Finance Tax Center - File online. File on time. > http://taxes.yahoo.com/filing.html > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ===== Your source for complex solutions to simple problems __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
