I'm using Spring with Hibernate, I'm having a table, USERS, and another table PROJECTS. Each line in table PROJECTS is introduced by a USER. If I try to delete the user I get a foreign key violation error. What I'm trying to do is to give the user a message saying that the user cannot be deleted because it is used. Should be ok to do a simple query to check if that user exists in PROJECTS but there are like 10 tables like PROJECTS and could appear more.

My question is: is there a convenient way to find if an user is used in another table so that I will not do a query for each table?

in constraint violation exception you have data about violated constraint - you have to explore this exception - it can depend from your database

No, the exception doesn't depend on the database, it's a Spring context. But the Spring exception was indeed the thing that helped me to solve the problem. ;)

i don't tell it depend from database - i tell - it can depend (maybe depend) - my english is bad

it is important that you resolve problem

Yes, I solved the problem. I defined a throws advice and to it I wired a regular expressions advisor for generalizing the solution for all domains. Now it works.