Trying to filter a collection. I do get the initial collection of campusLocs below but I hang on the line that creats a new collection of uniqLocs. I dont get any exceptions or anything, jsut hang. Any help will be appreciated. BTW, the application architecture is struts/weblogic8/oracle9i.

session = SessionHelper.getSession();
logger.info("getCampusLocations: B4 findCollection " );
campusLocs = gateway.findCollection("HrRecruitSchedule");
logger.info("getCampusLocations: all locs size: " + campusLocs.size());

Collection uniqLocs = session.filter(campusLocs, "select distinct this.school");
logger.info("getCampusLocations: uniq locs size: " + uniqLocs.size());

Check the Hibernate log.
Did you implement correctly equals and hashcode

Yes. I do have the hashcode and equals defined and are listed below. On a side note, the primary key for the table (my hibernate classes/mapings refer to) is ID which is a sequence and this table has events that could happen at a campus lcoation. So as such you can have multiple schools in the table. I was trying to get to get unique/distinct schools from this table to populate my drop down by doing the filter on the original collection.

public boolean equals(Object other) {
if ( !(other instanceof HrRecruitSchedule) ) return false;
HrRecruitSchedule castOther = (HrRecruitSchedule) other;
return new EqualsBuilder()
.append(this.getId(), castOther.getId())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getId())
.toHashCode();
}

Try raising the log level and figure out where everything hangs. If necessary, you can allways attatch a debugger and step into the hibernate code.