Configure new data sources using scripting

You can configure new data sources using scripting and the wsadmin tool. Before starting this task, the wsadmin tool must be running. See the Starting the wsadmin scripting client article for more information.

In WebSphere Application Server, any JDBC driver properties that are required by your database vendor must be set as data source properties. Consult the article Data source minimum required settings, by vendor to see a list of these properties and setting options, ordered by JDBC provider type. Consult your database vendor documentation to learn about available optional data source properties. Script them as custom properties after you create the data source. In the Related links section of this article, click the "Configuring new data source custom properties using scripting" link for more information.

Overview

• AdminTask object

• AdminConfig object

AdminConfig gives you more configuration control than the AdminTask object. When you create a data source using AdminTask, you supply universally required properties only, such as a JNDI name for the data source. (Consult the article JDBCProviderManagement command group for the AdminTask object for more information.) Other properties that are required by your JDBC driver are assigned default values by Application Server. You cannot use AdminTask commands to set or edit these properties; use AdminConfig commands.

Procedure

• Using the AdminConfig object to configure a new data source:

  1. Identify the parent ID, which is the name and location of the JDBC provider that supports your data source.

     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. Fastpath: For supported JDBC drivers, you can also script data sources according to the same pre-configured templates that are used by the administrative console logic. Consult the article Creating configuration objects using the wsadmin tool for details.

     Using Jacl:

     $AdminConfig required DataSource

     • Using Jython:

       print AdminConfig.required('DataSource')

     Example output:

     Attribute   Type
     name    String

     If the database vendor-required properties (which are referenced in the article Data source minimum required settings, by vendor) are not displayed in the resulting list of required attributes, script these properties as data source custom properties after you create the data source.

  3. Set up the required attributes.

     Using Jacl:

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

     • Using Jython:

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

  4. Create the 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)

• Using the AdminTask object to configure a new data source:

  Using Jacl:

  $AdminTask createDatasource {-interactive}

  • Using Jython:

    AdminTask.createDatasource (['-interactive'])

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

• Synchronize the node. See the Synchronizing nodes with the wsadmin tool article for more information.

What to do next

Related Reference