  | 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 Darshan
Back Hi,
Thanks for your response. I need to do the data sync in realtime, i mean whenever an crud operation performs on one DB should immediately update the other database(just like a trigger). As per your reply i understood that the routines do this process at specified intervals.
As bayar suggested ,If i write triggers for crud operations on the two databases, It may lead to infinite loop (not sure), because the insert trigger on database-1 (See http://ase-1.ora-code.com) will try to insert into database-2 (See http://ase-2.ora-code.com). At the same time the insert trigger on database-2 (See http://ase-2.ora-code.com) will try to insert the same record in database-1 (See http://ase-1.ora-code.com) ......
BTW i have not wotked on the routines. Can you give some useful links on how to write data collector routines.
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)
|
|
 |