I am use Oracle CEP 10g R3 for filtering RFID events from a ALE Processor. I have written the CEP query "INSERT INTO JMSEvent
SELECT epcTAG,deviceID,timestamp FROM JMSEvent RETAIN 100 EVENTS WITH UNIQUE epcTAG GROUP BY epcTAG,
deviceID, timestamp having count(*) >= 0 "
The message onEvent() gets fired mupltiple times for the implemented class of EvenSink. Do I need to enable the Cache or make any necessay changes in the config side to make the query execute only once. Please let me know.