On 3/21/07, Alex_ynr <[EMAIL PROTECTED]> wrote:
I am working on a project and I have a rough layout of what the comms part of
it should be like. The following is a very simplified example of it but I
just wanna know whether it can be done with ServiceMix (and ActiveMQ)...
I have a DB server with, say, 2 tables, an Orders table and an Order_Items
table.
I want to poll the Orders table for new orders, if there is one, get the
associated order_items, build a message containing the order details and
items and publish it to activemq. Then, on the other side, subscribe to
activemq, get the message and write a file to the filesystem containing the
information in the message in a specific format.
The actual transactions are more complicated than this and there is more
than one but that is the general idea. I just wanna know whether it can be
done or if it's not worth the effort etc.
Please note that although I can program/understand Java, it's not my primary
development language so maybe it's a silly question.
I've developed a similar system in the past but I was using a proprietary
messaging and ESB solution that supported such a topology...
Yes, ServiceMix can handle this topology. The only pieces that it
doesn't currently offer are a database component and a database
poller.
Creating a database poller should be fairly simple because ServiceMix
already has a base poller and we can just extend it. I'm thinking that
it would perform a select count(*) from <table> and if the result
comes back greater than 0, then the rest of the flow is triggered.
Creating a database component that is generically usable would be a
bit more work, but this is certainly achievable.
We can help you create both of these if you can work with us on the
use case. I've wanted to create each of these for some time now, but I
just haven't had a chance.
Bruce
--
perl -e 'print unpack("u30","D0G)[EMAIL
PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
Apache Geronimo - http://geronimo.apache.org/
Apache ActiveMQ - http://activemq.org/
Apache ServiceMix - http://servicemix.org/
Castor - http://castor.org/
