cancel
Showing results for 
Search instead for 
Did you mean: 

Passing additional JDBC connection pool parameters via repo configuration.

remillet_
Champ on-the-rise
Champ on-the-rise

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

Florent_Guillau
World-Class Innovator
World-Class Innovator

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.