EntityA has a @ManyToOne reference to EntityB.

Deleting a B causes a Integrity constraint violation unless I remove
any reference to it in any A's.

Is there any annotation magic that will let me delete B's
and have the A references automatically cleaned up?

Or must I load the A's and remove the association?

If the latter can you tell me the right HQL to load the right A's?
Something like "from EntityA as a where a.b='" + b.getId() + "'" ??

Thanks,
dbnb