Since I don't really care about the content of the row I am copying, I don't want to compose the INSERT INTO sql. Just have the source ResultSet and destination ResultSet and take the value from the src and set them into the destination and just insert. I am dealing with two database servers. And I need to modify a few of the column before inserting into the second server. So I don't think SELECT INTO can work.
So what is the simlest way using
JDBC to copy rows from one db server to another, adjusting a few columns in the process, both servers have the same database schema?