Configure new data sources 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 data source:

1. Identify the parent ID:

   • Using Jacl:

     set newjdbc [$AdminConfig getid /Cell:mycell/Node:mynode/JDBCProvider:JDBC1/]

   • Using Jython:

     newjdbc = AdminConfig.getid('/Cell:mycell/Node:mynode/JDBCProvider:JDBC1/')
     print newjdbc

   Example output:

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

2. Obtain the required attributes:

   • Using Jacl:

     $AdminConfig required DataSource

   • Using Jython:

     print AdminConfig.required('DataSource')

   Example output:

   Attribute   Type name    String

3. Setting up required attributes:

   • Using Jacl:

     set name [list name DS1]
     set dsAttrs [list $name]

   • Using Jython:

     name = ['name', 'DS1']
     dsAttrs = [name]

4. Create a data source:

   • Using Jacl:

     set newds [$AdminConfig create DataSource $newjdbc $dsAttrs]

   • Using Jython:

     newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
     print newds

   Example output:

   DS1(cells/mycell/nodes/mynode|resources.xml#DataSource_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.

Related concepts
AdminConfig object for scripted administration

Related reference
Commands for the AdminConfig object