The documentation for net.sf.hibernate.Session.delete() says that it will "Return the number of objects deleted." I am getting the following output:

count = 0
count = 1

after running the following:

s = sessionFactory.openSession();
//tx = s.beginTransaction();
System.out.println("count = " + count);
count = s.delete(hql);
System.out.println("count = " + count);
//tx.commit();

By commenting out the transaction lines, this code had no chance of deleting anything *from the database* . In what context do the dox use the word "delete"? Is this correct behavior?

The same context as it would in straight JDBC.



The ouput count will be > 0 (assuming there are records in SOME_TABLE), even though the transaction is explicitly rolled back and no data is altered. It would be pretty useless to have an updated count returned from executeUpdate() if you couldn't use it until after the end of the transaction.

Hibernate would, by extension, work the same way, telling you (to be precise) how many rows will be deleted if the transaction is successful.