WEB开发网
开发学院WEB开发Jsp JDBC连接RAC的配置源代码剖析 阅读

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

 2008-01-05 10:49:14 来源:WEB开发网   
核心提示:<JDBCConnectionPool Name="OracleRACPool" DriverName="oracle.jdbc.client.OracleDataSource" InitialCapacity="5" LoginDelaySeconds

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

Tags:JDBC 连接 RAC

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接