O'Reilly logo

Getting Started with Oracle Event Processing 11g by Lloyd Williams, Robin J. Smith, Alexandre Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enriching events using a database table

Now that you have a JDBC connection in place in the server's configuration file, you can use this to join to a table. Suppose that we have an OEP application that is processing the key attributes of a customer's complaints. We may want to evaluate the important details of each complaint in real time to establish the priority of each complaint in order to provide better customer service. To do this, we will want to include a reference to the customer table in our application.

You would use the <wlevs:table> tag to include a table within your EPN. For example:

<wlevs:table id="CUSTOMER" event-type="CustomerData" data-source="ReferenceDB"/>

Of course, you would need to define an event type with the appropriate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required