finder with single result

[triathlon98]

I have some finders which can only return one instance, but my database contains more than one record which matches the given criteria.

Now I would expect to have any one of these records as my result, but this does not happen, the system returns null, indicating that the record was not found.

Is this behaviour spec compliant?

If the spec doesn't specify this, I would be willing to try to fix this. Otherwise, I will have to look at finding a different solution.

Joachim

[triathlon98]

I have not found anything in the specs about the required behaviour when more than one result is found. Any objections to changing to return the first one found?

Joachim

[aloubyansky]

According to 10.5.6.1 Single-object finder, it should throw FinderException. Doesn't it happen? How can it return null if there are several rows matching the criteria?

[mkyaj]

Hi,

I think changing that finder return type to Collection and getting ur required entity from that collection in the code will the alternative for this.
(But it may be like loading unnecessary data :-( )

Murali.