re: my last posting ... somewhat off topic ....
i pressed the wrong buttons. sorry. On Wed, 2003-02-05 at 14:15, Roger Menday wrote: > > > > 66 pounds return london stanstead <-> cologne ... > > manchester or liverpool is gonna be difficult to get cheap flights for. > there's not much time either - i.e. fares go up. > > after march 30th ... www.hlx.com (cheap german airline) will fly from > manchester to cologne. > > On Wed, 2003-02-05 at 14:12, Anne Thomas Manes wrote: > > What are the reasons why that database links don't work? What is the volume > > of data that needs to be transferred? My initial reaction to this scenario > > is to use database synchronization technology. I probably wouldn't consider > > using XML or Web services. > > > > Anne > > -----Original Message----- > > From: Ranjith Kodikara [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, February 05, 2003 12:02 AM > > To: [EMAIL PROTECTED] > > Subject: Data Transfer with XML between two DB's- a Real world Case > > > > > > My customer has a requirement like this. There are several locations of > > that organization (my customer). They have an Oracle database in each of > > their locations. There is a central server. When daily transactions are > > processing, they update their location databases and at the end of the day, > > they have to transfer those data to the central server. Currently we are > > doing this with Oracle database links and due to so many reasons this is not > > 100% successful. Communication is through internet dialup connections (we > > can�t tell them to upgrade those lines) > > > > We are hoping to go for XML technologies in order to do this data > > transfer. I have knowledge on XML technologies, but not practical > > experience. But in this case there is no one in the central server to do any > > thing. People in locations should be able to transfer data of that > > particular day to the central server at the end of the day. > > > > > > There are 15 locations plus a central server. When location A finishes its > > works, it sends its data to the central location. (When it sends those data, > > it (A) updates a flag in the database records. It can identify unsent > > records by those flag.) > > > > Then the Oracle database in the central server should be updated with > > location A�s records. > > > > > > > > At that time the database in the central server would have been updated > > with other locations data (for an example, location B�s data). Then at the > > same time those data should go to location A and location A�s database > > should be updated with those location B�s data that the central server > > already have. > > > > > > My question is how can I do this? What s the best technology to use? (Web > > Services etc.) Can you recommend a book or some of web resources? > > > > > > > > There is no one in the central server to do this. I hope the location user > > to do this. > > > > > > > > Still I am wondering which technology to use. I already experienced in > > JSP, Java and Servlets. I have done some works with Xerces, Xalan and > > WebServices. > > > > > > > > If I am going to use Axis for this, > > > > an I do this with Axis ? > > > > Is it reliable Axis to do this? (Because this is a critical real world > > application) > > > > I appreciate if some of you give me some guidance here. > > > > > > > > I would greatly appreciate your response. > > > > > > > > Thanks and best regards, > > > > Ranjith Kodikara > > > > [EMAIL PROTECTED] > > > -- > > Dr Roger Menday > Zentralinstitut f�r Angewandte Mathematik (ZAM) > Forschungszentrum J�lich GmbH > D-52425 J�lich > Germany > > t +49 2461 614340 > e [EMAIL PROTECTED] > w http://www.fz-juelich.de/zam/ZAMPeople/menday.html > -- Dr Roger Menday Zentralinstitut f�r Angewandte Mathematik (ZAM) Forschungszentrum J�lich GmbH D-52425 J�lich Germany t +49 2461 614340 e [EMAIL PROTECTED] w http://www.fz-juelich.de/zam/ZAMPeople/menday.html
