On Jan 19, 2008 2:21 PM, cchalmers <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Together with a colleague I've just started a small project to build up
> knowledge concerning EDA and have currently chosen ServiceMix as the
> implementation tool. Bear with me as a lot of this is new new to me.
>
> The case we're trying to implement is a travel booking-system. Employees,
> customers and airlines can be persisted after-which a customer can make a
> booking etc.
>
> One of the things we want to prove is that when data changes in the database
> that an event is generated and action undertaken. For example if the flight
> data changes we want to send an sms to the passengers about the time change.
>
> I read that others are connecting to databases via the spring jdbc template.
> The question is how an event as generated concerning the changed data? As
> far as I see it there are two paths:
>
> 1. Continually polling the database from servicemix looking for changed
> records which would have to have a last-modified data and then generating an
> event
> 2. Working with triggers in the database which would somehow have to send an
> event to servicemix so that the sms can be sent.
>
> Is there a third (or more) option which I'm unaware of and is standard in
> servicemix?
> Perhaps I'm misunderstanding the EDA concept and how servicemix achieves
> this?
Your understanding is correct; there are basically two ways to
determine if data in a database has changed:
1) Poll the database with an external application, or
2) Configure a trigger in the database to notify an external application
Of course, the implementation of #1 above can be implemented in many,
many different ways. There are advantages and disadvantages to each
and the oly way to find a solution that will work for you is by using
specifics about your environment and your use case.
Bruce
--
perl -e 'print unpack("u30","D0G)[EMAIL
PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
Apache ActiveMQ - http://activemq.org/
Apache Camel - http://activemq.org/camel/
Apache ServiceMix - http://servicemix.org/
Apache Geronimo - http://geronimo.apache.org/
Blog: http://bruceblog.org/
