首页 > 学院 > 开发设计 > 正文

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

2019-11-18 12:04:24
字体:
来源:转载
供稿:网友

  <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"
       />

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表