ADF Database sequence using Groovy
We may have a database sequence that generate a primary key for the table. During the manual SQL insert query, we refer <SEQUENCE_NAME>.nextval to generate the next unique key for the primary key column. We could apply the same solution in ADF Entity object declarative using groovy expression.
To do this, open the entity object, Select Attribute that requires sequence value, Enable ‘Expression’, Select the expression icon and add the following expression as shown in the below image.
(new oracle.jbo.server.SequenceImpl(“<YOUR SEQUENCE NAME>”,adf.object.getDBTransaction())).getSequenceNumber()
In the above statement, replace <YOUR SEQUENCE NAME> with the database sequence name . For example if the sequence name is ‘SAMPLE_SEQ’ then following expression is valid.
Once it has been applied, Go the Source tab and change trustMode=”trusted” in TransientExpression for the attribute we enabled sequence just before. Default the value is unTrusted.
Note: You might get the following error if you not changed to Trusted mode.
([Static type checking] - [ADF Seurity Error] - Calling the constructor for class.jbo.server.sequenceImpl is not permitted)
The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.
Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
Latest posts by Govind (see all)
- Primavera Error: The database is not setup to use the authentication mode selected: WebSSO:LDAP - June 22, 2017
- Primavera P6 professional Login alert box:The database has not been configured to run background jobs. To correct this error contact your system administrator - June 22, 2017
- How to integrate Oracle BI Publisher and LDAP in WebLogic server - June 21, 2017