I am attempting to setup a finder method for a cmp bean. The finder is returning a remote reference but of course the code fails if the finder's generated sql returns more than a single record.
I really only want a single record - one with the lowest value of a certain column and if there are duplicates then any single record out of those duplicates will do. (as soon as I get the record I will be incrementing the counter - every time)
The jaws.xml entry looks like this:
findLeastHit where counter = (select min(u.counter) from mybean u)