Hi,

Tomcat3.2.3+JBoss2.4.1, SuSE7.2, jdk1.3.1, Postgresql.

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)




Any suggestions as to how I could implement this?

Cheers
Joe