Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1.3

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:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


I have a many-to-many mapping in, the following example Employee, Employee-Department and Department,

I have some finders using HQL in the employee bean, when ever I invoke the finders, I could see in the console that Hibernate is deleting some entries from the Employee-Department table and inserting again.

Why is that Hibernate is executing delete and insert statements for a simple finder. Is there any settings which can stop this?

Thanks
Muthu

Could you be a bit more precise about your mapping and your issue ? Which code is in your finder ? How is it called ?

Sometimes, it's totally normal that Hibernate must delete all lines of a collection to only leave the good ones, because it's the only way to do so. But knowing if the behaviour is normal or not for your case requires more informations...