Forums Register Login

ditributed database

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
There's a hole in the bucket, dear Liza, dear Liza, a hole in the bucket, dear liza, a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 985 times.
Similar Threads
[ hibernate ]composite
how to display data from database using comparator
Question about the Data tier
How to set Date data type into varible
Which Tier will LDAP fit in?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 08:48:41.