Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Continuous Query using Aggregation

695337Apr 17 2009 — edited Oct 8 2011
We are performing a group by aggregation across a multiple set of properties, summing across a number of other properties. This seems to work quite well, though we would like to be informed when the result changes (ie someone has updated the named cache).

Continuous queries only seem to work for straight filters, not aggregation. We could listen to updates to the named cache and just rerun the query, but this is quite a lot of data, and the cache is updated fairly frequently, and a number of clients will be performing it, so this is not really a good option for us.

Is anyone able to help us out with a solution?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2011
Added on Apr 17 2009
6 comments
1,579 views