readme

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· 代码 · 共 47 行

This is the integrated demonstration for AQ Features. Currently, it demos the 
following features:

i) Generic - Basic AQ features
	- Multiple ways to enqueue/dequeue
		- blocking/non-blocking dequeue
		- dequeue by condition
	- Time specification functions
		- expiration and delay
	- Publish/Subscribe		 

ii) Internet Access features
	- AQ operations from the Internet
	- Internet Security

iii) Transformation
	- Transformation feature
	- Create the transformation function and use it with Internet access

iv) XML
	- Queue with XML data
	- XML mapping from an object queue to queue with XMLTYpe attribute

v) Internet Propagation features
	- Demos. queue to queue propagation over HTTP

vi) Notifications
	- Email Notification
	- PL/SQL Notification

How to run the demo:

Scripts in directory Generic are required for all the demos. 

The demo. uses two database schema users bz and bz_adm. The schema bz_adm has
all the required message types, queuetables, queues, and tranformation 
mappings. User qz has the privileges to enqueue and dequeue from the queues in
schema bz_adm.

Each sql directory has a script run.sh. Execute this script. This will call
bz_main.sql after setting appropriate paramters. Each sql directory has a file 
bz_main.sql. bz_main.sql calls other scripts to create the schema objects and to
 give appropriate priviliges. 

Passwords used for the schemas are bz for bz and bz_Adm for bz_adm.