Hi there, not being able to find anything on this by searching, I wonder if anyone here could help me please.

I am using Hibernate to persist basic domain objects currently and have a couple of questions.

Firstly, is there any way to obtain how many results a session.update(Object) or a session.delete(Object) has affected. If I try and run these on an object already removed from the persistent store I get no error or indication that nothing was there.

Secondly, failing the first question, is there a good way to find out whether the object exists in the persistent store before I call these operations. As I will be using the same session, the documentation says I shouldn't try a session.load(Class, Serializable) to confirm existence, and indeed if I try this I get an exception on the following update saying "Another object was associated with this id (the object with the given id was already loaded)"

example code:

Object result = session.load(target.getClass(), target.getId());
session.update(target);


However the documentation says to use find(), which I am assuming is session.find(String). If I build up a query string manually and then use this however I get exactly the same error.

example:

List result = session.find(query);
if (result.size() > 0)
{
session.update(target);
}

Am I doing something monumentally dumb here and does anyone know what I need to write to do this?

Thanks for any help.

If you disable JDBC batch updates, Hibernate can check the returned rowcount. The lack of a rowcount is a problem with the JDBC batch update API.

This is exactly the same problem I'm having and I just can't seem to solve it. Did you? Anyone else have insight? I read the "Advanced Problems" FAQ about it but how else are you supposed to retrieve an object, make modifications to it and update the thing? I am using collections (and updating them), and I am opening the session just before the update() and closing it right afterward. I'm stumped!
Scott