Hi,

I have an entity A that is referenced by several entity types - lets say B, C and D. I want to enable or disable the delete operation for A if it is referenced by other entities. Is there a light-weight way to do it? I mean, is there a way to know the reference count for entity A without executing selects on all the entities that could reference it? I suppose that the database system(s) keep a reference count number for every foreign key relationship - if I can get this number somehow in Hibernate that will do the job...

Another question in the same line is how do I prevent constraint violation exceptions from being logged? Say if I entity A is referenced by entity B when the user tries to delete A, Hibernate will log a constraint violation exception. Is there a way to prevent it, without blocking other kinds of exceptions from being logged?

Thanks,
Yuri

I dont know if this is what you want

I meant the opposite - entity A is referenced by B, C etc., which means that you don't have A.getB(), you have B.getA().

I can have A.getBCount(), which is something like:

select count(b) from B b where b.a.id = :a_id

that returns the number of B's that reference A, but I was wondering if there is a way to check whether A is referenced by any entity (B, C, etc.) without making a select query for every entity.