Tuesday 4 June 2013

DATASOURCE CREATION

OVERVIEW
The connection JNDI creation for the DB adapter requires three important steps.
to be carried out on the weblogic server.
1. Creation of Data Source - Providing the Physical Database connection details
2. Creation of Connection JNDI and linking the Data Source to the JNDI
3. Redeploying the resource adapter (DB adapter) for the server to
   accommodate the reflected changes.

Data Source Creation:
1. Logon to the Development WebLogic Console
2. Under Domain Structure Go to Services and Click  Data Sources.
3. Click on ‘New’ button under ‘Data Sources’    to create a New Data Source.
4. While creating the Data source you need to mention the JNDI value as jdbc/(your DB
   connection name) as shown below.
   Note: The JNDI  value and DB connection name will be provided  to us.
   Ex: The jdbc/dvoa013    Is created .
5. Now We need to add this Data Source (dvoa013) in the DBAdapter Connection pool.
   Go to Deployments Link
   Click the DBAdapater  link
6. Goto DBAdapter ‡ Configuration ‡ Outbound Connection Pools

7. Create a new connection pool and specify the same JNDI value (eis/DB/dvoa013) which you
   used while creating the DBAdapter.
8. Now select the newly created connection pool (eis/DB/dvoa072) and in
   XADatasourceName field enter the (jdbc/dvoa013) as shown
9. Now you need to update the deployment plan. Go to Deployments –> Select  
   DBAdapter –> Click on Update button as shown
10.Accept all the default values in the next screen flow and click Finish. By this the data
   source is successfully registered in the Db Adapter connection pool.