Databases Reference
In-Depth Information
cmo.setValue('dbuser')
cd('/JDBCSystemResources/ds-XA-rac01/JDBCResource/ds-XA-rac01/
JDBCDataSourceParams/ds-XA-rac01')
cmo.setGlobalTransactionsProtocol('TwoPhaseCommit')
cd('/JDBCSystemResources/ds-XA-rac01')
set('Targets',jarray.array([ObjectName('com.bea:Name=PROD_
Cluster,Type=Cluster')], ObjectName))
4. Run the following WLST commands to create the second data source:
#create the ds-XA-rac02 data source
cd('/')
cmo.createJDBCSystemResource('ds-XA-rac02')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02')
cmo.setName('ds-XA-rac02')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDataSourceParams/ds-XA-rac02')
set('JNDINames',jarray.array([String('jdbc/ds-XA-rac02')],
String))
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02')
cmo.setUrl('jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_
LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost-rac02)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=dbservice-rac02)(INSTANCE_
NAME=instance-rac02)))')
cmo.setDriverName('oracle.jdbc.xa.client.OracleXADataSource')
cmo.setPassword('dbpwd');
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCConnectionPoolParams/ds-XA-rac02')
cmo.setTestTableName('SQL SELECT 1 FROM DUAL\r\n')
cd('/JDBCSystemResources/ds-XA-rac02/JDBCResource/ds-XA-rac02/
JDBCDriverParams/ds-XA-rac02/Properties/ds-XA-rac02')
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/
JDBCDataSourceParams/ds-XA-rac02')
cmo.setGlobalTransactionsProtocol('TwoPhaseCommit')
cd('/JDBCSystemResources/ds-XA-rac02')
Search WWH ::
Custom Search