On Jan 24, 2006, at 17:53, jsalack..oczta.onet.pl wrote:
> I have to build a system which uses 2 databases. One is a central
> database for all user and second is database only for single user
> and it is local copy of central database. The local database is
> used when user doesnt have internet connection to central database.
> In other cases the central database is used. Each db has exacly the
> same table structure and it is the same RDMS.
I do not know of a solution, but Sequoia (formerly c-jdbc) comes to
mind. If some of the databases are off-line Sequoia caches all the
insert/update/delete statements and issue them when the database goes
on-line.
http://sequoia.continuent.org/
Sequoia is a special jdbc-driver that sits on top of a standard jdbc-
driver. Should work transparently with cayenne, but I have not tried.
- Tore.
This archive was generated by hypermail 2.0.0 : Tue Jan 24 2006 - 13:31:02 EST