Is there a way in JDBC to move data from one database to another without having to hard-wire the table structure?
I was wondering if I can do a kind of
ResultSet rs = executeStatement("select * from table (from connection 1) where somecondition") while (rs.next()) take the resultset and then pass directly into a prepared statement for an "insert into table" (from connection 2)
I can't see any way other disecting the values from the first query and using getSQLType.