{"id":4638,"date":"2015-04-26T20:10:41","date_gmt":"2015-04-26T12:10:41","guid":{"rendered":"http:\/\/rmohan.com\/?p=4638"},"modified":"2015-04-26T20:10:41","modified_gmt":"2015-04-26T12:10:41","slug":"setting-the-jdbc-connection-timeout-properties-through-wlst","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=4638","title":{"rendered":"Setting the JDBC Connection timeout properties through WLST"},"content":{"rendered":"

There are different timeout properties in JDBC connection, this post explain the approach to set some of the important timeout properties through WLST script.<\/p>\n

Inactive Connection Timeout:<\/b>
\nThe number of inactive seconds on a reserved connection before WebLogic Server reclaims the connection and releases it back into the connection pool.
\nYou can use the Inactive Connection Timeout feature to reclaim leaked connections – connections that were not explicitly closed by the application.<\/p>\n

Connection Reserve Timeout:<\/b>
\nThe number of seconds after which a call to reserve a connection from the connection pool will timeout.
\nWhen set to 0, a call will never timeout.
\nWhen set to -1, a call will timeout immediately.<\/p>\n

Statement Timeout:<\/b>
\nThe time after which a statement currently being executed will time out.
\nA value of -1 disables this feature.
\nA value of 0 means that statements will not time out.<\/p>\n

<\/div>\n
oracle.jdbc.ReadTimeout:<\/b><\/div>\n
The property oracle.jdbc.ReadTimeout helps to set read timeout while reading from the socket.<\/div>\n
oracle.net.READ_TIMEOUT for jdbc versions < 10.1.0.5 oracle.jdbc.ReadTimeout for jdbc versions >=10.1.0.5<\/p>\n

oracle.net.CONNECT_TIMEOUT:<\/b>
\nThe property oracle.net.CONNECT_TIMEOUT helps to set the login time out in Oracle.<\/p>\n

\n
<\/div>\n
SetJDBCTimeoutProperties.py<\/b><\/div>\n

def setJDBCTimeoutProperties():
\ndsName=’CRM6EAIReference’
\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+’\/JDBCDriverParams\/’+dsName+’\/Properties\/’+dsName)
\n#cmo.destroyProperty(getMBean(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCDriverParams\/’+dsName+’\/Properties\/’+dsName+’\/Properties\/oracle.net.CONNECT_TIMEOUT’))
\ncmo.createProperty(‘oracle.net.CONNECT_TIMEOUT’)<\/p>\n

#cmo.destroyProperty(getMBean(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCDriverParams\/’+dsName+’\/Properties\/’+dsName+’\/Properties\/oracle.jdbc.ReadTimeout’))
\ncmo.createProperty(‘oracle.jdbc.ReadTimeout’)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCDriverParams\/’+dsName+’\/Properties\/’+dsName+’\/Properties\/oracle.net.CONNECT_TIMEOUT’)
\ncmo.setValue(‘10000’)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCDriverParams\/’+dsName+’\/Properties\/’+dsName+’\/Properties\/oracle.jdbc.ReadTimeout’)
\ncmo.setValue(‘20000’)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCConnectionPoolParams\/’+dsName)
\ncmo.setInactiveConnectionTimeoutSeconds(120)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCConnectionPoolParams\/’+dsName)
\ncmo.setConnectionReserveTimeoutSeconds(30)<\/p>\n

cd(‘\/JDBCSystemResources\/’+dsName+’\/JDBCResource\/’+dsName+’\/JDBCConnectionPoolParams\/’+dsName)
\ncmo.setStatementTimeout(120)<\/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:\/\/localhost:8000′
\nadminUserName=’weblogic’
\nadminPassword=’welcome1′
\nconnect(adminUserName, adminPassword, adminURL)
\nsetJDBCTimeoutProperties()
\ndisconnect()<\/p>\n

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

main()<\/p>\n

<\/div>\n

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

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

<\/div>\n
<\/div>\n
<\/div>\n
\"weblogicssrrerew-7\"<\/a> \"weblogicssrrerew-8\"<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

There are different timeout properties in JDBC connection, this post explain the approach to set some of the important timeout properties through WLST script.<\/p>\n

Inactive Connection Timeout: The number of inactive seconds on a reserved connection before WebLogic Server reclaims the connection and releases it back into the connection pool. You can use the Inactive […]<\/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\/4638"}],"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=4638"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4638\/revisions"}],"predecessor-version":[{"id":4641,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4638\/revisions\/4641"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}