Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Replication and concurrency |
Tue, Sep 1 2009 3:07 AM | Permanent Link |
Tony Pomfrett | Will the bi-directional replication demonstrated in the technical article "Building a Sales Quote Replication System in ElevateDB" properly handle the case
where both Salesmen edit their copy of the same quote before replication can take place? By properly, I mean that the first salesman to replicate should succeed and the second should fail (otherwise he would be overwriting somebody else's changes). And is there a mechanism to advise a remote user that one of his updates could not be applied and cause his edit to be refreshed by the current master copy? |
Tue, Sep 1 2009 12:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tony,
<< Will the bi-directional replication demonstrated in the technical article "Building a Sales Quote Replication System in ElevateDB" properly handle the case where both Salesmen edit their copy of the same quote before replication can take place? >> The example segments quotes by sales person, so it punts on the issue of edits conflicting with one another. << By properly, I mean that the first salesman to replicate should succeed and the second should fail (otherwise he would be overwriting somebody else's changes). >> No, EDB does not handle this at the engine level. However, if you want this level of conflict resolution, you can do so by implementing a BEFORE UPDATE trigger on the table, and checking the LOADINGUPDATES() function in it, acting accordingly to check the NEWROW values against the OLDROW values, and issuing an exception if there is a conflict (RAISE). << And is there a mechanism to advise a remote user that one of his updates could not be applied and cause his edit to be refreshed by the current master copy? >> Again, this must be implemented by you as your needs dictate. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |