Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ditributed database  RSS feed

 
thamara chempakam
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
my requirement: i need to write a program to fetch the data from one database and insert the data into multiple databases those are distributed (here we are using postGreSQL only). which technology can i use for this?


thanks
 
Nitesh Kant
Bartender
Posts: 1638
IntelliJ IDE Java MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you writing the same data in different databases or a part of data goes to one database and other part goes to another?
Does this operation need to be transactional i.e. either the data will be written in all or none?
If you do *not* need transactional operation then you can have different jdbc connections for different databases and write the data as you normally do for a single database.
However, if you need transactional operation you need to have a distributed transactional manager and an XA driver. If you are using an application server, these will be as part of the server. If not, then you have to use a transactional manager.
 
Peter Chase
Ranch Hand
Posts: 1970
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this question really about Distributed Java?

I don't know enough about this particular question to answer it, but it sounds like only the databases are distributed and that they are not Java databases. Therefore, maybe this should be moved to JDBC or General Computing forum.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!