Adding number for Primary key in oracle ADF using groovy by sequence

Requriement – To create a primary key using sequence in Oracle ADF while create operation.

We have the primary key for any table.

We open the EO of that table. Go to attribute tab. select Primary key ID and go to property.

Select the default value to be “Expression” . and put value as

(new oracle.jbo.server.SequenceImpl(“SEQUENCE_NUMBER”,adf.object.getDBTransaction())).getSequenceNumber()

see the below screen shot

That it.. When you use create operation.Primary key will be generated automatically.

Happy Coding….


I am an Oracle ACE in Oracle ADF/Webcenter. Sr Java Consultant-working on Java/J2EE/Oracle ADF/Webcenter Portal/ content and Hibernate for several years. I'm an active member of the OTN JDeveloper/Webcenter forum. Passionate about learning new technologies. I am here to share my knowledge. Give your views and suggestion on [email protected] .

More Posts - Website

Follow Me:
TwitterLinkedInGoogle PlusYouTube