ADF DBSequence for table using trigger and sequence

In some database schema, we may have enabled a database 'Before Insert Trigger' for a table which inserts an auto generated sequence number in primary key field when an inserts happen. When we create an Entity Object for the same table in ADF and insert a record, it will throw an error for Primary key field cannot be empty/null. To solve this, Open the EO, select the primary key field, change type to DBSequence as shown below. After this, ADF EO uses the database trigger to insert primary key value

By | 2016-09-06T19:50:42+00:00 September 6th, 2016|Categories: ADF|Tags: , , |0 Comments
Like us on Facebook.