WebSphere Datasource Configuration

Configuring JDBC Providers using Admin console:-

Each JDBC provider is essentially an object that represents vendor-specific JDBC driver classes to Application Server, for establishing access to that particular vendor database. JDBC providers are prerequisites for data sources, which supply applications with the physical connections to a database.

To configure the transaction (XA) and non-transaction (Non-XA) JDBC providers:
1.       Log on to the WebSphere administrative console, with the URL, for example:
http://<appserverhost>:9060/ibm/console
2.       From Resources, select JDBC, and then click JDBC Providers.
3.       For non-clustered configuration, select the cell scope, Node=node_name, Server=server_name, from the Scope list.
4.       For clustered configuration, select the cluster scope, Cluster=cluster_name, from the Scope list.
5.       Click New to create the XA JDBC provider.
6.       Select Oracle as the database type.
7.       Select Oracle JDBC Driver as the provider type.
8.       Select XA datasource as the Implementation type, and then click Next.
9.       In the Directory location field, type the full path to the directory containing the Oracle JDBC driver.
10.   Click Next, then Finish.
11.   Click New to create the non-XA JDBC provider.
12.   Select Oracle as the database type.
13.   Select Oracle JDBC Driver as the provider type
14.   Select Connection pool data source as the Implementation type, and then click Next.
15.   Ensure that the value in the Directory location field is correct, and then click Next.
16.   Click Finish.
17.   Click OK or Apply, and then click Save directly to master configuration.