can anybody help me create a jdbc trigger on a derby database that checks before a record is inserted into a table if it exists in another table, if it exists it raises an error and does not commit the transaction.. help will be apppriciated thanks guys