01-09-2014 08:15 PM
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"
/>
,,,
01-24-2014 01:27 PM
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.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.