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

1. Use Groovy in EO attributes

Excellent: Simple and Direct

Missing: disconnected number

1. (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

1. SequenceImpl sequence =
2. NewSequenceImpl ("XXX_SEQ", GetDBTransaction ());
3. Oracle. jbo. domain. Number seqNum = sequence. getSequenceNumber ();
4. String strSeq ='Sih _'+ SeqNum;
5. SetStorageInHeaderCode (strSeq );

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.

1. CREATE OR REPLACE TRIGGERASSIGN_SVR_ID
2. BEFOREINSERT ONSERVICE_REQUESTSFOREACH ROW
3. BEGIN
4. IF <strong>: NEW. SVR_IDIS NULL</Strong>OR<Strong>: NEW. SVR_ID <0 </strong>THEN
5. SELECTSERVICE_REQUESTS_SEQ.NEXTVAL
6. INTO: NEW. SVR_ID
7. FROMDUAL;
8. ENDIF;
9. END;