proxool数据库连接池配置

WBOY
发布: 2016-06-07 15:56:58
原创
1540 人浏览过

proxool.xml配置 ?xml version=1.0 encoding=UTF-8?something-else-entirelyproxoolaliasspring_pro_pool/aliasdriver-urljdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.18.21)(PORT=1521))(CONNECT_DATA=(SERVICE_N

proxool.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
	<proxool>
		<alias>spring_pro_pool</alias>
	<driver-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.18.21)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))</driver-url>
		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
		<driver-properties>
			<property name="user" value="orcl" />
			<property name="password" value="<span style="font-family: Arial, Helvetica, sans-serif;">orcl</span><span style="font-family: Arial, Helvetica, sans-serif;">" /></span>
		</driver-properties>

		<house-keeping-sleep-time>90000</house-keeping-sleep-time>
		<maximum-new-connections>400</maximum-new-connections>
		<prototype-count>10</prototype-count>
		<maximum-connection-count>100</maximum-connection-count>
		<minimum-connection-count>10</minimum-connection-count>
		<house-keeping-test-sql>select CURRENT_DATE from dual</house-keeping-test-sql>
	</proxool>
</something-else-entirely>
登录后复制
spring配置文件配置
<bean id="placeholderConfig"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name ="locations">
			<list>
				<value>/WEB-INF/spring/myQuartzConfig.properties</value>
			</list>
		</property>
	</bean>

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">  
   		 <property name="driverClassName">  
             <value>org.logicalcobwebs.proxool.ProxoolDriver</value>  
         </property>
         <property name="url">  
             <value>proxool.spring_pro_pool</value>  
         </property>  
    </bean>
登录后复制
相关标签:
来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板