Search code examples
javahibernatebooleanhql

How to update boolean in hql?


Here's my code:

public static boolean alterReservation(int reservationId) {
    try {
        Session session = getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();

        Query query = session
                        .createQuery("update Reservation  set realized = true where id= :reservationId");
        query.setParameter("reservationId", reservationId);
        transaction.commit();
        return true;
    } catch (Exception e) {
        e.printStackTrace();
        return false;
    }
}
update Reservation  set realized = true where id= :reservationId

Doesn't work I get no exceptions.


Solution

  • That is because you have not execute the query you should do:

    .....
      Query query = session.createQuery("update Reservation  set realized = true where id= :reservationId");
      query.setParameter("reservationId", reservationId);
      query.executeUpdate();  <<<<<<<<<<
    .....