Adding External reference(DB adapter) in SOA Suite 11.1.1.3-part4

Open you jdeveloper and drag and drop a db adapter in the external reference swimlane.
It will open window





give it some logical name




Create a new connection



Provide the details of schema and check it



I got this exception but i am not sure what does it mean so ignoring it.





Choose to select the table.



Now choose the table



You might find an issue while searching your table as i faced when i clicked on search i found no table in my schema.This is because i have not committed the changes that i have made in the schema.So in my case i have again create the table and then commit those changes.

Further i am choosing CVV number as my primary key.



sinc we have only one table so we need not define any realtionship here



Again i would like to get all the parameters from db



Again next window is for Define selection criteria i am not sure of its use but we will check later.Say next and confirm.



Say next and finish and you should see the db adapter in Exteranl service



This is it for this exercise we will try to add process in component section in next exercise.