Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | QUEUE_P_IMPLEMENTATION |
| Short Name | QPI |
| View Name | CI_QUEUE_P_IMPLEMENTATIONS |
| Description | The implementation of a persistent queue in an Oracle database |
| Sub-type of | QUEUE_IMPLEMENTATION |
| Versioning: | Belongs to: ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
ORACLE_DATABASE_REFERENCE PERSISTENT_QUEUE_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_QUI |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_DATABASE_REFERENCE | N |
Prompt: Oracle Database
Transferable only if null Defined on QUI supertype |
Must be defined in one and only one ORACLE_DATABASE | |
| PERSISTENT_QUEUE_REFERENCE | N |
Prompt: Persistent Queue
Transferable only if null |
Must be an implementation of one and only one PERSISTENT_QUEUE | |
| QUEUE_TABLE_DBU_REFERENCE | Y | Prompt: Queue Table Database User | May be created in queue table in schema of one and only one DATABASE_USER | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether definition complete and ready to be used by the generators
Prompt: Complete ? Uppercase Defined on QUI supertype | YESNO | Y |
| INFINITE_FLAG | VARCHAR2(1) | N | Indicates whether the retention time is unlimited
Prompt: Unlimited Retention Time ? Uppercase | YESNO | N |
| MAX_RETRIES | NUMBER(38, 0) | Y | Limit of the number of times a dequeue with the REMOVE mode can be attempted. If left null, the value from the PERSISTENT_QUEUE will be used for generation
Prompt: Max Retries | ||
| QUEUE_IMPLEMENTATION_SUBTYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal system maintained property indicating the subtype of QUEUE_IMPLEMENTATION
Not displayed Uppercase System maintained Not updatable by user Defined on QUI supertype | QUEUE_IMPLEMENTATION_SUBTYPE | |
| RETENTION_TIME | NUMBER(38, 0) | Y | Number of seconds for which a message will be retained in the queue table after being dequeued from the queue. If left null, the value from the PERSISTENT_QUEUE will be used for generation
Prompt: Retention Time Range: 0 to 99999999999999999999999999999999999999 | ||
| RETRY_DELAY | NUMBER(38, 0) | Y | Delay time in seconds before this message is scheduled for processing again after rollback. If left null, the value from the PERSISTENT_QUEUE will be used for generation
Prompt: Retry Delay | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| IMPLEMENTATION_DESCRIPTION | IMPDSC Defined on QUI supertype |
Implementation Description |
| IMPLEMENTATION_NOTES | IMPNOT Defined on QUI supertype |
Implementation Notes |
| Other Properties |
|---|
| QUEUE_P_IMPLEMENTATION has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference QUEUE_P_IMPLEMENTATION:
Note: