Hibernate version: 3.0

I am using Hibernate 3.0 Spring. I have a simple Java bean as follows:

Product.java
-----------------------------------
public class Product {

private int id;
private String name;

//getters and setters follow
...

}


The mapping document looks like this:

Product.hbm.xml
------------------------------------
<hibernate-mapping>

<class name="Product" table="PRODUCT">
<id name="id" column="PROD_ID">
<generator class="native"/>
</id>
<property name="name" column="PROD_NAME"/>
</class>

</hibernate-mapping>

From a Test class, when I try to delete a row as follows:

public class TestProductDao {

public void delete(int prodID) {
getHibernateTemplate().delete("from Product where id=" + prodID);
}

}

I get a error as follows:
org.springframework.orm.hibernate3.HibernateSystemException: Unknown entity: java.lang.String; nested exception is org.hibernate.MappingException: Unknown entity: java.lang.String
org.hibernate.MappingException: Unknown entity: java.lang.String
at org.hibernate.impl.SessionFactoryImpl.getEntityPersister
(SessionFactoryImpl.java:444)

This implementation, however, works fine with Hibernate 2.1 + Spring.

Any thoughts on this?
Thanks a lot,
-Vineet

How are you using Hibernate3 with Spring? Have they already added support for Hibernate3?

In Hibernate3, that delete method (the ability to delete entities based on the result of a query) has been deprecated. All these deprecated Session methods have been moved to the org.hibernate.classic.Session interface. Now org.hibernate.Session does still have a delete(Object) method, but it is obviously intended for deletion of a single entity. So when you call session.select("my query), Hibernate thinks you are trying to delete the string "my query".

The reason we deprecated delete(String query)? Because once it is better defined, we will be adding support for EJB3-style bulk delete operations, which is a better way to do this.

In the meantime, if you need this functionality, just do what Session.delete(String query) did itself internally:
1) perform the query, getting the list of matching entities;
2) iterate the list, calling session.delete(entity) for each entity in the list.

If I am not wrong, Spring has not yet officially supported Hiberbate 3. There is however a patch available which makes Spring compatible with Hbn 3.

Anyway, thanks a lot for the clarification Steve.