Hibernate version:
2.1.6
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
MySQL 4
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Using

session.delete("from IdentificationImpl where search=?", search, Hibernate.entity(Search.class));

does not work.. in includes "search" instead of "Search_ID" (ie. property name instead of column name) in the generated SQL ("from Identification identifica0_ where (search=? )")

However, this works:

session.delete("from IdentificationImpl where Search_ID=?", search.getId(), Hibernate.INTEGER);

the search property on Identification is mapped as a many-to-one relationship over to the Search class..

As far as I can see, the first version should work too, since it's the natural way to write that code..

hooverphonique,

try this query:

from IdentificationImpl as impl where impl.search=?

(when asking questions, it might be handy to provide mapping files and some actual code as the big red message says)

Bart.

that actually made the difference, thx.. (no idea why i didnt think of that myself ;-)