0

I am trying to fetch List from table FlexiBooking and then add this to another list i.e. to move to another table and delete those entries fetched from this table. I have used HibernateTemplate() object, since the project is being done using Spring Framework. But I am getting exception that trying to delete Detatched object. What is the problem? Below is my code:

    @Override
public void moveToNormalBooking(User user,
        int no_of_seats) {
    String queryString  = "FROM FlexiBooking";
    HibernateTemplate hibernateTemplate = getHibernateTemplate();
    hibernateTemplate.setMaxResults(no_of_seats);
    List<FlexiBooking> flexiBookingsTobeMoved = hibernateTemplate.find(queryString);
    List<FlightBooking> flightBookings = new ArrayList<FlightBooking>(); 
    int i =0; 
    while(i < flexiBookingsTobeMoved.size()) {
        FlightBooking flightbooking = new FlightBooking();
        flightbooking.setCostPerTicket(flexiBookingsTobeMoved.get(i).getTotalCost());
        flightbooking.setDateOfJourney(flexiBookingsTobeMoved.get(i).getScheduledFlight().getScheduledFlightDate());
        Booking booking = new Booking();
        booking.setBooker(flexiBookingsTobeMoved.get(i).getUser());
        booking.setBookingDate(flexiBookingsTobeMoved.get(i).getBookingDate());
        booking.setBookingReferenceNo(flexiBookingsTobeMoved.get(i).getBookingReferenceNumber());
        booking.setCancelled(false);
        flightbooking.setBooking(booking);
        flightbooking.setFlightRoute(flexiBookingsTobeMoved.get(i).getScheduledFlight());
        flightbooking.setCouponCode(flexiBookingsTobeMoved.get(i).getCouponCode());
        flightBookings.add(flightbooking);
        i++;
    }
    hibernateTemplate.saveOrUpdateAll(flightBookings);
 //   hibernateTemplate.update(flexiBookingsTobeMoved);
    hibernateTemplate.deleteAll(flexiBookingsTobeMoved);
}
BalusC
  • 1,082,665
  • 372
  • 3,610
  • 3,555
Babanna Duggani
  • 737
  • 2
  • 12
  • 34

0 Answers0