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

发表于:2007-06-22来源:作者:点击数: 标签:
JDB CC onnectionPool Name=" oracle RACPool" DriverName="oracle.jdbc.client. Oracle DataSource" InitialCapacity="5" LoginDelaySeconds="1" MaxCapacity="5" Password="{3DES}I5fj3vh4+nI=" Properties="user=SCOTT" CountOfTestFailuresTillFlush="1"

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

原文转自:http://www.ltesting.net