My apologies in advance for any mistakes - this is my first post. I think I am experiencing the same problem.
I have a JUnit test that exercises a Postgres 8.0.2 database by iterating 25 times doing roughly similar tasks.
When I run this test using c3p0-0.8.5.1.jar, everything is well-behaved. c3p0 threads are created at the beginning of each of the 25 iterations, and shut down either at the end of each iteration or shortly after the next iteration begins. Using Process Explorer on WinXP to observe connections to Postgres while the test is running, I see that the number of connections never exceeds 20.
Then I swap in c3p0-0.9.0.jar. Nothing else has changed. When I run the same test, c3p0's threads hang around until the JVM shuts down. Although the threads my test spawns shut down, almost all 25 (one for each iteration) c3p0 TimerThreads and each of their 3 helper ThreadPoolAsynchronousRunner$PoolThreads hang around. That's about 100 c3p0 threads.
1) Spawn a thread. (3 other threads are launched to do other things.) Inside that thread do the following steps using raw sql in Hibernate (note that app is not launched & Spring is not used) :
At the end of the test, launch the app using Spring. Shut down the app.
The test takes 30 minutes. During each iteration, my test launches 4 threads and c3p0 launches 4 threads.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<!--Do NOT specify this bean. Specifying it causes Spring to not honor the hibernate.connection.provider_class property specified in the Hibernate properties section.
See LocalSessionFactoryBean.afterPropertiesSet() {
...
if (this.dataSource != null) {
// set Spring-provided DataSource as Hibernate property
config.setProperty(Environment.CONNECTION_PROVIDER, LocalDataSourceConnectionProvider.class.getName());//*** This causes a LocalDataSourceConnectionProvider
to be used instead of what you specified in the Hibernate property. ***
}
...
}
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>org.postgresql.Driver</value>
</property>
<property name="url">
<value>jdbc:postgresql://localhost/Foo-Slot1</value>
</property>
<property name="username">
<value>postgres</value>
</property>
<property name="password">
<value>postgres</value>
</property>
</bean>
-->
<!-- Hibernate SessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<!--Do NOT specify this bean. Specifying it causes Spring to not honor the hibernate.connection.provider_class property specified in the Hibernate properties section.
<property name="dataSource">
<ref local="dataSource"/>
</property>
-->
<property name="mappingLocations">
<list>
<value>war.cache/WEB-INF/resource/Foo.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">net.sf.hibernate.dialect.PostgreSQLDialect</prop>
<prop key="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>
<!--prop key="hibernate.connection.pool_size">1</prop-->
<prop key="hibernate.connection.autocommit">false</prop>
<prop key="hibernate.cache.provider_class">net.sf.hibernate.cache.HashtableCacheProvider</prop>
<prop key="hibernate.show_sql">false</prop>
<!--<prop key="hibernate.default_schema">NOT-USED</prop>-->
<!--prop key="hibernate.jdbc.batch_size">0</prop-->
<!-- Connection pooling using c3p0 -->
<prop key="hibernate.connection.provider_class">net.sf.hibernate.connection.C3P0ConnectionProvider</prop>
<prop key="hibernate.c3p0.min_size">1</prop>
<prop key="hibernate.c3p0.max_size">100</prop>
<prop key="hibernate.c3p0.timeout">5000</prop> <!--in seconds-->
<prop key="hibernate.c3p0.max_statements_per_connection">100</prop>
<prop key="hibernate.c3p0.max_statements">0</prop>
<prop key="hibernate.c3p0.idle_test_period">300</prop> <!--in seconds-->
<prop key="hibernate.c3p0.num_helper_threads">2</prop> <!--Ignored by Hibernate's Environment class-->
<prop key="hibernate.c3p0.acquire_increment">1</prop>
</props>
</property>
</bean>
<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
<bean id="transactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="DomainObjectDAO" class="com.foo.framework.dist.storage.DomainObjectDAO">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
</beans>
Login
FAQ
Search
