Database Feed

[moulhim]

Hi
Does the Data Adapter example with a database integration is available or not yet? We are also very interested because we need to have a proof of concept with it.
Thanks

[Alessandro]

Not yey, sorry. We have been very busy on other fronts. If anybody out there has an example to post for the community, we would be grateful.

Cheers,
Alessandro

[gerard]

Dear Alessandro

Is the example of a database adapter available yet. It is quite a long time since this was first mentioned and it must be a very popular request.

Regards

Gerard

[Alessandro]

Hi Gerard,

We haven't had time to work on this example yet, even if it would be pretty simple to implement.

Basically, in the case of Java, it would be enough to take the Hello-World Data Adapter and add some JDBC code to poll a DB instead of generating pseudo-random data.

Again, my call to anybody who has this example done to share it with the community.

Thanks

[amarin]

What are the pros and cons between

1)reading directly from a DB source
and
2)reading from a file like xml

I write a program to dynamically creates an XML file when a transaction takes place. Then feeds it to the LS. One file for each item with 6 fields.
I have about 30 items in all.

[Alessandro]

Amarin,

The best approach would be to have an asynchronous data feed (based on some message-oriented middleware), which does not require polling. Both a DB and an XML data source are usually based on polling. That said, choosing between a DB and an XML file depends on many aspects, such as the polling frequency, the amount of data being polled, general architecture considerations, including transactions and fail-over. So it's impossible to provide a general answer.

[amarin]

Thanks for your reply Alessandro

What would the setup look like with MOM?
Do I use it alongside lightstreamer?

Would this be ok

http://www.jboss.com/products/platforms/dataservices

or

http://www.jboss.org/projects/

Do you recommend anything else?

Thanks again