I have application A which updates DB and server B which reads data from DB. The server needs a way to get new data as soon as it becomes available.
1. Database polling? RRrrr I don't like that. 2. Make a intermediate module? Something like web service which is responsible for all DB access for both server and application.
I don't use EJB at this point so I can't take advantage of entity beans. DB triggers? Is it possible to get information on DB update in standard way which would be portable accross different DB engines?