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?