{"id":4635,"date":"2015-04-26T20:00:52","date_gmt":"2015-04-26T12:00:52","guid":{"rendered":"http:\/\/rmohan.com\/?p=4635"},"modified":"2015-04-26T20:00:52","modified_gmt":"2015-04-26T12:00:52","slug":"setting-the-xa-transaction-timeout-values-for-a-datasource-through-wlst-script","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=4635","title":{"rendered":"Setting the XA Transaction timeout values for a datasource through WLST script"},"content":{"rendered":"

This post explain the approach to set some of the important timeout properties for XA datasources through WLST script.<\/p>\n

Set XA Transaction Timeout:<\/b>
\nEnables WebLogic Server to set a transaction branch timeout based on the value for XaTransactionTimeout.<\/p>\n

When enabled, the WebLogic Server Transaction Manager calls XAResource.setTransactionTimeout() before calling XAResource.start, and passes either the XA Transaction Timeout value or the global transaction timeout.<\/p>\n

XA Transaction Timeout:<\/b>
\nThe number of seconds to set as the transaction branch timeout.
\nIf set, this value is passed as the transaction timeout value in the XAResource.setTransactionTimeout() call on the XA resource manager, typically the JDBC driver.<\/p>\n

When this value is set to 0, the WebLogic Server Transaction Manager passes the global WebLogic Server transaction timeout in seconds in the method.<\/p>\n

If set, this value should be greater than or equal to the global WebLogic Server transaction timeout.<\/p>\n

XA Retry Duration:<\/b>
\nDetermines the duration in seconds for which the transaction manager will perform recover operations on the resource. A value of zero indicates that no retries will be performed.<\/p>\n

XA Retry Interval:<\/b><\/p>\n

The number of seconds between XA retry operations if XARetryDurationSeconds is set to a positive value.<\/p>\n

SetXATimeoutProperties.py<\/b><\/p>\n

def setXATimeoutProperties():
\ndsName=’SOADataSource’
\nedit()
\nstartEdit()
\n\u00a0<\/span>
\nserver=’AdminServer’
\ncd(“Servers\/”+server)
\ntarget=cmo
\n\u00a0<\/span>
\nprint ‘=========================================’
\nprint ‘Setting the timeout properties for DataSource….’
\nprint ‘=========================================’ \u00a0\u00a0<\/span>
\n\u00a0<\/span>
\ncd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCXAParams\/’+dsName)
\ncmo.setXaSetTransactionTimeout(true)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCXAParams\/’+dsName)
\ncmo.setXaTransactionTimeout(3000)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCXAParams\/’+dsName)
\ncmo.setXaRetryDurationSeconds(300)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCXAParams\/’+dsName)
\ncmo.setXaRetryIntervalSeconds(60)<\/p>\n

save()
\nactivate()<\/p>\n

print ‘Timeout settings for the datasource ‘+dsName+’ has been completed’
\n\u00a0<\/span>
\n\u00a0<\/span>
\ndef main():
\n\u00a0<\/span>
\nadminURL=’t3:\/\/10.30.34.216:8000′
\nadminUserName=’weblogic’
\nadminPassword=’reuters123′
\nconnect(adminUserName, adminPassword, adminURL)
\nsetXATimeoutProperties()
\ndisconnect()<\/p>\n

\u00a0<\/span><\/p>\n

main()<\/p>\n

Execute the script:
\ncd %WLS_HOME%\\common\\bin
\nwlst.sh SetJDBCTimeoutProperties.py<\/p>\n

Restart the server after successful execution.<\/p>\n

\"weblogicssrrerew-6\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This post explain the approach to set some of the important timeout properties for XA datasources through WLST script.<\/p>\n

Set XA Transaction Timeout: Enables WebLogic Server to set a transaction branch timeout based on the value for XaTransactionTimeout.<\/p>\n

When enabled, the WebLogic Server Transaction Manager calls XAResource.setTransactionTimeout() before calling XAResource.start, and passes either the XA […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4635"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4635"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4635\/revisions"}],"predecessor-version":[{"id":4637,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4635\/revisions\/4637"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}