Date Added: Dec 2009
Applications frequently need to pass messages to each other, and they need to do so reliably and often asynchronously. This goal is typically achieved with queuing: producer applications enqueue messages and consumer applications dequeue messages. A message stays in the queue until a consumer application dequeues it or the message expires. Oracle Streams Advanced Queuing provides database-integrated message queuing functionality. Because Oracle Streams Advanced Queuing is implemented in database tables, queue data enjoys the Oracle Database benefits of high availability, scalability, and reliability. Oracle Data Provider for .NET (ODP.NET), Oracle's ADO.NET-compliant data provider and includes administration tools that assist with tasks such as creating and modifying queues and queue tables. This article helps creating a set of .NET applications that make up a stock ticker system that demonstrates many Oracle Streams Advanced Queuing features. It begins with set up of the system's applications. It is connected to the Visual Studio and creates a new connection in Data Connections. The next step is to create the STOCK User-Defined Type. Oracle Database queues typically hold objects of a single type (unless they are defined as ANYTYPE queues) and can be an XMLType, a User-Defined Type (UDT), or a RAW type. Next is the creation of the Queue and the Queue Table. Finally is the step of Building the StockQueueLoader Application for the actual process.