JDBC连接RAC的配置-one example

发表于:2007-07-02来源:作者:点击数: 标签:
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