jdbc trigger to check other tables

[towerz]

i am developing a hostel management software using java as a frontend and a derby database as a back endn in my software i can create multiple hostel tables and the user can enter records in these tables... however i need to create a jdbc trigger in each table before insert that checks if the record being entered on a current table exists on another table, can anybody help me do this please, its urgent

[JosAH]

It's all in the JavaDB Reference Documentation.

kind regards,

Jos

[towerz]

thanks so much for your prompt reply, however i seem to be tottaly stuck when it comes to creating the sql statement in the trigger body i have been skimming through the guide practically the whole night and derby doesnt seem to support "if exists". could u pliz point me in the right direction when it comes to creating the sql statement to perform the referential check?

[towerz]

i have also been trying to create the trigger i keep encountering sql exceptions when trying to use if and where clauses

(LOL!!! NICE JOKE)