Element Type Definition: PERSISTENT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	PERSISTENT_QUEUE
Short Name	PQU
View Name	CI_PERSISTENT_QUEUES
Description	A persistent Oracle queue is a repository for messages, stored in the
	database in a queue table

Sub-type of	QUEUE
Versioning:	Structure of PERSISTENT_QUEUE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_QUE

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
QUEUE_TABLE_DEF_REFERENCE	Y	Prompt: Queue Table	May be created in one and only one QUEUE_TABLE_DEFINITION

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
AUTO_COMMIT_FLAG	VARCHAR2(1)	N	Indicates whether messages are to be committed automatically. "Default" indicates to use the database default Prompt: Auto Commit ? Uppercase	YESNODEF	D
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 Prompt: Max Retries
NAME	VARCHAR2(30)	N	Name of the queue Prompt: Name Uppercase Defined on QUE supertype
QUEUE_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal system maintained property indicating the QUEUE subtype Not displayed Uppercase System maintained Not updatable by user Defined on QUE supertype	QUEUE_SUBTYPE
QUEUE_TYPE	VARCHAR2(9)	Y	Type of queue to be created Prompt: Queue Type Uppercase	QUEUE_TYPE
REMARK	VARCHAR2(2000)	Y	A brief comment about this queue Prompt: Comment Defined on QUE supertype
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 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 Prompt: Retry Delay

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on QUE supertype	Description
HELP	CDHELP Defined on QUE supertype	User/Help Text
NOTES	CDINOT Defined on QUE supertype	Notes

Other Properties
PERSISTENT_QUEUE 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference PERSISTENT_QUEUE:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each QUEUE_P_IMPLEMENTATION must be an implementation of one and only one PERSISTENT_QUEUE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype