Creating a Topic Browser for Topics of Oracle Object Type (ADT) Messages

Figure 15-33 Use Case Diagram: Create a Topic Browser for Topics of Oracle Object Type (ADT) Messages

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

Usage Notes

For topics containing AdtMessages, the selector for TopicBrowser 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 Topic - test_topic 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 Topic with Adt messages of type EMPLOYEE*/
TopicSession jms_session
TopicBrowser browser;
Topic        test_topic;

browser = ((AQjmsSession) jms_session).createBrowser(test_topic,
    "SUBS1", Employee.getFactory());