Jdbc + postgresql(dw) + inserÇÃo automatizada

package bd;

import java.sql.*;

import java.sql.SQLException.*;

public class oraclejdbc{

    public oraclejdbc() {

    }

    Connection conn;
    Statement stmt;
    ResultSetMetaData rsmd;
    int numberOfColumns;

    public void initializeOracleConn(String pHost, String pPort, String pSid,
                      String pLogin, String pPassword, String pComment) throws Exception{

        // Don't forget to add Oracle JDBC Library

        //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

        String jdbcdriver;
        String host;
        String port;
        String sid;
        String login;
        String password;
        String comment;

        /** Sample Values
        jdbcdriver = "jdbc:oracle:thin";
        host = "demo.domain.com";
        port = "1525";
        sid = "DEMO";
        login = "demo";
        password = "demo";
        */

        jdbcdriver = "jdbc:postgresql";
        host = pHost;
        port = pPort;
        sid = pSid;
        login = pLogin;
        password = pPassword;
        comment = pComment;
        
        conn = DriverManager.getConnection(jdbcdriver + "://" + host + ":" + port + ":" + sid,login,password);
        conn.setAutoCommit (false);

        System.out.println("Connected to " + sid + " (" + comment + ")");

    }

    public int executeQuery(String Query) throws Exception {

        stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery(Query);
        rsmd = rset.getMetaData();
        numberOfColumns = rsmd.getColumnCount();

        System.out.println(numberOfColumns + " columns.");
        System.out.print("LINE N°" + ";");

        for(int i=1; i < numberOfColumns; i++){
            
            System.out.print(rsmd.getColumnName(i) + ";");

        }

        System.out.println(rsmd.getColumnName(numberOfColumns));

        int count = 0;
        while (rset.next()) {

            count++;
            System.out.print(count);
            System.out.print(";");
            for(int i=1; i < numberOfColumns; i++){

                System.out.print(rset.getString(i));
                System.out.print(";");

            }

            System.out.println(rset.getString(numberOfColumns));

        }

        System.out.println(count + " records.");

        return count;

    }

    public static void main(String[] args) {

        oraclejdbc oraclejdbc = new oraclejdbc();

        String host;
        String port;
        String login;
        String password;
        String comment;
        String sid;

        // To customize
        sid = "dw";
        host = "localhost";
        port = "5432";
        login = "postgres";
        password = "654321";
        

        comment = "Datawarehouse";
        try{

            oraclejdbc.initializeOracleConn(host, port, sid, login, password, comment);
            String Query = "select * from PROVA";
            int numRecords = oraclejdbc.executeQuery(Query);

        }catch (Exception e){
            e.printStackTrace();
        }


    }

}