Friday 29 May 2015

Populating Primary key of table Using Sequence in ADF

-> Create the sequence
-> In the entity, identify the primary key attribute
-> Select Value Type as Expression in the Entity Attribute wizard
-> and provide expression value
ex value :
(new oracle.jbo.server.SequenceImpl("SXRCM0_COLUMN_MAPPINGS_ID_SEQ",object.getDBTransaction())).getSequenceNumber()

where "SXRCM0_COLUMN_MAPPINGS_ID_SEQ" is the name of the sequence