Creating a data source and connection pool on WebSphere 7.0

      In this section

Creating a JDBC provider

Creating a data source and connection pool

Create J2C security

Connecting to the database

Creating a JDBC provider

1.       The first step in creating a data source is to create a JDBC provider.

2.       Log in to the Integrated Solutions Console.

3.       In the left pane open Resources > JDBC and click JDBC Providers.

4.       In the right pane in Scope select Node=xxx, Server=yyy (where xxx is the name of you node and yyy the name of your server) and click New.

5.       In Step 1 select the database type, provider type, and a non-XA implementation type. For       example, Derby, Derby JDBC Provider, and Connection pool data source.

6.       Enter a name (for example, Akhil  JDBC Driver). 

7.       Click Next.

8.       Click Next

9.       A summary is provided in Step 3:

10.   Click Finish and Save to save the changes directly to the master configuration.

11.   Specify the Class Path and the Native Library Path in JDBC Providers>Akhil JDBC Driver(NOTE: In class path specify the path of both ojdbc6.jar and classes12.jar separating by the enter )

To create a data source and a connection pool:

1.       In the Integrated Solutions Console open Resources > JDBC and click Data sources.

2.       In the right pane in Scope select Node=xxx, Server=yyy (where xxx is the name of you node and yyy the name of your server) and click New.

3.       In Step 1, give a name to your data source and enter the JNDI name, (for example, JNDI/AkhilJDBC), otherwise Rule Team Server will not be able to use the data source click Next

4.       In Step 2, select your non-XA JDBC provider that you created in Creating a JDBC provider, and click Next.

5.       In Step 3, enter specific database properties for the data source (URL: jdbc:oracle:thin:@localhost:1521/orcl)

6.       In Step 4: Setup security aliases, click Next to accept the default values

7.       Step 5 displays a summary of your settings

8.       Click Finish. The connection pool is created and associated with the data source.

9.       Click Save to save the changes directly to the master configuration.

To create a J2C Security:

It specifies a list of user identities and passwords for Java(TM) 2 connector security to use

1.       Go to the Data sources > Akhil JDBC > JAAS - J2C authentication data and click New

2.       In General Properties field fill the User ID=<DB user name> and Password =<DB user Password> click Apply and Save the changes

3.       Assign the J2C security to the created data source, so go to Data sources>Akhil JDBC and in security setting panel select your newly created alias in Component-managed authentication alias field  

Connecting to the database

When you have created a data source and connection pool, you need to test the connection to your database.

To test the connection to your database:

1.       In Data Sources, select the check box next to Akhil JDBC.

2.       Click the Test Connection button.

3.       The status of the connection is indicated at the top.