Set new WAS40 connection pools using scripting

Use scripting to configure a new WAS40 connection pool.

Before starting this task, wsadmin must be running. See the Start wsadmin article for more information.

Perform the following steps to configure a new WAS40 connection pool:

 

1. Identify the parent ID:
   • Jacl...

     set new40ds [$AdminConfig getid /Cell:mycell/Node:mynode/ Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/]

   • Jython...

     new40ds = AdminConfig.getid('/Cell:mycell/Node:mynode/ Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/') print new40ds

   For example...

   was4DS1(cells/mycell/nodes/mynodes:resources.xml$WAS40DataSource_1)

2. Get required attributes:
   • Jacl...

     $AdminConfig required WAS40ConnectionPool

   • Jython...

     print AdminConfig.required('WAS40ConnectionPool')

   For example...

   Attribute Type minimumPoolSize Integer maximumPoolSize Integer connectionTimeout Integer idleTimeout Integer orphanTimeout Integer statementCacheSize Integer

3. Set up required attributes:
   • 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]

     Example output:

     {minimumPoolSize 5} {maximumPoolSize 30} {connectionTimeout 10} {idleTimeout 5} {orphanTimeout 5} {statementCacheSize 5}

   • Jython...

     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

     For example...

     [[minimumPoolSize, 5], [maximumPoolSize, 30], [connectionTimeout, 10], [idleTimeout, 5], [orphanTimeout, 5], [statementCacheSize, 5]]

4. Create was40 connection pool:
   • Jacl...

     $AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs

   • Jython...

     print AdminConfig.create('WAS40ConnectionPool', new40ds, 40cpAttrs)

   For example...

   (cells/mycell/nodes/mynode:resources.xml#WAS40ConnectionPool_1)

5. Save the configuration changes. See the Saving configuration changes with wsadmin article for more information.

6. In a network deployment environment only, synchronize the node. See the Synchronizing nodes with wsadmin article for more information.

 

Related tasks

Use the AdminConfig object for scripted administration

 

Related

Commands for the AdminConfig object