<?xml version="1.0" encoding="UTF-8" ?><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" xmlns:tx="http://www.springframework.org/schema/tx" 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.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd "> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="com.mysql.jdbc.Driver" /> <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/mydata" /> <property name="user" value="root" /> <property name="password" value="root" /> <property name="autoCommitOnClose" value="true" /> <property name="checkoutTimeout" value="5000" /> <property name="initialPoolSize" value="2" /> <property name="minPoolSize" value="2" /> <property name="maxPoolSize" value="4" /> <property name="maxIdleTime" value="25200" /> <property name="acquireIncrement" value="1800" /> <property name="maxIdleTimeExcessConnections" value="5" /> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="mappingDirectoryLocations"> <list> <value>classpath:/hvp/spring/hibernate/orm/</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"> org.hibernate.dialect.MySQLDialect </prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.generate_statistics">true</prop> </props> </property> </bean> <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <bean id="userDAO" class="hvp.spring.hibernate.orm.UserDAO"> <property name="hibernateTemplate" ref="hibernateTemplate" /> </bean> <bean id="purDAO" class="hvp.spring.hibernate.orm.PurDAO"> <property name="hibernateTemplate" ref="hibernateTemplate" /> </bean> <bean id="service" class="hvp.spring.hibernate.orm.Services"> <property name="userDAO" ref="userDAO" /> <property name="purDAO" ref="purDAO" /> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <tx:annotation-driven /></beans>