Serge, "select 1" should be ok for all db's, it is legitimate ANSI SQL. However I know you're looking at DBCP in commons, and suggest that you look at Connection.isClosed(), it then becomes the responsibility of the JDBC driver to check the connection. I don't know what different drivers do for this, but I seem to recal that mm.MySQL will test the connection, and expect that others will do so also, although the JDBC2 javadocs are vague "Tests to see if a Connection is closed" about whether this should physically test the connection or simply report whether close() has been called yet.
d. > -----Original Message----- > From: Serge Knystautas [mailto:[EMAIL PROTECTED] > Sent: 21 July 2003 04:00 > To: [EMAIL PROTECTED] > Subject: Mordred to DBCP > > > I've made a sideways migration for our custom database pooling. James > used to use a custom pooler named mordred, and I've replaced it with the > DBCP 1.0 release. > > I call it a sideways migration because it effectively provides the same > thing... a pretty reliable database pooler that can't survive a database > outage. DBCP 1.0 has various bugs, including the inability to remove > bad connections from the database without a validation SQL statement. > > The point of this though is that DBCP at least has some hope of future > upgrades, while mordred does not. Eventually DBCP will have another > release with some of these issues cleaned up, and then we can just drop > in the replacement and get the upgrades. > > I committed to the 2.x branch, and I guess we can merge the changes to > 3.x as well if appropriate. > > -- > Serge Knystautas > President > Lokitech >> software . strategy . design >> http://www.lokitech.com/ > p. 1.301.656.5501 > e. [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
