Oracle数据库双节点配置方法[通过数据库配置文件]

最新推荐文章于 2021-04-13 00:48:05 发布

Black-rabbit

最新推荐文章于 2021-04-13 00:48:05 发布

阅读量2.2k

点赞数

分类专栏：数据库知识

本文链接：https://blog.csdn.net/zhangli865621030/article/details/38893399

版权

数据库知识专栏收录该内容

34 篇文章 0 订阅

订阅专栏

<pre name="code" class="html"><?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
	
	<!-- oracle -->
	<bean id="c3p0DataSource"    
       class="com.mchange.v2.c3p0.ComboPooledDataSource"
       destroy-method="close">  
         
       <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>  
        <property name="jdbcUrl" value="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = ip1)(PORT = 端口号))(ADDRESS = (PROTOCOL = TCP)(HOST = ip2)(PORT = 端口号))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = 服务名)))"/>
       <property name="user" value="jnetcms"></property>    
       <property name="password" value="tiger"></property>  
          
       <property name="maxPoolSize" value="50"></property>    
       <property name="minPoolSize" value="10"></property>    
       <property name="initialPoolSize" value="10"></property>    
       <property name="acquireIncrement" value="5"></property>    
       <property name="maxIdleTime" value="30"></property> 
       <property name="checkoutTimeout" value="30000"></property>
	   <property name="idleConnectionTestPeriod" value="30"></property>
	   <property name="maxStatements" value="3000"></property>   
   </bean>
	
</beans>