Before you begin
Before starting this task, the wsadmin tool must be running. See the Starting the wsadmin scripting client article for more information.Why and when to perform this task
Perform the following steps to configure a new WAS40 connection pool:
Steps for this task
Using Jacl:
set new40ds [$AdminConfig getid /Cell:mycell/Node:mynode/ Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/]
new40ds = AdminConfig.getid('/Cell:mycell/Node:mynode/ Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/') print new40ds
was4DS1(cells/mycell/nodes/mynodes:resources.xml$WAS40DataSource_1)
Using Jacl:
$AdminConfig required WAS40ConnectionPool
print AdminConfig.required('WAS40ConnectionPool')
Attribute Type minimumPoolSize Integer maximumPoolSize Integer connectionTimeout Integer idleTimeout Integer orphanTimeout Integer statementCacheSize Integer
Using Jacl:
set mps [list minimumPoolSize 5] set minps [list minimumPoolSize 5] set maxps [list maximumPoolSize 30] set conn [list connectionTimeout 10] set idle [list idleTimeout 5] set orphan [list orphanTimeout 5] set scs [list statementCacheSize 5] set 40cpAttrs [list $minps $maxps $conn $idle $orphan $scs]
{minimumPoolSize 5} {maximumPoolSize 30} {connectionTimeout 10} {idleTimeout 5} {orphanTimeout 5} {statementCacheSize 5}
minps = ['minimumPoolSize', 5] maxps = ['maximumPoolSize', 30] conn = ['connectionTimeout', 10] idle = ['idleTimeout', 5] orphan = ['orphanTimeout', 5] scs = ['statementCacheSize', 5] cpAttrs = [minps, maxps, conn, idle, orphan, scs] print cpAttrs
[[minimumPoolSize, 5], [maximumPoolSize, 30], [connectionTimeout, 10], [idleTimeout, 5], [orphanTimeout, 5], [statementCacheSize, 5]]
Using Jacl:
$AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs
print AdminConfig.create('WAS40ConnectionPool', new40ds, 40cpAttrs)
(cells/mycell/nodes/mynode:resources.xml#WAS40ConnectionPool_1)
Related concepts
AdminConfig object for scripted administration
Related reference
Commands for the AdminConfig object