Create and configure a JDBC provider using the administrative console

 

+

Search Tips   |   Advanced Search

 

Overview

An application installed on WAS accesses a relational database through a JDBC provider, which is essentially a system-level software driver.

We can easily establish a JDBC provider from the administrative console.

 

Procedure

  1. Open the administrative console.

  2. Click...

    Resources | JDBC Providers

  3. Select the scope of your definition.

  4. Click New.

    If Java script is disabled for your browser, you do not see the three drop-down lists that are described in the next three steps (for database type, provider type, and implementation type) . Instead, you see a single drop-down box that lists all JDBC provider choices simultaneously (inclusive of every database, provider, and implementation type).

  5. Use the first drop-down list to select the database type of the JDBC provider we need 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. Then consult the JDBC provider vendor's documentation for information on specific properties required for data sources associated with this provider, and skip to step eight of this list.

  6. From the second drop-down list, select your JDBC provider type.

  7. From the third drop-down list, select the implementation type necessary for your application.

    If your application does not require that connections support two-phase commit transactions, choose Connection Pool Data Source. Choose XA Data Source, however, if your application requires connections that support two-phase commit transactions. Applications using this data source configuration have the benefit of container-managed transaction recovery.

  8. Click Next to view the general property settings page for your JDBC provider.

  9. Ensure that all required properties have valid values.

  10. Click Apply to view the page with your new JDBC provider settings.

    Note that two active data source links now appear under the Additional Properties heading on this page. To set up a data source, click the link that corresponds to the type required by your application, the V4 data source or the later version data source.

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

    If you modify the class path or native library path of a JDBC provider: After clicking OK, restart every application server within the scope of that JDBC provider for the new configuration to work. Otherwise, you receive a data source failure message.

 

See also

JDBC Provider collection
JDBC providers
Data sources
Create a data source using the administrative console
Vendor-specific data sources minimum required settings
Data source settings