Data sync

Google

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

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Subject: Servlet : Session invalidate
•	Oracle Connection Pooling in 3 2 2
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Subject: Running a Simple JMS Example
•	Tomcat and webapplication specific java library path
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	Value attribute of <html:checkbox
•	url string for connecting jboss to oracle
•	javax servlet ServletException: BeanUtils populate
•	5 0 18: Windows XP Pro vs Windows 2000
•	HTTP Status 404 The requested resource is not available

Data sync

Data sync

2005-01-06 - By Darshan

Back

Reply: 1 2 3 4 5 6 7 8 9

Hi Aaron,

Thanks for the reply. The solution on the application layer will solve
only the problem in oneway. I mean that, when myApplication changing the
data i can update both mydatabase and legacy app's database. But i can't do
the reverse way because the other one is legacy application, and we don't
have the source.

Thanks
Darshan

On Wed, 5 Jan 2005 14:29:23 +0200, Tubman Aharon
<Aharon.Tuvman@(protected)> wrote:

>I think that you can give the solution on the application layer.
Means that business layer uses generic interface of the persistency
layer while Persistency layer updates both databases local and legacy
(using Adaptor pattern) within the same transaction (important!). In
this way the business layer is loosely coupled within the persistency
layer. Persistency layer manages the db consistency using transaction or
other (proprietary) mechanism.

See "Domain Store" J2EE design pattern and Adapter Design pattern.
Aaron

-- --Original Message-- --
From: An interest list for Sun Java Center J2EE Pattern Catalog
[mailto:J2EEPATTERNS-INTEREST@(protected)] On Behalf Of Darshan
Sent: Wednesday, January 05, 2005 11:23 AM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: Data sync

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)

???????????????? ???? ?????????? ?????????????? ???????? ????????????? ??
??? ?? ???????????? ???????????? ???????? ???????? ???????????? ????????
?????? ?????????? ???????????? ??/???? ???????????? ?????????? ??/????
???????????? ???????????? ??/???? ?????? ???????? ?????? ????????
?????????? ????? ???? ???????????? ??? ???????? ??????????

Correspondence with Leumi by electronic mail is for general purposes only
and may not be relied upon for the purpose of effecting any activities
and/or transactions whatsoever and/or as a substitute for advice and/or in
any other manner and is subject to the conditions of use which have been
provided to the Customer

>
>===================================================================>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)