  | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
  | | | Data sync | Data sync 2005-01-05 - By Kingshuk Choudhury
Back If you do not find any product which acheives this for you you can try this-
* Have database links from one db to another * write a simple data collector at both ends which are made as database jobs ( in oracle) These data collector routine can pick up changed data from one db and update the other db at periodic intervals * Fix the optimum period of running the data collector based on when ur data comes.
Regards, k.
Darshan wrote:
>Hi, > > Here is the problem description. We developed one web application which >is using Oracle database. This application is develoed using plain java >classes. There is one more legacy application running at client's place for >different purpose which is also using oracle database. As of the client's >requirements the common data in both the databases needs to be >synchronized.There is 20% of the data fields are common in both databases. >I have full rights to modify my application and database. >In brief the following tasks needs to be done. > >1. Whenever Legacy app's database changes , the changes need to be updated >in my application's database. >2. Whenever my app's database changes , the changes need to be updated in >Legacy app's database. > >Can any body give some idea how to achieve the above requirement. Any help >is much appreciated. > >Thanks >Darshan > >==================================================================== >Companion Site: http://www.corej2eepatterns.com >J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns >List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html >Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected) > >
==================================================================== Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|
 |