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