CODEWITHSUNDEEP
javaspringconnection-poolingc3p0
ROROROOROROR
ROROROOROROR

Reputation: 1109

ComboPooledDataSource poolsize configurations not working

I'm using com.mchange.v2.c3p0.ComboPooledDataSource as my datasource for an Oracle DB in a Spring MVC web project.

Here's my bean properties configurations for this class:

<bean id="pmiDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />
        <property name="jdbcUrl" value="jdbc:oracle:thin:@//server:port/SID" />
        <property name="user" value="****" />
        <property name="password" value="****" />
        <property name="acquireIncrement" value="3" />
        <property name="initialPoolSize" value ="10" />
        <property name="minPoolSize" value="10" />
        <property name="maxPoolSize" value="15" />
</bean>

here, no matter how I set the pool size, it doesn't change the threads number of ThreadPoolAsynchronousRunner. e.g

1.

<property name="minPoolSize" value ="1" />
<property name="initialPoolSize" value="1" />
<property name="maxPoolSize" value="15" />

2.

<property name="minPoolSize" value="5" />
<property name="initialPoolSize" value ="6" />
<property name="maxPoolSize" value="15" />

I always have 3 thread in my JVisual VM

Threads in the JVM

UPDATE : help help!

Upvotes: 0

Views: 626

Answers (1)

Steve Waldman
Steve Waldman

Reputation: 14073

The config parameter you are looking for is numHelperThreads.

Upvotes: 1

Related Questions