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

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

Text description of the illustration adq14jpp8.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 browser for queues of Oracle object type (ADT) messages.

Usage Notes

For queues containing AdtMessages the selector for QueueBrowser 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.createBrowser

Example

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

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 browser for a Queue with Adt messages of type EMPLOYEE*/
QueueSession jms_session
QueueBrowser browser;
Queue        test_queue;

browser = ((AQjmsSession)jms_session).createBrowser(test_queue, 	              
                                     "corrid='EXPRESS'", Employee.getFactory());