dbcp pool configuration from multiple Databases

[mohammad shadab]

Hello,

I have a single spring context which deal with multiple databases(total 5 databases) based on requests. I have set my db pool setting as below

<bean id="abstractDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" p:driverClassName="${jdbc.driverClassName}">
 <property name="initialSize" value="0" />
 <property name="maxIdle" value="8" />
<property name="minIdle" value="0" />
.......
.......
      <property name="removeAbandoned" value="true" />
</bean>

Now my question is , this pool settings will be for whole context or for each database. Let say i says maxidle=8 so there can maxidle=8*5  or it would be always just for all 5 Databases.

Thanks

[Tim Holloway]

You don't have one DBCP Connection Pool for multiple databases, you have one pool per database. Each one has its own JDBC URL, connection credentials - and pool settings.

Pools are collections of objects which are essentially identical. So a Connection to Database #1 and a Connection to Database #1 wouldn't make sense. How would you know which database you would be working with if you invoked getConnection on a pool of heterogeneous Connections?