• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

5 databases to synchronize

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have to get the latest information from five different databases.
Infomation could be adapted.
Databases are in different locations and are used by legacy applications.

The question is, how to synchronize those informations with a central web apps?

In the web application I have to view/monitor/edit the schedule and view/edit newsletters.

In order to send those newsletters I have to get
from different databases the related informations:
- latest jobs (current/scheduled) they contiunosly change
- email addresses
- newsletter (html/txt)


What do you suggest me

1) A multithreaded application that checks continuosly thru jdbc the 5 dbs?

2) Use different EJB + 1 SLSB for each databases, and call the SLSB from the central unit in order to get synchronized infos (Responsability of sync is on ejbs).

3) ?

Thanks a lot
 
(instanceof Sidekick)
Posts: 8791
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What does "synchronized" mean here? Do you have to assure that all five databases have exactly the same data? Or just get the latest from all five as of the same point in time?
 
marcus don
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
The central application, must be notified about db changes.

Application must be an observer of the 5 databases.

Application must be in sync with all the changes on the 5 databases (have always the latest value), in order to schedule correctly the mail sending also if the database is updated frequently.

Application must move newsletters from the sheduled queue to current queue and viceversa.

Sorry for my bad english
 
marcus don
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think a solution could be using ejbLoad()/ejbStore callback,
setting Commit option "C".
reply
    Bookmark Topic Watch Topic
  • New Topic