Here is the scenario. 2 web servers in two separate locations having two mysql databases with identical tables. The data within the tables is also expected to be identical in real time. Here is the problem. if a user in either location simultaneously enters a new record into identical tables, as illustrated in the two first tables belo...
I have a fairly simple sync problem. I have a table with about 10 columns that I want to keep in sync between a sqlite file on 3 different clients: an Iphone client, a browser client, and a Ruby on Rails client. So I need a simple sycing solution that will work for all 3, i.e. I can easily implement it in Javascript, Objective C, and R...
Hi I am developing an Adobe AIR application which stores data locally using a SQLite database. At any time, I want the end user to synchronize his/her local data to a central MySQL database. Any tips, advice for getting this right? Performance and stability is the key (besides security ;)) ...
Checkstyle reports this code as "The double-checked locking idiom is broken", but I don't think that my code actually is affected by the problems with double-checked locking. The code is supposed to create a row in a database if a row with that id doesn't exist. It runs in a multi-threaded environment and I want to avoid the primary-key...
exampl: new Thread(new Runnable() { public void run() { while(condition) { *code that must not be interrupted* *some more code* } } }).start(); SomeOtherThread.start(); YetAntherThread.start(); How can you ensure that code that must not be interrupted won't be interrupted? ...
I have the following problem: Multithreaded WPF application, Model View Presenter Implementation. Presenters and Views that belong together are created on a separate thread and get a separate Dispatcher. Now someone calls from another thread a method on the Presenter. I am intercepting the call, and now begins the problem: if the call co...
Here's some code I saw once. Can you see what's wrong with it? [updated] public class ResourceManager1 { private final String mutex = ""; Object resource = null; public Object getResource() { synchronized (mutex) { if (resource == null) { resource = new Object(); } } return...
Do you know any (open source) Java library that provides file synchronization/backup functionality? Many thanks. ...
I'm currently estimating how to best share data between offices at different geographical locations. My current preference is for using SQL Server Merge Replication and have a main database and handful of subscribers. The system will also need to allow a few work sites to work disconnected (no or little connectivity on construction site...
Monitor.Pulse/All and Monitor.Wait are useful methods, but I'm getting complaints that when using them in large quantities (I have a DSL designer that spits them out by the dozen), the resulting code becomes unreadable. What do you think? ...
Hi, does anybody know some free tool for synchronization MySQL database (data and structure) like in Navicat for Windows ? ...
I have let's say 2 (but they'll become more in the future) fully decoupled systems: system A and system B. Let's say every piece of information on each system has an informationID. There's nothing stopping the informationID to be the same on different systems. What univocally identifies a piece of information across all systems is a Sou...
I have an application that uses a cron like job to update a set of data. The update process happens once a minute and doesn't last long. A servlet exposes this data set to the users. My problem is that during the update process, the servlet requests should block and wait for the process to complete. In bottom line I have these two func...
Are you using it or plan to use it? ...
Does anyone know the query the last synchronization date from sql server (2008). It is the same information displayed in replication monitor, but I want to be able to get that date from a query. ...
Hi, for writing an offline client to the Google Reader service I would like to know how to best sync with the service. There doesn't seem to be official documentation yet and the best source I found so far is this: http://code.google.com/p/pyrfeed/wiki/GoogleReaderAPI Now consider this: With the information from above I can download ...
I'm looking into writing a simple synchronization ability into my app and one of the concerns that has popped up is synchronization of time between two remote computers, each with their own clock (in particular concerning the modification dates of files/objects). I'm sure a lot of research has been done on this topic and don't want to g...
the scenario: Two databases(each has a database named, for example testdb): MS Sql Server 2000 Postgresql 8.3 I need to synchronize these two testdbs, actually the direction is from SqlServer to Postgresql. The structure of testdb on SqlServer may change occasionally. I only need tables and data of testdb synchronized, exclude ind...
Hi All, I am planning to use the following architecture for one of the applications: Client: Java based application, which will use a MySQL database Server: Will be C# based and the database will be SQL Server Now is it possible to use Microsoft Sync Framework in Java? (Probably by implementing some interfaces?). I want the data from J...
Hi All, I have a few questions about data synchronization. The architecture does not seem to be clear about this: Does Google Gears provide from automatic synchronization of data (from client to server and server to client)? If it does provide for automatic data synchronization, then can i write functions to hook into the sync mechani...