db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neal Dewing" <sy...@ecis.co.za>
Subject RE: Derby synchronization
Date Thu, 26 May 2005 07:59:59 GMT
Hi David,

The "remote application" uses an embedded derby database. All requests to
this database are passed through a servlet that executes DAO transactions,
for example remotemethod.execute("DAO", "insert", arg1, arg2);

In the same way, I require the synchronization mechanism to tunnel requests
through a servlet.

			|				|	
			|				|		
Synchronization	|  http server -->	|  Derby embedded database	
request --> 	|  				|
			|  			 	|		
			|				|		

Hope this provides some clarity on the matter.

Thanks,
Neal

-----Original Message-----
From: David Van Couvering [mailto:david@vancouvering.com] 
Sent: Wednesday, May 25, 2005 6:49 PM
To: Derby Discussion
Subject: Re: Derby synchronization

Could you explain more what you mean by "synchronizing through a 
servlet?"  Do you mean some type of database synchronization to keep two 
independent databases in synch?

Thanks,

David

Neal Dewing wrote:

> Hi All,
> 
> I require the synchronization of two embedded derby databases.
> 
> The environment is as follows:
> 
> 1. CLIENT APPLICATION:
> 
> Swing based application
> The database is accessed through Data access objects (such as SQL2Java's
> generated DAO's)
> 
> 2. REMOTE APPLICATION:
> 
> Web based application
> The database is accessed through a servlet responsible for executing the
> DAO's.
> 
> I have found a commercial option (Daffodil Replicator), but it does not
> currently offer a mechanism for synchronizing through a servlet (although
> this might be a reasonable specific requirement).
> 
> 1. Does anyone know of a mechanism to do this?
> 2. Would this provide for foreign key integrity?
> 
> Any help would be greatly appreciated!
> 
> Kind Regards,
> Neal
> 
> 


Mime
View raw message