Home > Database > Mysql Tutorial > body text

proxool数据库连接池配置

WBOY
Release: 2016-06-07 15:56:58
Original
1539 people have browsed it

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>
Copy after login
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>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template