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

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

/