I'll post this for everyone who has the same problem. The reason why
<property name="hibernateProperties">
<props>
<!-- Connect Pool Provider -->
<prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider"</prop>
...
Does not work to setup c3p0 pooling is that I specified a datasource in my sessionFactory bean. In this case, Hibernate ignores the setting.
So the solution was to completely get rid of the dataSource and configure averything thorugh the "hibernateProperties" property:
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:util="http://www.springframework.org/schema/util"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd"
default-lazy-init="true">
<!--
****************************************************************************************************
* Hibernate session factory
****************************************************************************************************
-->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
scope="singleton">
<description>The session factory needed to create the (Hibernate)session.
The session in Hibernate is more or less a connection to the database
including some additional features.
</description>
<!-- the mapped resources -->
<property name="mappingResources">
<!-- List *.hbm.xml here -->
<list>
<value>hibernate/Trade.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<map>
<!-- Cache properies -->
<entry key="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"/>
<entry key="hibernate.cache.use_query_cache" value="true"/>
<!-- DB connection properties -->
<entry key="hibernate.connection.driver_class" value="some Driver Class"/>
<entry key="hibernate.connection.url" value="some DB URL"/>
<entry key="hibernate.connection.username" value="some DB username"/>
<entry key="hibernate.connection.password" value="some DB password"/>
<!-- Query properties -->
<entry key="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
<entry key="hibernate.show_sql" value="false"/>
<entry key="hibernate.format_sql" value="true"/>
<!-- C3P0 - Connection Pool Provider -->
<entry key="hibernate.connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider"/>
<entry key="hibernate.c3p0.min_size" value="5"/>
<entry key="hibernate.c3p0.max_size" value="20"/>
<entry key="hibernate.c3p0.acquire_increment" value="3"/>
<entry key="hibernate.c3p0.timeout" value="1800"/>
<entry key="hibernate.c3p0.idle_test_period" value="300"/>
<entry key="hibernate.c3p0.num_helper_threads" value="3"/>
<entry key="hibernate.c3p0.max_statements" value="0"/>
</map>
</property>
</bean>
<!--
****************************************************************************************************
* Spring transaction manager
****************************************************************************************************
-->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"
scope="singleton">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
<bean id="abstractDAO" abstract="true">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<bean id="tradeDAO"
parent="abstractDAO"
scope="singleton"
class="xyz.TradeDAO">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
</beans>
Note: You'd probably want to specify the "hibernateProperties" through the easier <props><prop></prop>...</props> format. Both do the same thing. Also don't forget to put the c3po jar file in the classpath!
To prove that c3p0 is actually doing something configure your log4j logger like this:
Login
FAQ
Search
