指引网

当前位置: 主页 > 编程开发 > Java >

JDBC连接RAC的配置源代码剖析

来源:网络 作者:佚名 点击: 时间:2017-11-14 06:06
[摘要] JDBCConnectionPool Name="oracleRACPool" DriverName="oracle.jdbc.client.OracleDataSource" InitialCapacity="5" LoginDelaySeconds="1" MaxCapacity="5" Password="{3DES}I5fj3vh4+nI=" Properties="user=SCOTT" CountOfTestFailuresTillFlush="1" ConnectionReser
JDBC

  <JDBCConnectionPool
       Name="oracleRACPool"
       DriverName="oracle.jdbc.client.OracleDataSource"
       InitialCapacity="5"
       LoginDelaySeconds="1"
       MaxCapacity="5"
       Password="{3DES}I5fj3vh4+nI="
       Properties="user=SCOTT"
       CountOfTestFailuresTillFlush="1"
       ConnectionReserveTimeoutSeconds="120"
       KeepXAConnTillTXComplete="true"
       RefreshMinutes="5"
       TestConnectionsOnReserve="true"
       TestTableName="dual"
       PreparedStatementCacheSize="15"
       Targets="myCluster"
       URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))
       (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))
       (FAILOVER=yes)(LOAD_BALANCE=no)(CONNECT_DATA=(SERVER=DEDICATED)
       (SERVICE_NAME=dbservice.company.com)))"
       />
  
  <JDBCTxDataSource
       JNDIName="oracle-RAC-DataSource"
       Name="oracle-RAC-DataSource"
       PoolName="oracleRACPool"
       Targets="myCluster"
       />
------分隔线----------------------------