FIGURE C

Click New to create a providers. Click picture for a larger image.

Click on the New button, which should bring you to the JDBC Provider Configuration entry screen, shown in Figure D.

FIGURE D

Configure your new provider. Click picture for a larger image.

Enter the JDBC Provider configuration parameters using the following information:

• Name: MySQL
• Description: MySQL JDBC 2.0-compliant Provider configuration
• Classpath: ${User-defined_JDBC_DRIVER_PATH}/mysql-connector-java-3.0.9-stable-bin.jar (or the appropriate name for the version of MySQL Connector/J that you are using)
• Native Library Path: <leave blank>
• Implementation Classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

When you have finished entering the data, click on OK. If there are no data entry errors, this should take you back to the list of JDBC Providers, where you should now see your new MySQL JDBC Provider displayed as shown in Figure E.

FIGURE E

You're now the proud owner of a new provider. Click picture for a larger image.

You should also see a message at the top of the screen informing you that changes have been made and indicating that you should save these changes to the Master Configuration. While you can take that step at this point, we will be making further changes and you might as well wait until everything has been completed and then save everything at once.

"The secret trick to making this work is the Datasource Helper Classname"

Create the base JDBC data source entry
Click on the name of your new MySQL JDBC Provider entry to return to the JDBC Provider Configuration screen. Scroll to the bottom of the screen and click on the Data Sources link in the Additional Properties section, as shown in Figure F.

FIGURE F

Scroll down for the Additional Properties section. Click picture for a larger image.

This should take you to the empty Data Sources list shown Figure G, where you need to click on the New button.

FIGURE G

Click new to create a new data source. Click picture for a larger image.

This will bring you to the Data Source Configuration screen, shown in Figure H.

FIGURE H

Enter the Data Source configuration parameters. Click picture for a larger image.

Enter the Data Source configuration parameters using the following information:

• Name: <data source name>
• JNDI (Java Naming and Directory Interface) Name: jdbc/<data source name>
• Description: <data source description>
• Statement Cache Size: 10 (the default)
• Category: <leave blank>
• Datasource Helper Classname: com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
• Component-managed Authentication Alias: <leave blank>
• Container-managed Authentication Alias: <leave blank>

The secret (and not very well publicized) trick to making this work is the Datasource Helper Classname. Without the proper datasource helper, you will run into all kinds of interesting challenges trying to get this to work.

When you have finished entering the data, click on OK. If there are no data entry errors, this should take you back to the list of JDBC data sources, where you should now see your new MySQL JDBC data source displayed, shown in Figure I.