axis-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roger Menday <r.men...@kfa-juelich.de>
Subject RE: Data Transfer with XML between two DB's- a Real world Case
Date Wed, 05 Feb 2003 13:19:43 GMT

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:ranjith@dmsswt.com]
> >   Sent: Wednesday, February 05, 2003 12:02 AM
> >   To: axis-user@xml.apache.org
> >   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
> > 
> >   ranjith@dmsswt.com
> > 
> -- 
> 
> Dr Roger Menday
> Zentralinstitut für Angewandte Mathematik (ZAM)
> Forschungszentrum Jülich GmbH
> D-52425 Jülich
> Germany 
> 
> t +49 2461 614340
> e r.menday@fz-juelich.de
> 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 r.menday@fz-juelich.de
w http://www.fz-juelich.de/zam/ZAMPeople/menday.html


Mime
View raw message