Hi,
\n
\nRecently i had a use-case where we have the legacy database and it contains the corrupted references of a non existent record in many-to-one relationship, and i have to populate a grid that contain info also from referenced record. As referenced record doesn’t exist, So when we refer to the certain record will result in Hibernate throwing exception :[java]org.hibernate.ObjectNotFoundException[\/java] and not a single record loaded on grid.
\n
\nAs it is legacy database i am not sure what should be the correct value for the particular record.
\n
\nAfter few searches, i come accross a property in grails database mapping to handle such cases, let see how it work :
\n[java]
\nclass Task{
\n String name
\n ParentTask parent<\/p>\n
static mapping = {
\n parent ignoreNotFound: true
\n }
\n}<\/p>\n
class ParentTask{
\n String name
\n}
\n[\/java]
\nBasically, ignoreNotFound simply mapping hibernate not-found property.
\n
\nNote : A record loaded with ignoreNotFound: true will throw an exception during call of save() because of the missing reference.<\/strong>
\n
\nEither you can first update the invalid property or corrupted reference to the correct reference and then update other property that will solve your problem. It depend how you handle such scenario on your usecase.
\n
\nThanks,
\nTarun Pareek
\ntarun@intelligrape.com<\/p>\n