Passing additional JDBC connection pool parameters via repo configuration.

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

remillet_

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"						
					/>
    ,,,

Florent_Guillau

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.