Hibernate HQL delete with and

Question

Hibernate doesn't delete my row: ``` public boolean deleteVote(Login user, int pid){ Session session = getSession(); try{ String hql = "delete from Vote where uid= :uid AND pid= :pid"; Query query = session.createQuery(hql); System.out.println(user.getUid() + " and pid: " + pid); query.setString("uid", user.getUid()); query.setInteger("pid", pid); System.out.println(query.executeUpdate()); }catch(Exception e){ ``` Outprint: ``` uid: 123 and pid: 1 Hibernate: delete from votes where uid=? and pid=? 1 ``` The SQL Syntax is working when I'm trying directly in SQL. Direct SQL Syntax: ``` delete from votes where uid= '123' AND pid= 1 ``` Mapping: ``` ``` Table: ``` CREATE TABLE IF NOT EXISTS `votes` ( `vid` int(11) NOT…

Accepted Answer

You need to begin and commit a transaction.

```
Transaction transaction = session.beginTransaction();
try {
  // your code
  String hql = "delete from Vote where uid= :uid AND pid= :pid";
  Query query = session.createQuery(hql);
  System.out.println(user.getUid() + " and pid: " + pid);
  query.setString("uid", user.getUid());
  query.setInteger("pid", pid);
  System.out.println(query.executeUpdate());
  // your code end

transaction.commit();
} catch (Throwable t) {
  transaction.rollback();
  throw t;
}
```

It is also possible that you need to close the session before the changes will be visible in the database.

Hibernate HQL delete with and

Solution

Problem