apache dbcp basicdatasource validator

# The SQL query that will be used to validate connections from this pool before
# returning them to the caller. If specified, this query MUST be an SQL SELECT
# statement that returns at least one row.
# Recommended settings:
# for MySQL/PostgreSQL/MS SQL use: SELECT 1
# for DB2                     use: SELECT 1 FROM sysibm.sysdummy1
# for Oracle                  use: SELECT 1 from dual

torque.dsfactory.oscommerce.pool.validationQuery=SELECT 1 from dual

 

 

引用http://59.151.21.101/search?q=cache:g-6vfzPdtRUJ:www.konakart.com/installationfaq.php+db2+validationQuery&hl=zh-CN&ct=clnk&cd=16&gl=cn&st_usg=ALhdy28FsQ9nlYAzOF4Njk9AReCfargYdA