Creating a Queue Receiver for Queues of Oracle Object Type (ADT) Messages

Figure 14-20 Use Case Diagram: Create a Queue Receiver for Queues of Oracle Object Type (ADT) Messages

Text description of the illustration adq14jpp13.gif

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Operational Interface -- Basic Operations"

Purpose

Create a queue receiver for queues of Oracle object type (ADT) messages.

Usage Notes

The CustomDatum factory for a particular java class that maps to the SQL ADT payload can be obtained via the getFactory static method.

For queues containing AdtMessages the selector for QueueReceiver can be a SQL expression on the message payload contents or messageID or priority or correlationID.

• Selector on message id - to retrieve messages that have a specific messageID

  msgid = '23434556566767676'

  Note: in this case message IDs must NOT be prefixed with 'ID:'

• Selector on priority or correlation is specified as follows

  priority < 3 AND corrid = 'Fiction'
  
  

• Selector on message payload is specified as follows

  tab.user_data.color = 'GREEN' AND tab.user_data.price < 30000
  

Syntax

• Java (JDBC): Oracle9i Supplied Java Packages Reference, oracle.jms, AQjmsSession.createReceiver

Example

Assume the Queue - test_queue has payload of type SCOTT.EMPLOYEE and the java class that is generated by Jpublisher for this ADT is called Employee. The Employee class implements the CustomDatum interface. The CustomDatumFactory for this class can be obtained by using the Employee.getFactory() method.

/* Create a receiver for a Queue with Adt messages of type EMPLOYEE*/
QueueSession jms_session
QueueReceiver receiver;
Queue        test_queue;

browser = ((AQjmsSession)jms_session).createReceiver(test_queue, 
"JMSCorrelationID = 'MANAGER', Employee.getFactory());