 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / November 2004Data Synchronization
I have to write something in java to synchronize certain fields in one data source into another data source. my question is, does anyone know of any web-link that discusses common problems with doing this kind of operation? i searched on "2 way data synchronization white paper" and did not come up with anything useful. thanks. > I have to write something in java to synchronize certain fields in one > data source into another data source. [quoted text clipped - 4 lines] > i searched on "2 way data synchronization white paper" and did not > come up with anything useful. thanks. Is one a copy of the other, or are both being changed independently? It is probably less efficient to do with a third component (a jdbc program), than it would be to implement via DBMS procedures or triggers. However, the simple picture is that an independent java program would have to periodically monitor the changing data, and whenever one changed, propagate the change to the other. What do you mean 'datasource'? Are these two independent DBMSes, or something else? Joe Weinstein at BEA > I have to write something in java to synchronize certain fields in one > data source into another data source. [quoted text clipped - 4 lines] > i searched on "2 way data synchronization white paper" and did not > come up with anything useful. thanks. Its a database issue, not java. Most DBMSs support database replication. You could even use rsync. gtoomey > I have to write something in java to synchronize certain fields in one > data source into another data source. [quoted text clipped - 4 lines] > i searched on "2 way data synchronization white paper" and did not > come up with anything useful. thanks. Look following link, it might help you. http://dataset.sohlman.com/SynchronizationTutorial.html If you are intrested you can mail me. - Sampsa  Signature------------------------------------------- // Sampsa Sohlman // // My email can be found on my homepage // // http://sampsa.sohlman.com // ------------------------------------------- > > I have to write something in java to synchronize certain fields in one > > data source into another data source. [quoted text clipped - 12 lines] > > - Sampsa I say datasource rather than database or LDAP repository because I mean that the source of data could be in any storage mechanism. The data that needs to be synchronized is from 2 different sources of data, that hold some data in like: a name, phone number, address, etc, but each individual datasource may also hold other kinds of data not pertinent to the other datasource. So I am really synchronizing certain fields from each datasource with fields from another. Initially the "synch" would be uni-directional. One being deemed the official authority of what the data should look like. Of cource over time that will not be the case, but in this stage of our project, this is the case. So, one "datasource" could be Sybase and the other LDAP, or vice-cersa. > I say datasource rather than database or LDAP repository because I > mean that the source of data could be in any storage mechanism. The [quoted text clipped - 11 lines] > So, one "datasource" could be Sybase and the other LDAP, or > vice-cersa. It is possible to extend DataSet functionality to read and write to/from LDAP. If you do this way and use samekind of design as in tutorial, then all data is compared in memory. I have made datatransfers with dataset with more than 150 000 rows. Good thing with DataSet is that it only writes changes back to datasource (if the WriteEngine has been designed that way). To that it is necesary to extend com.sohlman.dataset.ReadEngine to create LDAPReadEngine com.sohlman.WriteEngine and then extend com.sohlman.dataset.WriteEngine to create LDAPWriteEngine Problem is that these are not ready. Even though rightnow I'm also working with LDAP :) and my current project might be handy. - Sampsa Signature------------------------------------------- // Sampsa Sohlman // // My email can be found on my homepage // // http://sampsa.sohlman.com // ------------------------------------------- Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.