I'm looking for information regarding Custom JDBC Adapter.
The idea is "to listen" to Database Change Event (Oracle DB) ,catch the query ant transfer it to Processor.
Any help would be appreciated .
I generally do that with DB triggers + Advanced Queues in the Database. WLS integrates with AQ natively and you can then forward the messages to CEP after consuming them from the AQ layer.
If it is Oracle database we can always look into DCN (Database Change Notification), isn't it?
We can create an EventAdapter adapter based on onDatabaseChangeNotification method of DatabaseChangeListener.
Please refer the following link
Edited by: calvinIsMe on Oct 31, 2012 10:55 PM