配置连接池连接Oarcle RAC集群
来源:互联网 发布:tensorflow能用java吗 编辑:程序博客网 时间:2024/06/10 10:39
转自:http://blog.163.com/wenming_126@126/blog/static/19654138200722675655592/
只需在url处改为
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostIp1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = hostIp2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = hostIp3)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = serviceName)))
即可
URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.48.105)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.48.105)(PORT=1522))(FAILOVER=yes)(LOAD_BALANCE=no)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=RACDB)))"
Sample config.xml Code
An example of the connection pools, a WebLogic JDBC MultiPool, and an associated data source in the
config.xml
file would be:
<JDBCConnectionPool
CapacityIncrement="1"
ConnLeakProfilingEnabled="true"
CountOfTestFailuresTillFlush="1"
DriverName="oracle.jdbc.xa.client.OracleXADataSource"
InitialCapacity="5"
KeepXAConnTillTxComplete="true"
MaxCapacity="100"
Name="jdbcXAPool1"
PasswordEncrypted="{3DES}lBifoTsg8fc="
Properties="user=wlsqa"
RefreshMinutes="1" SupportsLocalTransaction="true"
Targets="WLSCluster"
TestConnectionsOnReserve="true"
TestTableName="dual"
URL="jdbc:oracle:thin:@db_server1:1521:SNRAC1"
XAEndOnlyOnce="true"
XARetryDurationSeconds="300"
XASetTransactionTimeout="true"/>
XATransactionTimeout="302"/>
<JDBCConnectionPool
CapacityIncrement="1"
ConnLeakProfilingEnabled="true"
CountOfTestFailuresTillFlush="1"
DriverName="oracle.jdbc.xa.client.OracleXADataSource"
InitialCapacity="5"
KeepXAConnTillTxComplete="true"
MaxCapacity="100"
Name="jdbcXAPool2"
PasswordEncrypted="{3DES}lBifoTsg8fc="
Properties="user=wlsqa"
RefreshMinutes="1"
SupportsLocalTransaction="true"
Targets="WLSCluster"
TestConnectionsOnReserve="true"
TestTableName="dual"
URL="jdbc:oracle:thin:@db_server2:1521:SNRAC2"
XAEndOnlyOnce="true"
XARetryDurationSeconds="300"
XASetTransactionTimeout="true"/>
XATransactionTimeout="302"/>
<JDBCMultiPool
Name="jdbcXAMultiPool1"
PoolList="jdbcXAPool1,jdbcXAPool2"
Targets="WLSCluster"
AlgorithmType="Load-Balancing"/>
<JDBCTxDataSource
JNDIName="jdbcXADataSource1"
Name="jdbcXADataSource1"
PoolName="jdbcXAMultiPool1"
Targets="WLSCluster"/>
- 配置连接池连接Oarcle RAC集群
- 用dbcp连接池链接RAC集群,怎么配置啊?
- sqlalchemy连接Oracle rac集群
- RAC(10g) 连接配置
- 连接集群的配置:
- RAC环境JDBC连接池
- JDBC连接RAC的配置-one example
- JDBC连接RAC的配置-oneexample
- JDBC连接oracle RAC数据库配置
- oracle rac 连接负载均衡配置
- JDBC连接oracle RAC数据库配置
- 客户端配置tnsnames连接RAC服务器
- JDBC连接oracle RAC数据库配置
- kettle连接集群环境配置
- eclipse 配置连接hadoop集群
- JDBC连接Oracle RAC的连接串配置
- JDBC连接Oracle RAC的连接串配置
- Oracle 集群RAC拒绝连接问题ORA-12545解决
- 关于UIView的autoresizingMask属性的研究
- SQLServer2008中报实例错误。
- SVN基本操作汇总
- Linux内核中64位除法函数do_di
- unity3d学习笔记(十二)--刀光剑影的制作
- 配置连接池连接Oarcle RAC集群
- 每天进步一点点——swift对象副本修复之简单理解
- iPhone开发--scr
- linux常用快捷键
- Android应用防止反编译apk打包签名步骤
- 一些算法面试题目
- Tomcat version 6.0 only supports J2EE 1.2, 1.3, 1.4, and Java EE 5 Web modules
- 每天写一点代码----完美字符串(庞果网)
- iPhone开发--问题 Not a PNG filCommand