Was learning notes configuration MySQL data source

Recently started to learn about was, which configures MySQL's DataSource in WebSphere today. I downloaded the is for developers version, we recommend that you download this version. Http://www.ibm.com/developerworks/downloads/ws/wasdevelopers/index.html

Run the was console and click the resource->jdbc->jdbc provider in the left navigation menu.

The developer version offers very few JDBC drivers, and we need to install the MySQL JDBC driver ourselves. Set the MySQL JDBC Drive storage path in the system to the WebSphere system variable before creating a new JDBC driver. Click ' Environment ', ' WebSphere variable ', create a new variable Mysql_jdbc_lib

Then go back to the JDBC Driver page and create a new JDBC driver named MySQL jdbc Provider

Notice here that the implementation class name is not the com.mysql.jdbc.Driver we usually use. A closer look at tip will find it necessary to fill in the implementation of Javax.sql.XADatasource or Javax.sql.ConnectionPoolDataSource, so here is the MySQL driver implementation Com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource. So far, MySQL's JDBC driver configuration is complete.

Then configure a DataSource to use for the app. Click on ' Resources ', ' jdbc ', ' data source ', create a new data source on the right panel, follow the wizard, and select the MySQL JDBC driver you just created when choosing the JDBC driver.

It is important to note that the helper class should be filled in com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper

Then on the far right there is a ' custom attribute ' link, Click to set this DataSource access to the database address, user name and password.

Finally, remember to test whether the link was successful. There are also some data pool configurations, such as maximum links, timeouts, and so on, which are nothing to be specific about.

Was learning notes configuration MySQL data source