Sunday 6 May 2012

JNDI Creation For DB Adapter

Hi Guy's,

Please follow below steps for JNDI Creation for DB Adapter on soa version 11.1.1.6

Go to Admin Console.

Step 1).Create JDBC DataSource 
           Navigation:- Services 
                                --->Data Sources 
                              ----->New 
                                ---->Generic DataSource           
          Then pass     Name               = "Your Own Name"  Like Sical
                              JNDI Name     =  jdbc/Sical
                              Database Type =  select your db from LOV
  Then click on Next Button
  Then click on Next Button
  Then Pass your Database Details Like below

         then Click on  Test Configuration   Button 
         Then we got some message Like" Connection Test Succeeded"
         Then Click on Next Button   
         Then Select Your Target Server and click on Finish Button 
      We got some message like "Message icon - Success All changes have been activated. No restarts are necessary."


Step 2). Create Connection Factory 
           Navigation:- Click on Deployments
                            ---> Click on DB Adapter 
                           ---->  Click on Configuration 
                          -----> Click on  Outbound Connection Pool
                          ----->  Click on New 
                          ----> Select Radio Button
                          ---->Click     on Next Button 
          Then pass JNDI name = "eis/jdbc/Sical"
     
       Click on Finish Button 
      Click on Ok Button
      we got some message like "Message icon - Success A new deployment plan has been successfully created in C:\Oracle\Middleware\Oracle_SOA1\soa\connectors\Plan.xml."

Step 3). Update your DB Adapter
   Navigation:-Click on Deployments
                            ---> Click on DB Adapter 
                           ---->  Click on Configuration 
                          -----> Click on  Outbound Connection Pool
                         ------> Click on your JNDI name
          Then Assign XA DataSource name as "jdbc/Sical" and Save Button
Then Update your DB Adapter






        Here No need to change 
     Click on  Next Button 
    Click on  Finish Button
   Then we got some message like 
JNDI Creation completed


Now we can this JDNI Name: "eis/jdbc/Sical"




Thanks Guy's  
 I hope this is very useful for you.............















No comments:

Post a Comment