Re: Data Migration

Rob Kirkbride wrote:
> 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.

That seems like the easiest solution to me. You can do it completely
dynamically with no hard-wired table structure using the metadata.

Perhaps you could do it with the JDBC 4 RowSet API? I haven't looked at
it in detail.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com