-
Log on to the WebSphere Administrative
console using the default url <http://localhost:9160/admin>
,
unless the port number has changed. If the port number has changed,
contact your WebSphere Administrator for log on details.
-
Enter the User ID, and then click Log in.
The Administration Console page appears.
-
In the navigation pad, select
Resources > JDBC Providers.
The JDBC Providers page
appears.
-
From the drop-down list, select the CES Server.
-
After you have selected the CES server from the list
displayed, click New.
-
In the Create New JDBC Provider Wizard, select
the Database type, the
Provider type, and the
Implementation type from the
drop-down lists and click Next.
For Oracle:
From the Database type list, select Oracle
From the Provider type list, select Oracle JDBC
Driver
From the Implementation type list, select Connection pool
data source.
For DB2:
From the Database type list, select DB2
From the Provider type list, select DB2
Universal JDBC
Driver Provider
From the Implementation type list, select Connection pool
data source.
-
If the WebSphere variable set for the JDBC driver is not
correct, the administrator can enter the valid JDBC driver path and click
Next.

-
In the Summary
panel, make sure all values are correct and then click
Finish.

-
The following message appears at the top of the
WAS Console, prompting you to save
your changes. Click Save.

-
Click the newly created JDBC Provider link from the list.
In this example the newly create JDBC provider is
DB2 Universal JDBC Driver Provider.

-
In the JDBC Provider panel, click
Data sources in the
Additional Properties section. The
Data Sources
page appears.
-
Click New to create a new data source for the
JDBC provider.
The Data Source Creation Wizard appears.
-
Enter the Data source name
and the JNDI name. For example:
In the Data source name
field, enter SRMDB
In the JNDI Name
field, enter
jdbc/SRMDB
Click
Next
For DB2, you see the following:

For Oracle, you see the following:

-
For DB2, enter the Database
name, Driver type,
Server name, and
Port number.
In the
Database name
field, enter the database name.
In the
Server name
field, enter
the server name where the database is
available.
In the
Port number
field, enter the TCP IP listener port
number.
Note: Contact your database administrator to obtain the TCP IP
listener port number.
For Oracle, in the URL field enter the database details. For example,
jdbc:oracle:thin:@localhost:1521:SRMDB.
For the exact values of the database
name, and port number, contact your database administrator.
Click Next. The
Summary page appears.
-
Make sure the information on the
Summary page is correct. If it is,
click Finish. The Data source is
created. Click Save .