I've Googled as much as I can on this, and am wondering whether anyone can throw any light on what typically causes the following exception, which seems to occur frequently, in varied cases:

net.sf.hibernate.HibernateException: Batch update row count wrong: 0

I just don't get the batch update thing, because one place this error is sporadically thrown is when executing a select (no update is involved). Specifically, it's thrown by the following line:

getHibernateTemplate().find("select p.keywords from testing.om.Product p where p.category.department.shop.id = ? and p.keywords is not null", shopId)

This is in a class which extends Spring's HibernateDaoSupport class.

Given as this seems a common error (for me anyway), I was hoping that somewhere it might be definitively explained.

Forgot to mention: Hibernate 2.1.8, Java 1.4.2, MySQL 4.1.1