Databases Reference
In-Depth Information
In this recipe, the JTA is configured with 600 and the XA data source is configured with 620. In
this case, the parameter DISTRIBUTED_LOCK_TIMEOUT of the Oracle Database should also
be set with a higher value, such as 1000 seconds.
Comparing configurations
JTA (600) < Data Source XA (620) < Oracle Database (1000).
There's more...
The timeouts can be configured through WLST.
Configuring the transaction timeout by using WLST
1. Log in as wls user to shell and start WLST:
[wls@prod01]$ $WL_HOME/common/bin/wlst.sh
2. Connect to the Administration Server using wlsadmin as the user, <pwd> as the
password and t3://adminhost.domain.local:7001 as the server URL:
wls:/offline> connect("wlsadmin","<pwd>","t3://adminhost.domain.
local:7001")
3. Run the following WLST commands:
edit()
startEdit()
cd('/JTA/PROD_DOMAIN')
cmo.setTimeoutSeconds(600)
cd('/JDBCSystemResources/ds-XA/JDBCResource/ds-XA/JDBCXAParams/ds-
XA')
cmo.setXaTransactionTimeout(620)
cmo.setXaSetTransactionTimeout(true)
activate()
exit()
 
Search WWH ::




Custom Search