Create and configuring a JDBC provider using the administrative console

To access a database first create a JDBC provider. One can do this from the administrative console. You need to know where your database software is installed and where the drivers are located.

 

  1. Open the administrative console.

  2. Click Resources > JDBC Providers.

  3. Select the scope of your definition.

  4. Click New.

  5. Use the drop-down list to select the type of JDBC provider to create. If the list of supported JDBC provider types does not include the JDBC provider that you want to use, select the User-Defined JDBC Provider. Consult the JDBC provider vendor's documentation for information on specific required properties.

    Do not change the name of the JDBC provider if you create it by selecting an existing JDBC provider from the drop-down list. This restriction does not apply if you are using the User-Defined JDBC Provider feature and supplying the provider information.

    Note: Using the administrative console to create a DB2 JDBC provider for a zSeries server causes an exception to occur.

    When you use the administrative console to create a DB2/390 JDBC Provider or a DB2/390 JDBC Provider (XA), an exception occurs with the message Name is not a valid entry. To work around this problem, choose the normal DB2 JDBC Provider to create a JDBC provider. They both use the same implementation class. When you create a data source under this provider, change the data store helper value from DB2DataStoreHelper to DB2390DataStoreHelper. Otherwise, your database access does not work.

  6. Click Apply to view the settings page for your JDBC provider.

  7. Enter the properties for your JDBC provider For more information, see JDBC Provider settings.

  8. Click Apply to view the page with your new JDBC provider settings. Note that there is now an Additional Properties section on this page. To set up a data source, click one of the data sources links. For more information about creating a data source, see Creating a data source with the administrative console.

  9. Click OK to return to the JDBC providers page, where your new JDBC provider appears in the list.

JDBC providers
Data sources
JDBC Provider collection
Data source settings

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.