run.java

import java.sql.*;

public class Runner
{

	public static void main( String[] args )
	{
		System.out.println("hello");
		runProcedure();
	}

	private static void runProcedure()
	{
		Connection con = null;
        CallableStatement proc_stmt = null;
        ResultSet rs = null;

        try {

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            con = DriverManager.getConnection("jdbc:sqlserver://XXXXX", "XXX", "XXXX");

            proc_stmt = con.prepareCall("{ call CopyDB(?,?) }");
			//proc_stmt.setInt(1, 1);
			//proc_stmt.setInt(2, 2);
            proc_stmt.setString(1, "EMR");
			proc_stmt.setString(2, "EMR_test");
            proc_stmt.executeQuery();

        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (	SQLException ex) {
            ex.printStackTrace();
        } finally {

            try {

                //rs.close();
                proc_stmt.close();
                con.close();

            } catch (SQLException ex) {
                ex.printStackTrace();
            }

        }
	}

}