Administer JDBC providers and data sources

 

Overview

A JDBC provider represents a JDBC driver. To access a database, the applications use data sources, which use a JDBC driver to access the database. WAS for iSeries supports these DB2 UDB for iSeries JDBC drivers:

 

Configure JDBC resources

To configure a JDBC provider, follow these steps:

  1. Start the administrative console.

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

  3. Specify the scope of the resource.

  4. On the JDBC Providers page, click New.

  5. In the JDBC Providers field, select one of the supported providers. WAS 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 the version of OS/400.

    Do not change the name of the JDBC provider if you select an existing JDBC provider from the drop-down list. This restriction does not apply if you use the User-Defined JDBC Provider feature and supply the provider information.

  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 resources

To modify a JDBC provider, follow these steps:

  1. Start the administrative console.

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

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

  4. Make the changes.

  5. Click Apply.

  6. 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 the 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 resources

To remove a JDBC provider follow these steps:

  1. Start the administrative console.

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

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

  4. Click Delete.

  5. 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.

 

See also