need java logic

I am trying to retreive data from sql db tables, and insert into oracale db table.before inserting into oracle table i have to check the modified date column in oracle. if sql table is having updated data i have to insert.

I am using jdbc api. I got connected to both databases and retreived data from databases. the code i wrote is below, but am stucked at comparing the data and inserting into oracle. please help me.......

Please be more specific in what you're stuck at. It sounds like since you're able to read all the data, that this might not even be a JDBC issue. Comparing objects is more of a java issue than anything else, but I'll leave this in the JDBC forum for now. Please clarify exactly what the problem is.

Resultsets is really just a fancy list of HashMaps, read one HashMap at a time.

If you can read the data, this really isn't a JDBC issue so I'm going to move this Java Intermediate and hopefully someone can help you 'compare objects' as you want to do. [ August 21, 2008: Message edited by: Scott Selikoff ]