Skip to main content

Compare two resultsets and find the difference in java

Please note these forums are being decommissioned and use the new and improved forums at
No replies
Joined: 2012-11-26
Points: 0

I have 2 databases one is oracle and other one is SAP HANA.
I successfully connected to both the databases.

I want to compare the table data residing in these databases.

I querried table A from oracle lets say in resultset rs1 and
querried table B from SAP HANA,say rs2.

Now i want to compare these resultsets,whether they are equal or not,if not then which rows are different.

I tried with arraylist comparision,but as the no of rows is quite large(12,00,000) for some tables,its geting stucked.
Pls suggest an alternative approach or is any utility is available for this??