• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Newbie: need help comparing two tables from different databases.

 
Dmitry Zhuravlev
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Java-People!

I need advice concerning the following. I have a view in Lotus Domino database and a table in Oracle database, and I need to compare them for consistency. I plan to run through the all documents (i.e. entries) in Domino view and check whether I can find a corresponding entry in Oracle. But the size of the tables is huge, so I dont want to run JDBC calls to Oracle table for each of the dozens of thousands entries in Domino table! I can get a ResultSet from Oracle, but I have not found a search methods in that class. So, can you advice what is the best way to perform this task? Can I make a search through the ResultSet object somehow?
 
Terry Weymouth
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm working through a similar problem and the approach that I am investigating assumes that both results can be sorted and that the table contents are exactly the same. In that case one need only walk the two result sets in order until a mismatch occurs. But even when there is mismatch, if you wanted to count the number of mismatches for example, sorted ordering implies that you would know which side had the mismatch and (therefore) which side to skip forward on. Are there unique keys that you can sort on that are the same on both sides? (Sorry, I don't remember that much about the DB-like aspects of the Lotus document database).
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DbTamer in my signature is designed to do some of that
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic