In my system, no distinct foregin key exist in DB. User maybe insert corrupted record via my system. If it happens, system will crash when search these records. But there is many logic foregin key exist, include xxx.hbm.xml. So I check input data when user insert reocrds, I should select many parent tables for one record. System cannot accept the performance and system also have many enterance to insert records(It means I should change many functions to check foregin key).
So I need a simply way to ignore corrupted data when out-join search. Is it prossible now in h2?
|