AQQueueTableProperty - Oracle 9i

This class represents queue table properties.

Constants for Message Grouping

public static final int NONE

Constructor

This method creates an AQQueueTableProperty object with default property values and the specified payload type

Methods
getPayloadType

This method returns "RAW" for raw payloads or the object type for object payloads.

setPayloadType

This method is used to set the payload type.

setStorageClause

public void setStorageClause(java.lang.String s_clause) throws AQExceptio

This method is used to set the storage clause to be used to create the queue table.

getSortOrde

public java.lang.String getSortOrder() throws AQException

This method gets the sort order that is used.

Returns
The sort order used
setSortOrder

public void setSortOrder(java.lang.String s_order) throws AQException

This method sets the sort order to be used.

isMulticonsumerEnable

public boolean isMulticonsumerEnabled() throws AQException

This method queries whether the queues created in the table can have multiple consumers per message or not.

Returns

TRUE if the queues created in the table can have multiple consumers per message.

FALSE if the queues created in the table can have only one consumer per message.

setMultiConsumer

public void setMultiConsumer(boolean enable) throws AQException

This method determines whether the queues created in the table can have multiple consumers per message or not

.
getMessageGrouping

public int getMessageGrouping() throws AQException

This method is used to get the message grouping behavior for the queues in this queue table.

Returns

NONE: each message is treated individually

TRANSACTIONAL: all messages enqueued as part of one transaction are considered part of the same group and can be dequeued as a group of related messages.

setMessageGrouping

This method is used to set the message grouping behavior for queues created in this queue table.

getComment

This method gets the queue table comment.

setComment

This method sets a comment.

getCompatible

This method gets the compatible property.

setCompatible

This method sets the compatible property.

getPrimaryInstance

This method gets the primary instance.

setPrimaryInstance

This method sets the primary instance.

getSecondaryInstance

This method gets the secondary instance.

setSecondaryInstance

This method sets the secondary instance.

Examples:
1. Create a queue table property object with raw payload type

2. Create a queue table property object with raw payload type (for 8.1 style queues)

3. Create a queue table property object with “PERSON” payload type (ADT type):