JDBC连接RAC的配置-one example

来源:互联网 发布:js输出时间日期格式 编辑:程序博客网 时间:2024/05/16 19:00

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