DBCP connection pool and validation query

[Danilo Tommasina]

Hi everybody,

We have following problem.:
We are using the DBCP connection factory, we've set a validation query, however 
we never see this query beeing executed.
Now we set the testOnBorrow, testOnReturn and testWhileIdle to "true", the 
query is still never logged (by p6spy).

Manually killing the database connections (MySQL), does not corrupt the pool, however since we do not see the validation query beeing executed, we have no idea 
if it is working as expected or not.

Do you have any hints?

here an extract of the repository.xml

    <jdbc-connection-descriptor
        jcd-alias="ors_jcdAlias"
        default-connection="true"
        platform="SET_AT_RUNTIME"
        jdbc-level="2.0"
        useAutoCommit="2"
        validationQuery="SELECT 1 FROM TMP_USER_NODE"
        testOnBorrow="true"
        testOnReturn="true"
        testWhileIdle="true"
        driver="SET_AT_RUNTIME"
        protocol="jdbc"
        subprotocol="SET_AT_RUNTIME"
        dbalias="SET_AT_RUNTIME"
        username="SET_AT_RUNTIME"
        password="SET_AT_RUNTIME"
  >

<!-- (...)  -->

        <connection-pool
            maxActive="10"
            maxIdle="2"
            maxWait="5"
            minEvictableIdleTimeMillis="60000"
            timeBetweenEvictionRunsMillis="-1"
            whenExhaustedAction="2"
        />

<!-- (...)  -->

    </jdbc-connection-descriptor>

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