Database Configuration
Database configuration with WAS 8.5
Database configuration with WAS 8.5
Task 1) Creating An Authentication Alias:
1)Login to admin console, Expand Security------->Click on "Global Security"
2)In authentication page, Expand "Java Authentication and Authorization Service"-------->Click on "J2C authentication data".
3)Click on "New".
4)Provide the values for Alias, User ID and Password. Here User Id and Password must have to access the database.
ex:Alias ----------- Sample_login
User ID ----------- sample (It is my database User ID)
Password ----------- xxxxxxxx(It is my database password)
Note: Here User ID and Password change according to your database.
5)Click on "Apply". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
6)Now u can check an authentication alias is created. It is like below image.
7)We completed first task......Now we will move to next task.....
=========================================================================
Task 2) Creating The JDBC Provider:
1)Expand "Resources" in the admin console.
2)Expand "JDBC". Click on "JDBC Provides". Then Select the Scope( I selected node scope).
3)Click on "New".
4)Provide the Database type, Provider Type, Implementation type and Name. Then click on "Next"
Ex:
Database type -------- Oracle
Provider type -------- Oracle JDBC Driver
Implementation type -------- Connection pool data source
Name -------- Oracle JDBC Driver (It is default name. If u want to change u will modify it)
5)Provide the path for jar files.(Where it is saved in your box).Then click on "Next".
6)Verify summary. Click on "Finish". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
7)Now you can check JDBC driver is created.
8) We completed Second task......Now we will move to last task.....
=========================================================================
Task 3)Creating Data Source:
1)Expand "Resources" in the admin console.
2)Expand "JDBC". Click on "Data sources". Then Select the Scope( I selected node scope).
3)Click on "New".
4)Provide Data source name and JNDI name. Then click on "Next".
ex: Data source name -------- sample
JNDI name -------- jndi/sample
5)Select "select an existing JDBC provide" radio button. Then select "oracle JDBC driver" in drop down list. Then click on "Next".
6)Specify the URL.
ex: jdbc:oracle:thin:@localhost:1521:XE
7)Select "Component-managed authentication alias", "Mapping-configuration alias " and "Container-managed authentication alias" from drop down list. Then click on "Next".
ex: Component-managed authentication alias ---- Sample_login
Container-managed authentication alias ---- Sample_login
8)Verify summary. Click on "Finish". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
9)Now you can check Data source is created.
10) We completed all tasks......Now we will check test connection.....
11)Select "sample"(My data source name) and click on "Test connection".
12)Verify test connection is successful or not. If it is successful you will get message like below image.
========================================================================
Detailed Description of configuring Database in WAS ND 8.5.x.x
Task 1) Creating An Authentication Alias:
Normally an authentication alias is required to access database. An authentication alias contains user ID and Password.
Now follow the step to complete this step.
1)Login to admin console, Expand Security------->Click on "Global Security"
2)In authentication page, Expand "Java Authentication and Authorization Service"-------->Click on "J2C authentication data".
2)Click on New
4)Provide the values for Alias, User ID and Password. Here User Id and Password must have to access the database.
ex:Alias ----------- Sample_login
User ID ----------- sample (It is my database User ID)
Password ----------- xxxxxxxx(It is my database password)
Note: Here User ID and Password change according to your database.
5)Click on "Apply". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
6)Now u can check an authentication alias is created. It is like below image.
7)We completed first task......Now we will move to next task.....!
Task 2)Creating the JDBC provider:
Follow the steps to complete this task.......
1)Expand "Resources" in the admin console.
2)Expand "JDBC". Click on "JDBC Provides". Then Select the Scope( I selected node scope).
3)Click on "New".
4)Provide the Database type, Provider Type, Implementation type and Name. Then click on "Next"
Ex:
Database type -------- oracle
Provider type -------- oracle JDBC Driver
Implementation type -------- Connection pool data source
Name -------- oracle JDBC Driver (It is default name. If u want to change u will modify it)
5)Provide the path for jar files.(Where it is saved in your box).Then click on "Next".
6)Verify summary. Click on "Finish". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
7)Now you can check JDBC driver is created.
8) We completed Second task......Now we will move to last task.....
Task 3)Creating Data Source:
Follow the steps to complete this task......
1)Expand "Resources" in the admin console.
2)Expand "JDBC". Click on "Data sources". Then Select the Scope( I selected node scope).
3)Click on "New".
4)Provide Data source name and JNDI name. Then click on "Next".
ex:
Data source name -------- sample
JNDI name -------- jndi/sample
5)Select "select an existing JDBC provide" radio button. Then select "oracle JDBC driver" in drop down list. Then click on "Next".
6)Specify the URL.
ex:
jdbc:oracle:thin:@localhost:1521:XE
7)Select "Component-managed authentication alias", "Mapping-configuration alias " and "Container-managed authentication alias" from drop down list. Then click on "Next".
ex:
Component-managed authentication alias ---- Sample_login
Container-managed authentication alias ---- Sample_login
Here Sample_login is name of an authentication alias.
8)Verify summary. Click on "Finish". Then Click on "review" and select the check box "Synchronize changes with Nodes" and click on "Save". Click on "Ok".
9)Now you can check Data source is created.
8) We completed all tasks......Now we will check test connection.....
9)Select "sample"(My data source name) and click on "Test connection".
10)Verify test connection is successful or not. If it is successful you will get message like below image.
Comments
Post a Comment