• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Newbie: need help comparing two tables from different databases.

 
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
DbTamer in my signature is designed to do some of that
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic