Configure new WAS40 connection pools using scripting

 

You can use scripting to configure a new WAS40 connection pool. Before starting this task, the wsadmin tool must be running. See the Start the wsadmin scripting client article for more information.

 

Overview

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

 

Procedure

1. Identify the parent ID:

   Use Jacl:

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

   • Use Jython:

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

   Example output:

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

2. Get required attributes:

   Use Jacl:

   $AdminConfig required WAS40ConnectionPool
   

   • Use Jython:

     print AdminConfig.required('WAS40ConnectionPool')
     

   Example output:

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

3. Set up required attributes:

   Use 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}
   

   • Use 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
     

     Example output:

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

4. Create was40 connection pool:

   Use Jacl:

   $AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs
   
   

   • Use Jython:

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

   Example output:

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

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

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

---

Use the AdminConfig object for scripted administration

 

Related Reference

Commands for the AdminConfig object