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?
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.
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.
Betty Rubble? Well, I would go with Betty... but I'd be thinking of Wilma.
sunglasses are a type of coolness prosthetic. Check out the sunglasses on this tiny ad: