Passing additional JDBC connection pool parameters via repo configuration.

I've successfully setup a second repository (my Nuxeo instance has two repos using two different databases) using the following configuration. However, I'm trying to pass additional data source connection pool parameters (like 'validationQuery' and 'timeBetweenEvictionRunsMillis') to the JDBC data source. For some some reason, the params seem to have no effect. That is, I'm not seeing the expected 'validationQuery' being used by the connection pool. Am I using the correct mechanism?

<?xml version="1.0"?>
<component name="config:lifesci_domain-repository">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
    point="repository">
    <repository name="lifesci_domain"
        factory="org.nuxeo.ecm.core.storage.sql.ra.PoolingRepositoryFactory">
        <repository name="lifesci_domain">
            <pool   minPoolSize="0"
                    maxPoolSize="20"
                    blockingTimeoutMillis="100"
                    idleTimeoutMinutes="10"
                    testOnBorrow="true"
                    testWhileIdle="true"
                    validationQuery="SELECT 6"
                    timeBetweenEvictionRunsMillis="5000"                        
                    />
    ,,,
0 votes

1 answers

1833 views

ANSWER



The pool definition for a repository does not define a JDBC pool that returns connections, but a JCA pool that returns XA resources. Therefore, the configuration option are different and more limited. They are listed in VCS Configuration.

0 votes