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"
/>
更多精彩
赞助商链接