Example usage for org.hibernate.procedure ProcedureCall registerParameter

Introduction

In this page you can find the example usage for org.hibernate.procedure ProcedureCall registerParameter.

Prototype

<T> ParameterRegistration<T> registerParameter(String parameterName, Class<T> type, ParameterMode mode)
        throws NamedParametersNotSupportedException;

Source Link

Document

Basic form for registering a named parameter.

Usage

From source file:com.football.site.db.DbHelper.java

public static boolean DeleteLeagueFixtures(int leagueId) {
    boolean retVal = false;
    Transaction tran = null;//from   www .  ja v  a2s  .co m
    try {
        Session s = HibernateUtil.currentSession();
        tran = s.beginTransaction();
        ProcedureCall pc = s.createStoredProcedureCall("delete_league_fixtures");
        pc.registerParameter("p_league_id", Integer.class, ParameterMode.IN).bindValue(leagueId);
        ProcedureOutputs po = pc.getOutputs();
        tran.commit();
        retVal = true;
    } catch (Exception e) {
        if (tran != null) {
            tran.rollback();
        }
        HelperUtil.AddErrorLog(logger, e);
    } finally {
        HibernateUtil.closeSession();
    }
    return retVal;
}

---

From source file:com.football.site.db.DbHelper.java

public static boolean DeleteLeagueTables(int leagueId) {
    boolean retVal = false;
    Transaction tran = null;//  w  w w . j  a va  2 s .com
    try {
        Session s = HibernateUtil.currentSession();
        tran = s.beginTransaction();
        ProcedureCall pc = s.createStoredProcedureCall("delete_league_table");
        pc.registerParameter("p_league_id", Integer.class, ParameterMode.IN).bindValue(leagueId);
        ProcedureOutputs po = pc.getOutputs();
        tran.commit();
        retVal = true;
    } catch (Exception e) {
        if (tran != null) {
            tran.rollback();
        }
        HelperUtil.AddErrorLog(logger, e);
    } finally {
        HibernateUtil.closeSession();
    }
    return retVal;
}

---

From source file:com.football.site.db.DbHelper.java

public static boolean DeleteLeagueTeams(Integer leagueId) {
    boolean retVal = false;
    Transaction tran = null;/*from w  w w .ja va2 s  .  c  om*/
    try {
        Session s = HibernateUtil.currentSession();
        tran = s.beginTransaction();
        ProcedureCall pc = s.createStoredProcedureCall("delete_league_teams");
        pc.registerParameter("p_league_id", Integer.class, ParameterMode.IN).bindValue(leagueId);
        ProcedureOutputs po = pc.getOutputs();
        tran.commit();
        retVal = true;
    } catch (Exception e) {
        if (tran != null) {
            tran.rollback();
        }
        HelperUtil.AddErrorLog(logger, e);
    } finally {
        HibernateUtil.closeSession();
    }
    return retVal;
}

---

From source file:com.football.site.db.DbHelper.java

public static void InsertLeagueTeamsInsertInfo(Integer recordId, Integer year) {
    Transaction tran = null;//from   w  ww .ja  v a 2  s  .com
    try {
        Session s = HibernateUtil.currentSession();
        tran = s.beginTransaction();
        ProcedureCall pc = s.createStoredProcedureCall("delete_league_teams");
        pc.registerParameter("p_league_id", Integer.class, ParameterMode.IN).bindValue(recordId);
        pc.registerParameter("p_year", Integer.class, ParameterMode.IN).bindValue(year);
        ProcedureOutputs po = pc.getOutputs();
        tran.commit();
    } catch (Exception e) {
        if (tran != null) {
            tran.rollback();
        }
        HelperUtil.AddErrorLog(logger, e);
    } finally {
        HibernateUtil.closeSession();
    }
}

---

From source file:com.lzw.work.cms.manager.PreCarRegisterManager.java

public void getSeq() {
    final String sql = "EXEC Sequences  'ycscgs',''";
    Session session = null;//from ww  w  .j a  v a2 s.c om
    String code = "";
    try {
        session = this.getHibernateTemplate().getSessionFactory().openSession();
        ProcedureCall pc = session.createStoredProcedureCall("Sequences");
        pc.registerParameter("Table_Name", String.class, ParameterMode.IN).bindValue("ycscgs");
        pc.registerParameter("Seq_Type", String.class, ParameterMode.IN).bindValue("");
        pc.registerParameter("MaxId", String.class, ParameterMode.OUT);

        //         System.out.println(pc.getOutputs().getCurrent());
        code = (String) pc.getOutputs().getOutputParameterValue("MaxId");
        System.out.println(code);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (session != null) {
            session.clear();
            session.close();
        }
    }

    //      List<Object> list = this.getBaseList(sql, null, null);
    //      if(list==null||list.size()==0){
    //         return;
    //      }
    //      String code =(String) ((Map)list.get(0)).get("MaxDicId");
    code = code.trim();
    String prm = "??|";
    String path = System.getProperty("temp2code");
    create2Code(path, prm + code, code);
    Map map = new HashMap();
    map.put("data", code);
    map.put("state", "200");
    JSONObject jo = JSONObject.fromObject(map);
    pw.print(jo);
}

---