2008/04/21

JAVA CALL ORACLE PROCEDURE and FUNCTION

 /**
  * スドアドを呼び出す。。
  *
  * @return XXXX
  */
 public int callMailProcedure() {
  HibernateTemplate hibernateTemplate = new HibernateTemplate(super
    .getSessionFactory());
  hibernateTemplate.execute(new HibernateCallback() {
   @SuppressWarnings("deprecation")
   public Object doInHibernate( Session session ) throws SQLException {
    CallableStatement cs = session.connection().prepareCall(
    // CallableStatement cs = session.connection().prepareCall("{? = call SP_test(?,?,?,?,?)}");
    cs.registerOutParameter(1, Types.NUMERIC);
    cs.setString(2, "1");
    cs.setString(3, "2");
    cs.setString(4, "3");
    cs.setString(5, "4");
    cs.setString(6, "5");
    //cs.executeUpdate();
    cs.execute();
    return 1;
   }
  });
  return 0;
 }

No comments: