Re: Publishing to MQ

From: Ravion <>
Date: Sun, 27 Apr 2008 08:30:28 +0800
Message-ID: <fv0dmv$hgu$>

Hi Klemme,

Thanks. Can you give a small brief about Advanced Streaming concept mentioned below? What did you mean by "back channel", thanks Any links?

"Robert Klemme" <> wrote in message
> On 26.04.2008 03:33, Ravion wrote:
>> I have huge number of data coming to my application through a bacth
>> process in main frame. Assuming that all this data are available in one
>> table, I have a PL/SQL procedure to manipulate the data and do some data
>> massaging and put into three tables.
>> There is a second procedure which processes the rows of these three
>> tables, and while the processing is going on, there can be some updates
>> coming to these tables through an online application. ( Note that we are
>> processing the data got from a bacth. Now we have some rows which are
>> coming to this table directly from internet i.e online)
>> THere is a Java Rule Engine waiting to process the output of the above
>> batch. Now my question is how PL SQL can inform Java that the bacth
>> processing is complete. This is because Java program will never know when
>> PL SQL batch completed its work, and while PL SQL is doing the batch,
>> there can be some more rows coming for it to process through online.
>> Is there any event pusblish mechanism i.e JMS way by which PL SQL can
>> notify Java that the processing is complete by putting a message into
>> queue? I dont want to go for triggers. Please advise the best design
>> possible, thanks a million.
> Just a few quick random ideas: there is Oracle Streams Advanced Queuing
> [1] but I doubt there is an easy back channel to your Java app and it's
> not sure whether your MF can use it.
> You could create a table for batch history which contains entries for
> batch start and end. If there is an entry where end is NULL a batch is
> running. You could poll that table.
> Alternatively, you could start your batches synchronously from your Java
> application and then you will know when it finishes.
> Kind regards
> robert
> [1]
Received on Sat Apr 26 2008 - 19:30:28 CDT

Original text of this message