Configuring JDBC Resources for High Availability - Oracle WebLogic Server 12c Advanced Administration - page 97

cmo.setUrl('jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(LOAD_
BALANCE=OFF)(FAILOVER=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=dbhost-rac02)(PORT=1521)))(CONNECT_DATA=(SERVICE_
NAME=dbservice-rac02)(INSTANCE_NAME=instance-rac02)))')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02/Properties/ds-XA-rac02')
cmo.destroyProperty(getMBean('/JDBCSystemResources/ds-XA-rac02/
JDBCResource/ds-XA-rac02/JDBCDriverParams/ds-XA-rac02/Properties/
ds-XA-rac02/Properties/user'))
cmo.createProperty('user')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02/Properties/ds-XA-rac02/Properties/
user')
cmo.setValue('dbuser')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02/Properties/ds-XA-rac02')
cmo.createProperty('oracle.net.CONNECT_TIMEOUT')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02/Properties/ds-XA-rac02/Properties/
oracle.net.CONNECT_TIMEOUT')
cmo.setValue('10000')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCConnectionPoolParams/ds-XA-rac02')
cmo.setMaxCapacity(15)
cmo.setMinCapacity(15)
cmo.setSecondsToTrustAnIdlePoolConnection(0)
cmo.setTestConnectionsOnReserve(true)
cmo.setTestFrequencySeconds(900)
cmo.setInitialCapacity(0)
activate()
exit()
See also
F Creating a JDBC data source
F Creating a multi data source
F Creating a GridLink data source
F Tuning data sources for reliable connections