spring + hibernate+ C3P0+MYSQL如何配置

spring + hibernate+ C3P0+MYSQL怎么配置

我为这个问题专门写了一个测试用例：

看下面的几个文件：

可能贴的顺序上有点问题，楼主可以自己整理一下：

(1) applicationContext.xml

———————

<?xml version=”1.0″ encoding=”UTF-8″?>

<!DOCTYPE beans PUBLIC “-//SPRING//DTD BEAN 2.0//EN” “http://www.springframework.org/dtd/spring-beans-2.0.dtd”>

<beans>

<!– 引入参数配置文件 –>

<bean id=”propertyConfigurer” class=”org.springframework.beans.factory.config.PropertyPlaceholderConfigurer”>

  <property name=”locations”>

   <list>

    <value>jdbc.properties</value>

   </list>

  </property>

</bean>

<!– 配置数据源  –>

<bean id=”dataSource” class=”com.mchange.v2.c3p0.ComboPooledDataSource”>

  <property name=”driverClass”><value>${jdbc.driverClass}</value></property>

  <property name=”jdbcUrl”><value>${jdbc.url}</value></property>

  <property name=”user”><value>${jdbc.user}</value></property>

  <property name=”password”><value>${jdbc.password}</value></property>

  <property name=”initialPoolSize”><value>${jdbc.initialPoolSize}</value></property>

  <property name=”minPoolSize”><value>${jdbc.minPoolSize}</value></property>

  <property name=”maxPoolSize”><value>${jdbc.maxPoolSize}</value></property>

</bean>

<!– spring Hibernate SessionFactory –>

<bean id=”sessionFactory” class=”org.springframework.orm.hibernate3.LocalSessionFactoryBean”>

  <property name=”dataSource”>

   <ref bean=”dataSource” />

  </property>

  <property name=”hibernateProperties”>

   <props>

    <prop key=”hibernate.dialect”>org.hibernate.dialect.MySQLDialect</prop>

    <prop key=”hibernate.show_sql”>true</prop>

    <prop key=”hibernate.format_sql”>true</prop>

    <prop key=”hibernate.jdbc.fetch_size”>80</prop>

    <prop key=”hibernate.jdbc.batch_size”>35</prop>

   </props>

  </property>

  <property name=”mappingResources”>

   <list>       

    <value>com/spring/demo/bean/mapping/Book.hbm.xml</value>                                               

   </list>

  </property>

</bean>

<!– 事务管理器 –>

<bean id=”transactionManager” class=”org.springframework.orm.hibernate3.HibernateTransactionManager”>

  <property name=”sessionFactory”>

   <ref local=”sessionFactory” />

  </property>

</bean>

<!– 事务代理拦截器的配置 –>

<bean id=”baseTransactionProxy” abstract=”true” class=”org.springframework.transaction.interceptor.TransactionProxyFactoryBean”>

  <property name=”transactionManager”>

   <ref bean=”transactionManager” />

  </property>

  <property name=”transactionAttributes”>

   <props>

    <prop key=”insert*”>PROPAGATION_REQUIRED</prop>

    <