Win a copy of Learning OpenStack Networking: Build a solid foundation in virtual networking technologies for OpenStack-based clouds this week in the Cloud/Virtualization forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

ditributed database  RSS feed

Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

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.
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.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!