AQQueueTableProperty - Oracle 9i

This class represents queue table properties.

Constants for Message Grouping

public static final int NONE

public static final int TRANSACTIONAL

Constructor

public AQQueueTableProperty(java.lang.String p_type)

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

Constructor

Methods
getPayloadType

public java.lang.String getPayloadType() throws AQException

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

setPayloadType

public void setPayloadType(java.lang.String p_type) throws AQException

This method is used to set the payload type.

Methods

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.

setStorageClause
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.

public void setSortOrder(java.lang.String s_order) throws AQException
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

.setMultiConsumer
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

public void setMessageGrouping(int m_grouping) throws AQException

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

getComment

public java.lang.String getComment() throws AQException

This method gets the queue table comment.

setMessageGrouping

setComment

public void setComment(java.lang.String qt_comment) throws AQException

This method sets a comment.

setComment

getCompatible

public java.lang.String getCompatible() throws AQException

This method gets the compatible property.

getCompatible

setCompatible

public void setCompatible(java.lang.String qt_compatible) throws AQException

This method sets the compatible property.

getPrimaryInstance

public int getPrimaryInstance() throws AQException

This method gets the primary instance.

getPrimaryInstance

setPrimaryInstance

public void setPrimaryInstance(int inst) throws AQException

This method sets the primary instance.

getSecondaryInstance

public int getSecondaryInstance() throws AQException

This method gets the secondary instance.

getSecondaryInstance

setSecondaryInstance

public void setSecondaryInstance(int inst) throws AQException

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):


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 9i Topics