import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Zad6 {

   public static void main(String argv[]) {

      Connection connection = otvoriKonekciju();

      try {
         Statement stmt = connection.createStatement();
         stmt.executeUpdate("EXECUTE PROCEDURE rasporediPoGrupama()");
         System.out.println("Procedura je izvršena.");
         connection.close();
      }
      catch (SQLException exception) {
         System.out.println(exception.getErrorCode() + " " + exception.getMessage());
      }
   }

   private static Connection otvoriKonekciju () {
      Connection conn = null;
      String url = "jdbc:informix-sqli://sbp.edu:1526/sbpdz2"
            + ":INFORMIXSERVER=sbp;DB_LOCALE=hr_hr.utf8;CLIENT_LOCALE=hr_hr.utf8;"
            + "user=horvat;password=horvat";

      try {
         Class.forName("com.informix.jdbc.IfxDriver");
         System.out.println("Informix JDBC driver je uèitan i registriran.");
      } catch (ClassNotFoundException exception) {
         System.out.println("Pogreška: nije uspjelo uèitavanje Informix JDBC driver-a.");
         System.out.println(exception.getMessage());
         System.exit(-1);
      }

      try {
         conn = DriverManager.getConnection(url);
         System.out.println("Konekcija je uspostavljena.");
      } catch (SQLException exception) {
         System.out.println("Pogreška: nije uspjelo uspostavljanje konekcije.");
         System.out.println(exception.getErrorCode() + " " + exception.getMessage());
         System.exit(-1);
      }
      return conn;
   }
}