Download Oracle Streams Advanced Queuing User's Guide and Reference

16
16
Oracle Java Message Service Types Examples
This chapter provides examples that illustrate how to use Oracle JMS Types to
dequeue and enqueue Oracle Database Advanced Queuing (AQ) messages.
The chapter contains the following topics:
■
How to Setup the Oracle Database Advanced Queuing JMS Type Examples
■
JMS BytesMessage Examples
■
JMS StreamMessage Examples
■
JMS MapMessage Examples
■
More Oracle Database Advanced Queuing JMS Examples
How to Setup the Oracle Database Advanced Queuing JMS Type
Examples
To run Example 16–2 through Example 16–7 follow these steps:
1.
Copy and save Example 16–1 as setup.sql.
2.
Run setup.sql as follows:
sqlplus /NOLOG @setup.sql
3.
Log in to SQL*Plus as jmsuser/jmsuser.
4.
Run the corresponding pair of SQL scripts for each type of message.
For JMS BytesMessage, for example, run Example 16–2 on page 16-5 and
Example 16–3 on page 16-7.
5.
Ensure that your database parameter java_pool-size is large enough. For
example, you can use java_pool_size=20M.
Setting Up the Examples
Example 16–1 performs the necessary setup for the JMS types examples. Copy and
save it as setup.sql.
Example 16–1
Setting Up Environment for Running JMS Types Examples
connect sys;
enter password: password
Rem
Rem Create the JMS user: jmsuser
Rem
Oracle Java Message Service Types Examples 16-1