How to push real-time data changes from an oracle database into Coherence
We are on Oracle database 11gR1 and building an e-commerce application with Coherence data caching. All the data cached in Coherence is bound to change because of the underlying ERP application and we are looking at a way to propagate these changes into Coherence as and when they happen.
We already tried Database Triggers and DCN (Database Change Notification) to achieve the same and our data changes are huge and these processes were not able to handle them.
We are now looking to Oracle Streams but have not clue how to push data from an oracle Database into Coherence. Can anybody please let us know if it can done and how to achieve it.