DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13068>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13068

Use of validationQuery parameter by BasicDataSourceFactory implementation

           Summary: Use of validationQuery parameter by
                    BasicDataSourceFactory implementation
           Product: Tomcat 4
           Version: 4.1.8
          Platform: All
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Unknown
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


When specifying a JNDI connection pool resource a parameter exists
"validationQuery" that is documented to "validate a connection before returning
it to the client".

Use of this does not appear to be implmented.

I have looked into the code of:
org.apache.commons.dbcp.BasicDataSourceFactory
                        BasicDataSource
                        PoolableConnectionFactory
                        PoolingDataSource

and cannot find any sql statment/execution that would use the SQL specified in 
the validationQuery parameter.

If I am wrong then sorry for waisting your time - but would it be possible to 
tell me where to find further documentation on this - or on how to refresh a 
pool of connections that have become invalidated by a loss in socket connection 
to the database.

Rob

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to