RE: [OFFTOPIC??] RE: dbcp connection and database restart

2003-07-10 Thread Angus Mezick
4 AM > To: Tomcat Users List > Subject: RE: [OFFTOPIC??] RE: dbcp connection and database restart > > > Angus, > > You can call Conection.isClosed(), but the documentation > suggests that this > is not a reliable method of telling that it is _definitely_ closed. > Ho

RE: [OFFTOPIC??] RE: dbcp connection and database restart

2003-07-09 Thread Andy Eastham
age- > From: Angus Mezick [mailto:[EMAIL PROTECTED] > Sent: 09 July 2003 15:53 > To: Tomcat Users List > Subject: [OFFTOPIC??] RE: dbcp connection and database restart > > > Is there a better way of doing this? Even if I 'select 1 from TABLE' I > don'

[OFFTOPIC??] RE: dbcp connection and database restart

2003-07-09 Thread Angus Mezick
Is there a better way of doing this? Even if I 'select 1 from TABLE' I don't like the fact that there is an extra DB communication for every connection I get from the pool. I don't know if there are alternatives to this in DBCP but are there any other ways to ask if a connection in a pool is stil