I'd like to map my id to a column which is not unique. After having a look at the code of the load method of the EntityLoader.java I think Hibernate throws an exception if it detects, that there is more than one row returned for a query by id.
Is there a way to make Hibernate generating a select distinct, or just take the first row of the result set and ignore the others?

I do understand, that i could create a view, doing the distinct stuff, unfortunately, I'm not allowed to change the DB schema.

TIA
Ernst



Hibernate version:
2.1.6

Name and version of the database you are using:
Oracle 8/9, Sybase

You can use an HQL statement SELECT DISTINCT <object> from <object>

also in Hibernate3, you have the ability define <load> tags which may give you what you need.

Hi

Thanks for your help duggant. AFAIK Hibernate 3 will solve the problem, but I think it's not a good idea to use it in production in the next few weeks.

My scenario is, that the class with the non unique id is referenced by an other class and I'd like to make Hibernate resolving this reference without writing HQL.
If it would be only one reference, yes why not doing it via HQL and wait for Hibernate 3, unfortunately I've dozens of them.

TIA
Ernst