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"
<JDB
CConnectionPool
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