...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<Resource name="jdbc/flexdbDS" auth="Container"
type="oracle.ucp.jdbc.PoolDataSource"
factory="oracle.ucp.jdbc.PoolDataSourceImpl"
connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
minPoolSize="0"
maxPoolSize="100"
initialPoolSize="0"
autoCommit="false"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=**HOSTNAME**)(PORT=**PORT**)))(CONNECT_DATA=(SERVICE_NAME=**SERVICE_NAME**)))"
user="fd_admin"
password="**FD_ADMIN_PASSWORD**"
fastConnectionFailoverEnabled="true"
validationQuery="select 1 from dual"
testOnBorrow="true"
useLocalSessionState="true"
defaultAutoCommit="false"/> |
- Replace **HOSTNAME** with database host name.
- Replace **PORT** with database listener port.
- Replace **SERVICE_NAME** with database service name.
- Replace **FD_ADMIN_PASSWORD** with password of fd_admin.
...
- Type and factory must reference the UCP driver.
- Actual timeout values will be environment specific. I would start with the defaults(not setting them) and then increase as needed.
- Set CONNECT_TIMEOUT to a high value to prevent logon storms.
- DO NOT use RETRY_COUNT without RETRY_DELAY
- Set LOAD_BALANCE= ON per ADDRESS_LIST to balance SCANs
- Use one DESCRIPTION and more than one causes long delays