Oracle getting started Tutorial: Solve the sequence disconnection problem in the ADF

When the Sequence is defined, if the cache is used, a Sequence jump occurs when the database is closed or down. To solve the sequence disconnection in the ADF program, you must first ensure that the sequence

When the Sequence is defined, if the cache is used, a Sequence jump occurs when the database is closed or down. To solve the sequence disconnection in the ADF program, you must first ensure that the sequence

When the Sequence is defined, if the cache is used, a Sequence jump occurs when the database is closed or down.

To solve the sequence disconnection number in the ADF program, make sure that the Oracle database does not generate a disconnection number.

1. For infrequently used Sequence, you can add NOCACHE in the definition, that is, no cache. In this way, the database will not be disconnected.

2. For frequently-used Sequence, CACHE is used for definition. You can use DBMS_SHARED_POOL to cache keep sequence.

The command is as follows:

Test:

1) DBMS_SHARED_POOL is not set

2) Set DBMS_SHARED_POOL

3. To avoid the Sequence break generated by clicking the new button in the ADF application, you can use the technique of defining the field type as DBSequence and combining Trigger.

For the method of using DBSequence In the ADF, refer to my other article: summary of the method of using Sequence in the ADF.