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

来源:互联网 发布:计算机c语言查询软件吗 编辑:程序博客网 时间:2024/05/14 13:17
<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>


                                             
0 0