Compare two resultsets and find the difference in java
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??