D-Net

    public void fix_integer_ids() throws Exception {

        log.info("fixing integer ids...");

        Connection con = statsDatasource.getConnection();

        startTime = System.currentTimeMillis();

        String q = "{call shadow.fix_result_ids()}";

        CallableStatement st = con.prepareCall(q);

        st.execute();

        st.close();

        con.close();

        endtime = System.currentTimeMillis();

        log.info("Time to fix integer ids: " + ((endtime - startTime) / 60000) + " minutes ");

    }