0 Replies Latest reply: Feb 24, 2009 5:44 AM by 620930 RSS

    Oracle CEP 10.3 Event Sink Issue

    620930
      Hi,
      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.

      Thanks in advance,

      Arijit De