Spring com Jpa e c3p0

Boa Noite Pessoal Estou precisando utilizar c3p0 no meu projeto.

Quero saber como faço a configuração do c3p0 no meu projeto utilizando o spring...
Estou Utilizando Spring + JPA Provedor Hibernate

Meu Arquivo persistence.xml

<persistence-unit name="PU_DB">
	<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<properties>
			<property name="hibernate.connection.driver_class" value="org.postgresql.Driver" />
						
    		<property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/banco" />
			<property name="hibernate.connection.username" value="postgres" />
			<property name="hibernate.connection.password" value="postgres" />
			<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
			
			<property name="hibernate.connection.pool_size" value="25" />
			<property name="hibernate.connection.autoReconnect" value="true" />
			<property name="hibernate.generate_statistics" value="false" />
			
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="true" />
			<property name="hibernate.use_sql_comments" value="false" />			
			<property name="hibernate.hbm2ddl.auto" value="update" />
		
		</properties>
	</persistence-unit>

Arquivo app-config.xml do Spring

<?xml version="1.0" encoding="UTF-8"?>
 <beans xmlns="http://www.springframework.org/schema/beans"
 	    xmlns:security="http://www.springframework.org/schema/security"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="
		http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
		http://www.springframework.org/schema/security
		http://www.springframework.org/schema/security/spring-security-3.0.xsd
		http://www.springframework.org/schema/tx 
        http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
        http://www.springframework.org/schema/aop 
        http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-3.0.xsd">

   <bean id="entityManagerFactory" 
          class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="persistenceUnitName" value="PU_DB" />
   </bean>
    
   <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />
    <bean id="transactionManager" 
          class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
   </bean>
    
    <tx:annotation-driven transaction-manager="transactionManager" />
    
    <context:annotation-config />
	   <context:component-scan base-package="br.com.empresa.sistema" annotation-config="true"/>
   <aop:aspectj-autoproxy />

</beans>

A duvida e aonde colocar estas configurações do c3p0.

<property name="hibernate.connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" />
         <property name="hibernate.c3p0.min_size" value="5"/>
         <property name="hibernate.c3p0.max_size" value="100"/>
         <property name="hibernate.c3p0.timeout" value="1800"/>
         <property name="hibernate.c3p0.max_statements" value="50"/>
          <property name="hibernate.c3p0.idle_test_period" value="3000"/>

Estou Utilizando Spring 3.0 e Jpa 1
Hibernate 3.3 e estou utilizando o tomcat..

Quem esta gerenciando as transações e o spring.

Coloquei as tags do c3p0 no persistence.xml

<property name="hibernate.connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" />
<property name="hibernate.c3p0.min_size" value="5"/>
<property name="hibernate.c3p0.max_size" value="100"/>
<property name="hibernate.c3p0.timeout" value="1800"/>
<property name="hibernate.c3p0.max_statements" value="50"/>
<property name="hibernate.c3p0.idle_test_period" value="3000"/>

Não apareceu nenhuma mensagem de que o c3p0 esta sendo executado
como faço para verificar se esta ok ..

Topicos relacionados