D-Net

    public void insertCountries() throws Exception {

        startTime = System.currentTimeMillis();

        log.info("Inserting countries...");

        Connection con = statsDatasource.getConnection();

        startTime = System.currentTimeMillis();

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

        CallableStatement st = con.prepareCall(q);

        st.execute();

        st.close();

        con.close();

        log.info("Done.");

        endtime = System.currentTimeMillis();

        log.info("Time  for inserting countries: " + ((endtime - startTime) / 60000) + " minutes ");

    }

    public void backwardsCompatibility() throws Exception {

        startTime = System.currentTimeMillis();

        log.info("Ensuring backwards compatibility");

        Connection con = statsDatasource.getConnection();

        startTime = System.currentTimeMillis();

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

        CallableStatement st = con.prepareCall(q);

        st.execute();

        st.close();

        con.close();

        log.info("Done.");

        endtime = System.currentTimeMillis();

        log.info("Time  for ensuring backwards compatibility: " + ((endtime - startTime) / 60000) + " minutes ");

    }