DriverName="oracle.jdbc.client.OracleDat">

JDBC连接RAC的配置-one example

80酷酷网    80kuku.com

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



分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: