I am curious about something in Hibernate. I tried to search the forum for an answer, but among the 6 700 hits I found, I didn't find one related to this (not that I checked them all, of course).

When you call Session.delete() you need to pass an object that you wish to delete, i.e., you first need to retrieve the object from the database in order to delete it. This seems rather odd to me. In my application we often only have the primary key, e.g., "personId", and I would like to use this to delete the object. Do I need to write HQL code to make this happen, or am I missing something? In iBatis you pass the primary key, not the object, to the delete() method, and that seems more intuitive to me.

Kristoffer

Write a simple template or use classic.Session's method:


session.delete("from Foo where id = ?", new Integer(1), Hibernate.Integer);

Previous answer still involves object loading (under cover).

Use Query.executeUpdate() instead.

Query query = session.createQuery("from Foo where id = ?");
query.setInteger(0, 1);
int count = query.executeUpdate();

I wouldn't think this would create a load, since it should result in something like:



Of course, if the ID is compound this would be written slightly differently.

In H2 it definitely creates a load (see source).
But in H3 when using Query.executeUpdate() it doesn't.