Administer JDBC providers and data sources with the administrative console

These sections describe how use the administrative console to configure, modify, and remove JDBC providers and data sources:

Configure JDBC providers and data sources

To configure a JDBC provider, follow these steps:

  1. Start the WebSphere administrative console.

  2. In the topology tree, expand Resources and click JDBC Providers.

  3. Verify that the scope is set to the server level.

  4. On the JDBC Providers page, click New.

  5. In the JDBC Providers field, select one of the supported providers. WebSphere Application Server - Express for iSeries supports all of the DB2 UDB for iSeries drivers. For the IBM Developer Kit for Java JDBC drivers, select the correct driver for your version of i5/OS.

  6. Click Apply.

  7. The name and implementation classname for the provider are provided for you.

    The Native Library Path is not configurable on iSeries.

  8. Click Apply or OK.

After you create a JDBC provider, configure data sources for the provider. To configure a data source, follow these steps:

  1. On the JDBC Providers page, click the name of the JDBC provider for which you want to configure a data source.

  2. On the JDBC provider's detail page, click Data Sources.

  3. On the Data Sources page, click New.

  4. Specify a name for the data source. You can also specify optional properties on this page.

  5. Click Apply.

  6. You can configure these additional properties for the data source:

    • Connection Pooling

    • Custom Properties

  7. Save the configuration.

Modify JDBC providers and data sources

To modify a JDBC provider, follow these steps:

  1. Start the WebSphere administrative console.

  2. In the topology tree, expand Resources and click JDBC Providers.

  3. Verify that the scope is set to the server level.

  4. On the JDBC Providers page, click the name of the provider that you want to modify.

  5. Make your changes.

  6. Click Apply.

  7. Save the configuration.

You can also modify data sources for the provider. To modify a data source, follow these steps:

  1. On the JDBC Providers page, click the name of the JDBC provider that includes the data source that you want to modify.

  2. On the JDBC provider's detail page, click Data Sources.

  3. On the Data Sources page, click the name of the data source that you want to modify.

  4. Make your changes.

  5. Click Apply.

  6. To modify additional properties for the data source, click Connection Pooling or Custom Properties at the bottom of the page.

  7. Save the configuration.

Remove JDBC providers and data sources

To remove a JDBC provider follow these steps:

  1. Start the WebSphere administrative console.

  2. In the topology tree, expand Resources and click JDBC Providers.

  3. Verify that the scope is set to the server level.

  4. On the JDBC Providers page, select the checkbox for the provider that you want to remove.

  5. Click Delete.

  6. Save the configuration.

To remove a data source, follow these steps:

  1. On the JDBC Providers page, click the name of the JDBC provider that contains the data source that you want to remove.

  2. On the JDBC provider's detail page, click Data Sources.

  3. On the Data Sources page, select the checkbox for the data source you want to remove.

  4. Click Delete.

  5. Save the configuration.