Configuring MySQL data sources in websphere7.0

First, Configuration j2c Authentication Aliases

1. Log on to was console, "security"--"global security"--find "Java Authentication and authorization service" on the right--click "J2C Authentication Data"

2. Select "New", enter "Alias", "User ID" and "password" (User ID is the user name that the software used to connect to the database is configured according to the XML file, alias can be the same as the user ID), click Apply, save (there are several new user names to connect to the database in the XML file)

Second, New JDBC provider

1. Create a new JDBC provider

2. Database type Select Custom, enter implementation class name, enter name click "Next"

Implementation class Name: Com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

3. Enter the path to the database jar package and click "Next"

4. Click "Finish"

Third, Configure the data source

1. Click the name of the new JDBC provider

2. Click "Data Source"

3. Click the "New" button

4. Locate the database file, enter the corresponding data source name and Jndi name, and click "Next"

5. Click "Next"

6. Select the alias and click "Next"

7. Click "Finish"

8. Click the name of the new data source

9. In "Data memory auxiliary control class name" Select User Custom, enter Com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper, click "OK"

10. Click the data source name again, click "Custom Properties"

11. Find the URL, click the URL

12. Enter the URL of the database connection and click "OK"

Iv. Test Connection

Configuring MySQL data sources in websphere7.0