This is available in 3.0.7 (cvs), 3.2RC2 and later, and 4. Supply CheckValidConnectionSQL in your ds config. It's part of the jdbc jca wrappers for the rather obvious reason that jboss has no business knowing what interfaces are implemented by the connectionfactory-like object, connection-like object, etc. Real jca adapters are required to notify jboss with ConnectionErrorOccurred so jboss can destroy the ManagedConnection and clean up. Recently someone has started implementing such functionality for Oracle: it's in 3.2.
david jencks On 2003.03.19 21:16 David Wade wrote: > Is there a way of configuring a managed connection pool to validate the > db > connection before handing it out to an application? > > In WebLogic it is possible to set "test on reserve" and "test on > release", > in this way an application is never handed a dud connection out of the > pool. > > > Why would I want this performance impacting feature, basically I am > developing an extremely fault tolerant financial transaction processing > application and we want the application server to be able to gracefully > recover from database restarts without having to wait for the connections > to > be closed after reaching their maximum time in pool. > > It seems to me that feature should be part of JBoss, not a vendors > JDBC/JCA. > Usually it is possible to configure the query to use eg. "select * from > dual" for Oracle. > > thanks > > David > > > ------------------------------------------------------- > This SF.net email is sponsored by: Does your code think in ink? > You could win a Tablet PC. Get a free Tablet PC hat just for playing. > What are you waiting for? > http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
