Re: Publishing to MQ

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?

Best,
Ravion
"Robert Klemme" <shortcutter_at_googlemail.com> wrote in message news:67h3f2F2ocds6U1_at_mid.individual.net...
> 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]
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/integrat.htm#sthref3346
Received on Sat Apr 26 2008 - 19:30:28 CDT