Oracle getting started Tutorial: Summary of Sequence used in the ADF

1. Use Groovy in EO attributes: Simple and Direct missing: Break number (newOracle. jbo. server. SequenceImpl (XXXX_SEQ, adf. object. getDBTransac

1. Use Groovy in EO attributes: Simple and Direct missing: Break number (new Oracle. jbo. server. SequenceImpl (XXXX_SEQ, adf. object. getDBTransac

1. Use Groovy in EO attributes

Excellent: Simple and Direct

Missing: disconnected number

(New Oracle. jbo. server. SequenceImpl ("XXXX_SEQ", adf. object. getDBTransaction (). getSequenceNumber ()

2. assign values to attributes in the create method of the java class corresponding to EO

Excellent: complex Sequence values can be generated.

Missing: disconnected number

3. Use the DBSequence type

Create a Trigger on the database to assign values to the table fields. In EO, set the field type to DBSequence.
Excellent: avoid disconnection

Missing: The value displayed on the interface is different from the value saved to the database by the final commit.

,