I hope it is the appropriate section, I have a problem with this code

Transaction transaction = session.beginTransaction();
Query query = session.createQuery("update database set floop= :ctrl1" +" where ctrl= :ctrl2 ").setMaxResults(2);
// query.setMaxResults(2);
query.setParameter("ctrl1",3);
query.setParameter("ctrl2", 5);

I ask through setMaxResults (2) to do the update only on the first two and he makes the update of all records as I do what is wrong?? thanks for any help

probably not ;-)





as it is written in the description, setMaxResults just limits the number of rows you retrieve with a "select" statement.

Thanks for the explanation, but how can I solve my problem