I want to save processed event records in Oracle relational database.
How it can be done?
Is JDBC Cartridge can be used to insert records to databse? If yes, how can be done?
Or is it required to implement custom event store if database is other than derby, can't we use existing event store?
How to implement custom event store using API, where to download this API?
Edited by: 897694 on Mar 29, 2012 12:22 AM
I don't think JDBC cartridge is suitable for persist events into DB. It's easy to do it with record/playback. Below is the configuration that you can use:
Thanks for your input.
We have tried that and result is storing in table that is created by CEP itself.
I want to know how to assign existing table as a destination for event store, if existing table has as same schema.
I have one more question.
How 2 events are saving in database.
If i used one event type under <event-type-list> its working fine, saves data in db.
And then I have added with 2 events, no save of data.
I removed first event and kept second event, it added new column to the same table and saves details.
Why is that? Am i missing any configuration?