This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Compare the resultsets...

Posted by Bobby S. on July 29, 2001 at 6:26 AM

If you haven't already figured it out, I can help you. A simple way of doing this would be to fetch the resultsets for the two tables, store them in a value object, and then store the value object in a data structure for the respective tables, use the primary key as a search key(depends on your specs) to parse through the resultset stored in the data structure and then insert a row into the respective table based on whether the search key was found or not.

Let me know if you want the code.
-bs-