Hi Guys,

If anyone can tell me how to prevent hibernate from retrieving rows which have invalid indetifiers. For example: I am working on a legacy DB and some old data within the database has tables which have foreign keys as " ".

I have mapped my hibernate objects with appropriate relationships so that Table A has a foreign key column to Table B. however the FK in Table A has a value of " ". So when hibernate loads object A it tries to find a row which is equal to " " in Table B: i.e so it can load the mapped object B.

because no row with the identifier exists of object B a hibernate exception is thrown

I want to know how to tell hibernate to not look for Object B if its identifier is " ". Because I have lots of old data the " " cannot be removed.

Thanks in advance


Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

not-found="ignore|exception" (13)

http://www.hibernate.org/hib_docs/v3/re ... -manytoone

Thanks for the reply, unfortuantely what I forgot to mention in my previous post is I am using HIbernat 2.1 and the attribute is not available there.

Is there something equivalent in 2.1?

Thanks