Setting mysql jdbc in IBM Websphere v7.0 – web Appl. Server.

Setting mysql jdbc in IBM Websphere v7.0 – web Appl. Server.

1.png

1.) Right Click Resources > JDBC > JDBC providers, Choose your scope > Click New Button.

2.png

– Fill all the basic configuration.

  • Database Type : choose – User-defined
  • Implementation class name : com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource 
  • Name : mysql provider

1.1.) Next > (please download  mysql-connector-java-5.1.7-bin.jar ) , and add in database classpath information

3.png

1.2.) Next > Finish.

4.png

1.3.) Create JDBC Datasource, Select Data sources, then choose your Cell scope and click New.

5.png

1.4.) Next > select an existing JDBC provider “myslq jdbc provider

6.png

  • Next >

 7.png

  • Next > Finish.

9.png

1.5.) Click “JAAS -j2c authentication data

10.png

1.6.) Click New – set the mysql connection.

11.png

1.7.) Create our database name in mysql command.

  • mysql command : create database fndong_work_db;

1.7.1.) add the database name in New – Custom Properties

12.png

1.8) Restart Your WebSphere Server.

1.9.) Test the mysql connection

 – Click JDBC > Data Source > Click- ” MYSQL_DataSource” and click Button Test Connection.

13.png

 

… Good Luck..

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s