Spring+Hibernate+proxool为何不释放连接？

0 0

Spring+Hibernate+proxool为何不释放连接？10

proxool.xml配置如下：

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
	<proxool>
		<alias>dataSource</alias>
		<driver-url>jdbc:oracle:thin:@localhost:1521:test</driver-url>
		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
		<driver-properties>
			<property name="user" value="root" />
			<property name="password" value="root1234" />
		</driver-properties>
		<test-before-use>true</test-before-use>
		<house-keeping-test-sql>select null from dual</house-keeping-test-sql>
		<house-keeping-sleep-time>90000</house-keeping-sleep-time		
		<simultaneous-build-throttle>20</simultaneous-build-throttle>
 		<maximum-connection-count>50</maximum-connection-count>
		<minimum-connection-count>5</minimum-connection-count>
		<maximum-connection-lifetime>3600000</maximum-connection-lifetime>
	</proxool>
</something-else-entirely>

applicationContext.xml配置如下：

<?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:util="http://www.springframework.org/schema/util"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
		http://www.springframework.org/schema/util 
        http://www.springframework.org/schema/util/spring-util-2.5.xsd">

 	<bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">   
		<property name="driverClassName">    
			<value>org.logicalcobwebs.proxool.ProxoolDriver</value>    
		</property>    
		<property name="url">    
			<value>proxool.dataSource</value>
		</property>    
	</bean>    
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="myDataSource" />
		<property name="mappingLocations">
			<list>
				<value>classpath:com/domain/**/*.hbm.xml</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">${hibernate.dialect}</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
				<prop key="hibernate.autoReconnect">${hibernate.autoReconnect}</prop>
				<prop key="hibernate.connection.release_mode">auto</prop>
			</props>
		</property>
	</bean>

	<!-- 事务配置-->
	<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory"><ref bean="sessionFactory" /></property>
	</bean>
	<!-- 事务拦截器 -->
	<bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
		<property name="transactionManager" ref="transactionManager" />
		<property name="transactionAttributes">
			<props>
				<prop key="load*">PROPAGATION_REQUIRED</prop>
				<prop key="find*">PROPAGATION_REQUIRED</prop>
				<prop key="get*">PROPAGATION_REQUIRED</prop>
				<prop key="query*">PROPAGATION_REQUIRED</prop>
				<prop key="save*">PROPAGATION_REQUIRED</prop>
				<prop key="add*">PROPAGATION_REQUIRED</prop>
				<prop key="remove*">PROPAGATION_REQUIRED</prop>
				<prop key="update*">PROPAGATION_REQUIRED</prop>
				<prop key="execute*">PROPAGATION_REQUIRED</prop>
			</props>
		</property>
	</bean>

	<bean class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
		<property name="beanNames">
			<list><value>*Service</value></list>
		</property>
		<property name="interceptorNames">
			<list>
				<value>transactionInterceptor</value>
			</list>
		</property>
	</bean>

	<!-- 配置DAO -->
	<bean id="testDao" class="com.dao.hibernate.TestrDaoImpl">
		<property name="sessionFactory" ref="sessionFactory"/>
	</bean>

	<!-- 配置服务-->
	<bean id="testService" class="com.service.impl.TestServiceImpl">
		<property name="testDao" ref="testDao"/>
	</bean>
</beans>

TestServiceImpl 服务类代码：

public class TestServiceImpl implements TestServiceInftc {
	private TestDaoIntfc testDao;
	public void setTestDao(TestDaoIntfc testDao) {
		this.testDao= testDao;
	}
	public String queryData(){
		return testDao.selectData();
	}
}

TestDaoImpl类代码：

public class TestDaoImpl extends HibernateDaoSupport implements TestDaoIntfc {
	public String selectData()throws SQLException{
    		String sql = "select city_code from city where city='广州'";
		return (String)this.getSession().createSQLQuery(sql)).uniqueResult();
	}
}

这里的TestServiceInftc 接口和TestDaoIntfc 接口代码省略

监控下连接池情况，发现查询完毕后连接不会释放，当连接数达到最大就会报错，这是为什么呢？难道我的配置哪里错了吗？还是说非得手动关连接释放资源？

请教各位大哥啊~~

编程综合