JDBC连接RAC的配置-one example

领测软件测试网
<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"
         />

文章来源于领测软件测试网 https://www.ltesting.net/