Passing additional JDBC connection pool parameters via repo configuration.

remillet_ — Fri, 10 Jan 2014 04:15:59 GMT

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

Re: Passing additional JDBC connection pool parameters via repo configuration.

Florent_Guillau — Fri, 24 Jan 2014 21:27:41 GMT

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.

topic Re: Passing additional JDBC connection pool parameters via repo configuration. in Nuxeo Forum

Passing additional JDBC connection pool parameters via repo configuration.

Re: Passing additional JDBC connection pool parameters via repo configuration.