Hi,

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.

Any ideas?

Thanks

Rob