hibernate+proxool最大连接的问题

0 0

hibernate+proxool最大连接的问题5

最近在一个项目中使用了proxool，可最后在测试性能时当并发线程数大于数据库连接数时，总是会报如下异常：
java.sql.SQLException: org.logicalcobwebs.proxool.ProxoolException: ConnectionCount is 10. Maximum connection count of 10 cannot be exceeded.
请问怎么解决？
配置如见如下

<!-- 数据源配置 -->
	<bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">
		<property name="alias" value="spring-proxool" />
		<property name="driver">
			<value>${proxool.driver-class}</value>
		</property>
		<property name="driverUrl">
			<value>${proxool.driver-url}</value>
		</property>
		<property name="user">
			<value>${user}</value>
		</property>
		<property name="password">
			<value>${password}</value>
		</property>
		<property name="houseKeepingSleepTime">
			<value>${proxool.house-keeping-sleep-time}</value>
		</property>
		<property name="prototypeCount">
			<value>2</value>
		</property>
		<property name="maximumConnectionCount">
			<value>10</value>
		</property>
		<property name="minimumConnectionCount">
			<value>2</value>
		</property>
		<property name="houseKeepingTestSql">
			<value>${proxool.house-keeping-test-sql}</value>
		</property>
		<property name="simultaneousBuildThrottle">
			<value>2</value>
		</property>
	</bean>


	<!-- Hibernate配置 -->
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="namingStrategy">
			<bean class="org.hibernate.cfg.ImprovedNamingStrategy" />
		</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.default_schema">${hibernate.default_schema}</prop>
				<prop key="hibernate.autoReconnect">true</prop>
				<prop key="hibernate.connection.autocommit">true</prop>
				<prop key="hibernate.connection.release_mode">auto</prop>
				<prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>
				<prop key="proxool.pool_alias">spring-proxool</prop>
				<prop key="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</prop>  
			</props>
		</property>
		<property name="packagesToScan" value="com.cup.sh.entity" />
	</bean>

数据库调用代码如下：

Session session = this.getSessionFactory().openSession();
    	Transaction tx = session.beginTransaction();
    	Query query = session.createQuery("from TransRecord transRecord where transRecord.qid = :qid");;
    	query.setString("qid", qid);
    	Object transRecord = query.uniqueResult();
    	tx.commit();
    	session.close();