Configure new connection pools using scripting

Before starting this task, the wsadmin tool must be running. See the Starting the wsadmin scripting client article for more information.

Perform the following steps to configure a new connection pool:

1. Identify the parent ID:

   • Using Jacl:

     set newds [$AdminConfig getid /Cell:mycell/Node:mynode/JDBCProvider:JDBC1/DataSource:DS1/]

   • Using Jython:

     newds = AdminConfig.getid('/Cell:mycell/Node:mynode/JDBCProvider:JDBC1/DataSource:DS1/')

   Example output:

   DS1(cells/mycell/nodes/mynode|resources.xml$DataSource_1)

2. Creating connection pool:

   • Using Jacl:

     $AdminConfig create ConnectionPool $newds {}

   • Using Jython:

     print AdminConfig.create('ConnectionPool', newds, [])

   Example output:

   (cells/mycell/nodes/mynode|resources.xml#ConnectionPool_1)

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

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

Related concepts
AdminConfig object for scripted administration

Related reference
Commands for the AdminConfig object