ALTERNATE KEY

-

                                                            ALTERNATE  KEY     

 1.Create New Table.              


                         

2.Create a New Application.

3.Create model part with Alternate Test EO,VO,AM.

4.Create one jspx page in View Controller and Drag&Drop  Alternate Test View  in that page as a form.

5.Add Create Insert and Commit buttons in that form.                             



6.Save&Run.                            

7.Click on Create Insert and give the different ID, same Name and click on submit and next Commit.                          




8.The Data is stored in the Database.                                





9.Go to AlternateTestEO ,in general click on Alternate Keys and move Name.          

                  


10.Create one more Jspx page. Drag&Drop AlterNateTestView.

11 .Add CreateInsert and Commit Buttons.              



12.Click on Create Insert and give the different ID, same Name and click on submit and next Commit. then we get a error because the Name attribute is set as  Alternate Key

                         

                               
                                                               Thank You 👋

                                                                                                                          K.Prathyusha.



Comments

Post a Comment

Popular posts from this blog

Programmatically invoke a Popup to create a new row.

-
Image
  Programmatically invoke a Popup to create a new row. Create an Application . Create the model part with Employee Table. Create EmployeeEO, EmployeeVO and AppModule. Now in the View controller project create a page (Employee.jspx). From the Data control drag and drop EmployeeVO1 (EmployeeVO instance) in to the page as Read only table. Surround this table with Panel Box. In the tool bar facet of panel box, drop a command button from the component pallate. Drag and drop Popup on to the page. Inside popup drop a dialog box. Create a ActionListenerEvent for the button "New". And bind RichPopup to the bean. Code for button.............       public void displayPopUp(ActionEvent actionEvent) {         // Add event code here...                  BindingContext bctx=BindingContext.getCurrent();         BindingContainer bctr=bctx.getCurrentBindingsEntry();         Operatio...
Read more

POJO(Plain Old Java Object) - Editable Data - DataControl.dcx

-
Image
POJO(Plain Old Java Object) - Editable Data - DataControl.dcx     Without using EO’s & VO’s we can create a UIPage with Java Class. First we need to create a Java Classes name it as a Entity Java Classes (i,.e. DepartmentsEO, EmployeesEO, LocationsEO.) Then Again create another three java classes for storing data in Department List Java class, Employee list, Location List. Below image for Creating Java classes.  End of the Page have a ZIP file  This JAVA class for creating list of Data (Dept list, Emplye list, location list) Now we have to create Another Java class for calling the All the above created java classes( This Java Class Act like APPMODULE ) Name it as Session Façade. After Creating Session Façade Java Class. Just Right click on the java class, in that options select the Create Data Control. CREATING DATA CONTROL After Creating Data control, All the java classes automatically created .XML files . Java Code for DepartmentsEO,   EmployeesEO, Locatio...
Read more

Dynamic Tabs in ADF

-
Image
First we have to create Departments and Employees(EO's,VO's,AM) Create Two task-flows ( Departments and Employees Creating JSPX page in adfc-config.xml Now Create to take " Oracle Dynamic Tabs Shell " (Max 15 tabs Only) In page template we have navigation facet, in that drag drop two links from component palette , for that link create ActionListener to write the java code in that.                                                            public class launcher {     public void openDepartmentsAsMain(ActionEvent actionEvent){         try{             TabContext.getCurrentInstance().setMainContent("/WEB-INF/dept-task-flow#dept-task-flow");         } catch (TabContext.TabContentAreaDirtyException e) {         }     }     pub...
Read more