How to Create Sequence and Gapless Sequence

-

 How to Create Sequence and Gapless Sequence

1.      Sequence

Direct Seuqnce in Database Table


OFFICE_SEQ

Create one new application I have create EO, VO, AM





I am selecting ID primary Key and expand custom properties

And enable java calls


Adding sequence code in officeImpl



import oracle.jbo.server.SequenceImpl;


code

            SequenceImpl se = new SequenceImpl("OFFICE_SEQ",getDBTransaction());

                    this.setId(se.getSequenceNumber());


2.  Gapless_sequence

Create Seq Method in Database Sequence


CREATE_EMP_SEQ

 

 

Commit Seq Method in DataBase Sequence


COMMIT_EMP_SEQ

 

I have create new application and EO ,VO , AM




Here I am selecting ID and expand custom properties id and select non-translatble property


Create to Create and Commit sequence


Enable java class


Writing code fir create sequence

import oracle.jbo.server.AttributeDefImpl;

import oracle.jbo.server.SequenceImpl;


code

for(AttributeDef def : this.getEntityDef().getAttributeDefs()){ String sequenceName = (String)def.getProperty("CreateSequence");

if(sequenceName != null){ SequenceImpl s = new SequenceImpl(sequenceName, this.getDBTransaction()); populateAttributeAsChanged(def.getIndex(), s.getSequenceNumber()); } }




if(operation == DML_INSERT){

         System.out.println("Operation:---"+operation);

         for(AttributeDef def : this.getEntityDef().getAttributeDefs()){

         String sequenceName =

        (String)def.getProperty("CommitSequence");

         System.out.println("Seq Name:--"+sequenceName);

         if(sequenceName != null){

         SequenceImpl s = new SequenceImpl(sequenceName,

        this.getDBTransaction());

         System.out.println("Seq Number:"+s.getSequenceNumber());

         System.out.println  ("Def.getIndex:--"+def.getIndex());

        

         populateAttributeAsChanged(def.getIndex(),

        s.getSequenceNumber());

         }

         }

         }






 

 














 













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