How do you retrieve a row with a unique null key in grails?

Question

In our grails application we have a database table with a composite unique key(i.e: one of the columns in the key can be nullable therefore null is a unique value).

My problem is any time we try to retrieve a row where this column has null in it, hibernate returns us a null object. Does anyone know how to get the object when one of the keys are null? Also it returns all of the rows that do not contain the null just fine.

Answer 1

Try to add another column that you can use as alternate key. then use another value for this for null values. that way you dont have to deal with nulls