@Entity
class Department {
....
}


@Entity
class Employee{

@ManyToOne
@NotFound(action=NotFoundAction.IGNORE)
public Department getDepartment()

}


Employee table refers to department table (foreign key).
When I tried to delete a department, I got an exception
"foreign key constraint violation"

I want Hibernate/database to ignore the constraints and delete the department. how?

How to tell Hibernate not to generate the foreign key constraints?
@NotFound(action=NotFoundAction.IGNORE) does not work for this purpose, only for reading, ignore when not found.


Thank you very much for your help.
Dave

First of all, are you sure you want to end up with a bunch of orphaned records (employees pointing to non-existent departments)? Forcing your application to ignore referential integrity will almost always come back to haunt you. Moreover, it's not hibernate, but the database that is complaining. You define foreign key constraints in your schema precisely for the purpose of preventing orphaned records. Therefore, the easiest way to get what you are asking is to remove your foreign key constraints.

Thanks for info.
How to tell Hibernate not to generate foreign key constraints for the specific associations?

I am sure it is what I need.
I do not want to remove these constraints manually from database everytime I deploy the application.

Thanks!