Groovy expression for assigning DB Sequence value to a Key attribute

In DB table we have primary key column and primary key is generated by Sequence. There are couple of way to assign the value to primary key attribute in ADF.

1) User Groove experssion: Add groove experssion into Entity key attribute and set value field,
  
  (new oracle.jbo.server.SequenceImpl("<Sequence Name>",adf.object.getDBTransaction())).getSequenceNumber()



2)  Generate Entity object class for entity object as shown in figure below figure
   
     


 
Override the doDML method as below,
 
 
    protected void doDML(int operation, TransactionEvent e) {
        if(operation==DML_INSERT)
           this.setFileid(( new SequenceImpl("Sequence Name",getDBTransaction  ()).getSequenceNumber()));
        super.doDML(operation, e);
    }
 
Or Override the Create method of entityImpl class ...
 
Enjoy :)
  

Comments

Post a Comment

Popular posts from this blog

React JS

Enable Intellisense for React component in VS code Run below command: npm i @types/react --save-dev How to write the scripts in package.json file NPM is package manager used to install delete and update JavaScript packages on your machine. NPX is package executor and it is used to execute JavaScript packages directly without installing it. To build scripts in package.json file use scripts sections, "scripts" : {     "build" : "parcel build index.html" ,     "start" : "parcel index.html"   }
Read more

WaterMark behavior in ADF

Image
How to create watermark/placeholder effect for input component in ADF What is watermark behavior A watermark typically appears as light gray text within an input or textarea element whenever the element is empty and does not have focus. This provides a hint to the user as to what the input or textarea element is used for, or the type of input that is required. For example, a search input space sometimes appears at the top of the page, giving the user quick access to the search functionality. Oftentimes you will see the word "Search" in light gray text in that space, and when the user clicks into the entry space, the word disappears. That is an example of a watermark.    How to implement 1)     Create your tag library First step is to create tab lib in your project. Just select New à WebTier à JSP à JSP tag library ·          Select deployable or project based option   ·          Provide tag lib file name URI and version details  
Read more

WebLogic Application Deployment & Shared Library

Image
In an enterprise application deployment scenario, there are many cases where some libraries are used/referenced by multiple applications. It would indeed be a bad design to include such common libraries with every application deployed on the WebLogic server. Not only does it prevent redundancy of resources on the server, it also consumes valuable space & deployment time - especially when the libraries are huge. WebLogic server offers the shared library concept using which EARs, JARs, EJBs and WARs can be shared across applications in a WebLogic domain. Let us now see how to package and deploy a shared library in WebLogic server; Step 1: Create a folder structure as shown below Step 2: Copy all the libraries (in this case JAR files) that you would want to share across applications to the lib folder under WEB_INF Step 3: Create a file under META_INF folder by name "MANIFEST.MF" Step 4: Contents of the MANIFEST.MF file are shown below Manifest-Version: 1.
Read more