Hibernate problem with bulk inserts

[Ahsan Bagwan]

I'm trying to insert new rows in one table, and update rows in other table as well. While updating works fine in one table, its the insert in that table that is problematic. Hall_calendar, which has composite keys, is where I want the update to take place as well as insert new value. Hall_block_calendar is where form values are persisted when after updating other table, which is working fine on session.save(hbc) .

I've commented the part in the dao which is working wrong. I'm stuck and would be grateful for any help with the code. Apologies for the bad code practice.

This is my DAO method. The for's else if statement is where I try batch update.

public boolean addHallCalendarBlock(Hall_block_calendar hbc, Hall_calendar hc,Hallbookingcompid hid)
    {
    Session session=HibernateUtil.getSessionFactory().openSession();   
    Transaction tx=null;

    {
       tx=session.beginTransaction();
       SimpleDateFormat prs= new SimpleDateFormat("yyyy-MM-dd");
       Date start_date=prs.parse(hbc.getHall_block_from_date());
       System.out.println("Start date in dao: "+start_date);
       Date end_date=prs.parse(hbc.getHall_block_to_date());

       Calendar start = Calendar.getInstance();
       start.setTime(start_date);
       System.out.println("getTime dao: "+start.getTime());
       Calendar end = Calendar.getInstance();
       end.setTime(end_date);
       System.out.println("getTime dao: "+end.getTime());

       for(; !start.after(end); start.add(Calendar.DATE, 1))
       {
           Date current = start.getTime();

           SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd");
           System.out.println("formatted date in dao "+fmt.format(current.getTime()));

           Query q=session.createQuery("from Hall_calendar h where h.hallbookingcompid.calendar_date='"+fmt.format(current.getTime())+"'");

           List<Hall_calendar> mylist =(List<Hall_calendar>) q.list();

           if(!mylist.isEmpty())
           {      
             //System.out.println("enters if"); 
             for(Hall_calendar obj: mylist)
             {
               if(obj.getHall_availability().equals("F") || obj.getHall_availability().equals("M") || obj.getHall_availability().equals("E"))
               {
                   Hall_calendar new_obj = (Hall_calendar)session.load(Hall_calendar.class, obj.getHallbookingcompid());
                   new_obj.setHall_availability("N");
                   session.update(new_obj);

               }
             }
             continue; 
           }
           else if(mylist.isEmpty())     //doesnt work as expected
           {      
               //System.out.println("enters elseif");
               Hall_calendar hc_new = new Hall_calendar();
               hid.setHall_id(hid.getHall_id());
               hid.setCalendar_date(fmt.format(current.getTime()));

               hc.setHallbookingcompid(hid);
               hc.setHall_availability("N");
               //session.per(hc);      
           }

       }


       session.save(hbc);  
       tx.commit();

    }     

    catch(Exception e)
    {
        tx.rollback();
        e.printStackTrace();
        return false;
    }
    finally
    {
        session.close();
    }
    return true;
   }


    }    //end of dao class

This is my servlet class

    package com.cmc.sibs.servlets;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.cmc.sibs.delegates.SibsDelegate;
import com.cmc.sibs.vo.Hall_block_calendar;
import com.cmc.sibs.vo.Hall_calendar;
import com.cmc.sibs.vo.Hallbookingcompid;
import com.cmc.sibs.vo.M_hall;
import com.cmc.sibs.vo.M_users;

public class AddHallBlocking extends HttpServlet {


    public AddHallBlocking() {
        super();
    }


    public void destroy() {
        super.destroy(); 

    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        doPost(request, response);

    }


    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        SibsDelegate sibsdelegate= new SibsDelegate();

        Hall_block_calendar hbc= new Hall_block_calendar();

        M_hall hall = new M_hall();
        M_users user = new M_users();
        Hall_calendar hc = new Hall_calendar();
        Hallbookingcompid hid=new Hallbookingcompid();
        user.setUser_id("1");

        System.out.println("hallcode in servlet from form(should be 1) :"+request.getParameter("corpus_fund"));

        hid.setHall_id(request.getParameter("corpus_fund"));
        hall.setHall_code(request.getParameter("corpus_fund"));
        String date_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
        System.out.println("Updated date time formatted in post servlet: "+date_time);

        try
        {

           String block_from_date=request.getParameter("from_date");
           String fmt_from_date=new SimpleDateFormat("yyyy-MM-dd").format(new SimpleDateFormat("dd-MM-yyyy").parse(block_from_date));
           System.out.println("fmt_from_date in servlet: "+fmt_from_date);

           String block_to_date=request.getParameter("to_date");
           String fmt_to_date=new SimpleDateFormat("yyyy-MM-dd").format(new SimpleDateFormat("dd-MM-yyyy").parse(block_to_date));
           System.out.println("fmt_to_date in servlet: "+fmt_to_date);

           hc.setHallbookingcompid(hid);    
           hbc.setHall_code(hall);
           hbc.setHall_block_from_date(fmt_from_date);
           hbc.setHall_block_to_date(fmt_to_date);
           hbc.setBlocked_narrative(request.getParameter("reason"));
           hbc.setUpdated_by(user);
           hbc.setUpdated_date_time(date_time);

           HttpSession session = request.getSession();
           RequestDispatcher rd=null;
           Boolean b=Boolean.valueOf(sibsdelegate.addHallCalendarBlock(hbc,hc,hid));

           System.out.println("boolean in servlet: "+b);

           if(b.booleanValue())
           {

               rd = request.getRequestDispatcher("HallBlockSuccess.jsp");
               rd.forward(request, response);
           }
           else
           {
//            session.setAttribute("block_from_date", block_from_date);
              //session.setAttribute("block_to_date", block_to_date);
              //session.setAttribute("corpus_fund", request.getParameter("corpus_fund"));
              //session.setAttribute("reason", request.getParameter("reason"));
              request.setAttribute("msg", "Could Not Block Hall!");
              rd = request.getRequestDispatcher("HallBlockingTransaction.jsp");
              rd.forward(request, response);
           }


        }
        catch (ParseException e) 
        {
            e.printStackTrace();
        } 

    }


    public void init() throws ServletException {

    }

}

Mapping file for updating table

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="com.cmc.sibs.vo.Hall_calendar" table="hall_calendar">
<composite-id name="hallbookingcompid">
  <key-property name="hall_id"  column="hall_id"/> 
  <key-property name="calendar_date"  column="calendar_date"/>
</composite-id> 

  <property name="hall_availability" >
     <column name="hall_availability" />
  </property>   


 </class>
</hibernate-mapping>

Mapping to persist form values

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="com.cmc.sibs.vo.Hall_block_calendar" table="hall_block_calendar">
   <id name="hall_block_id" column="hall_block_id">
    <generator class="native"></generator>    
   </id>

  <many-to-one name="hall_code" class="com.cmc.sibs.vo.M_hall" column="hall_code" cascade="none" >
</many-to-one>

  <property name="hall_block_from_date" >
     <column name="hall_block_from_date" />
  </property>   

  <property name="hall_block_to_date" >
     <column name="hall_block_to_date" />
  </property>  

  <property name="blocked_narrative" >
     <column name="blocked_narrative" />
  </property>  

  <many-to-one name="updated_by" class="com.cmc.sibs.vo.M_users" column="updated_by" cascade="none" >
  </many-to-one>

  <property name="updated_date_time" >
     <column name="updated_date_time" />
  </property>   


 </class>
</hibernate-mapping>

VO for hall_calendar and hall_block calendar,

package com.cmc.sibs.vo;

public class Hall_calendar {

    Hallbookingcompid hallbookingcompid;
    String hall_availability;

    public String getHall_availability() {
        return hall_availability;
    }
    public void setHall_availability(String hall_availability) {
        this.hall_availability = hall_availability;
    }
    public Hallbookingcompid getHallbookingcompid() {
        return hallbookingcompid;
    }
    public void setHallbookingcompid(Hallbookingcompid hallbookingcompid) {
        this.hallbookingcompid = hallbookingcompid;
    }
}

/////

package com.cmc.sibs.vo;

public class Hall_block_calendar {

    String hall_block_id;
    M_hall hall_code;
    String hall_block_from_date;
    String hall_block_to_date;
    String blocked_narrative;
    M_users updated_by;
    String updated_date_time;

    public String getBlocked_narrative() {
        return blocked_narrative;
    }
    public void setBlocked_narrative(String blocked_narrative) {
        this.blocked_narrative = blocked_narrative;
    }
    public String getHall_block_from_date() {
        return hall_block_from_date;
    }
    public void setHall_block_from_date(String hall_block_from_date) {
        this.hall_block_from_date = hall_block_from_date;
    }
    public String getHall_block_id() {
        return hall_block_id;
    }
    public void setHall_block_id(String hall_block_id) {
        this.hall_block_id = hall_block_id;
    }
    public String getHall_block_to_date() {
        return hall_block_to_date;
    }
    public void setHall_block_to_date(String hall_block_to_date) {
        this.hall_block_to_date = hall_block_to_date;
    }
    public M_hall getHall_code() {
        return hall_code;
    }
    public void setHall_code(M_hall hall_code) {
        this.hall_code = hall_code;
    }
    public M_users getUpdated_by() {
        return updated_by;
    }
    public void setUpdated_by(M_users updated_by) {
        this.updated_by = updated_by;
    }
    public String getUpdated_date_time() {
        return updated_date_time;
    }
    public void setUpdated_date_time(String updated_date_time) {
        this.updated_date_time = updated_date_time;
    }


}

VO for composite fields,

package com.cmc.sibs.vo;
import java.io.Serializable;
public class Hallbookingcompid  implements Serializable {

    String hall_id;
    String calendar_date;

    public Hallbookingcompid(){

}
//   an easy initializing constructor
    public Hallbookingcompid(String hall_id, String calendar_date){
    this.hall_id = hall_id;
    this.calendar_date = calendar_date;
    }
    public String getCalendar_date() {
        return calendar_date;
    }
    public void setCalendar_date(String calendar_date) {
        this.calendar_date = calendar_date;
    }
    public String getHall_id() {
        return hall_id;
    }
    public void setHall_id(String hall_id) {
        this.hall_id = hall_id;
    }




    @Override
    public boolean equals(Object arg0)
    {
     //skipped