Hi, i'm new to jdbc. Is there any possibility to insert ResultSet objects into table? Suppose i have to migrate data from oracle to postgre. Look the following code:
Connection con_ora = Oracle.getOracleConnection();
Connection con_postgre = Postgre.getPostgreConnection();
Statement stmt = con_ora.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM test");
while(rs.next()) {
postgre_stmt.executeUpdate("INSERT INTO test values " + rs );
rs here is an object and cannot be inserted this way. Assuming that table structure is identical in oracle in postgre is it possible to insert resultset object this way? Remember that I dont know and dont want to know the column datatypes (if they are not identical there should be error). Or is there better way to copy data between oracle and postgre