I'm contemplating a producer-consumer application to move data from one DBMS to another. I want to run a query on the producer DB and use the results to build and execute an insert on the consumer DB.
I would like the producer
thread to enqueue each 'row' of the result set. The consumer thread will remove 'rows' and use them to run inserts.
Looking at the ResultSet JavaDoc I don't see a method for getting a 'row' or the object that corresponds to a row.
Is this possible?
-=beeky