[DBCP-431] SQLException: Error preloading the connection pool after upgrade to commons-dbcp2

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: 2.0
• Fix Version/s: 2.0, 2.0.1
• Labels: commons-dbcp2 connection-pooling

Environment

Windows XP
Junit 4.11
Java 1.7
Spring 4.0
maven-compiler-plugin 3.2
maven.surefire.plugin 2.17
maven-cobertura-plugin 2.6
Jenkins 1.549

• Assignee: Unassigned
• Reporter: Sergio Cuenca
• Created: 27/Jan/15 08:56
• Updated: 30/Jan/15 13:27
• Resolved: 30/Jan/15 11:47

Description

Hi all,

We have a continuous integration environment (Jenkins) to launch our JUnits tests.
We had the version 1.4 of commons-dbcp to create the connection pools with Spring. The configuration was the following:

<bean id="dataSourceTemplate" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
	  <property name="driverClassName"><value>${aplicacion.datasource.driverClassName}</value></property>
	  <property name="url"><value>${aplicacion.datasource.url}</value></property>
	  <property name="username"><value>${aplicacion.datasource.user}</value></property>
	  <property name="password"><value>${aplicacion.datasource.password}</value></property>
	  <property name="initialSize"><value>1</value></property>
	  <property name="maxActive"><value>15</value></property>
	  <property name="maxIdle"><value>2</value></property>
	  <property name="accessToUnderlyingConnectionAllowed"><value>${aplicacion.datasource.accessToUnderlyingConnectionAllowed}</value></property>
	</bean>

We use JUnit 4.11 and maven cobertura plugin 1.6. to launch the tests.
This configuration was working CORRECTLY.

After upgrade to commons-dbcp2, version 2.0.1. Some unit tests are reporting errors with the following message:

java.sql.SQLException: Error preloading the connection pool.

We launch one unit test each time, one by one. We create and destroy the connection pool every time.

What can we do to solve this problem??
Thank you very much.