Create and configuring a JDBC provider using the administrative console

 

Overview

To access a database first create a JDBC provider. You 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:

   When you use the Universal Driver JDBC provider through the administrative console in WebSphere Application Server V5.1 to create a new Cloudscape JDBC Provider Network Server, the administrative console fills in the DB2 universal data sources settings by default, instead of the Cloudscape Network Server settings. These settings include:

   1. The DataStoreHelper class, which is: com.ibm.webspere.rsadapter,CloudscapeNetworkServerDataStoreHelper.

   2. The data source custom properties (see Vendor-specific data sources minimum required settings for Cloudscape.

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

7. Enter the properties for your JDBC providerFor 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
    

 

---