Only 48 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



  • Post Reply Bookmark Topic Watch Topic
  • New Topic

5 databases to synchronize  RSS feed

 
marcus don
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • 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
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • Quote
  • Report post to moderator
I think a solution could be using ejbLoad()/ejbStore callback,
setting Commit option "C".
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!