I'm doing a simple call to myObject.getThings() and the resulting Set has only 954 items in it whereas it should contain 1600. If I run the query that is printed in the log I do get the 1600. Even adding distinct still gives 1600.

I tried stepping through the code and after the query runs and is processed in Loader.doQuery() the hydratedObjects and the returned results both contain 1600. But resluts is then thrown away so I don't know how it manages to assign the Set to myObject but when I get back to MyObject, the Set only has 954 items. What did I do wrong?

When I reduce the expected outcome to like 30 objects it works just fine.

Hibernate version:
3.0.5
Mapping documents:

<hibernate-mapping
>
<class
name="com.MyObject"
>

<id
name="id"
column="ID"
type="java.lang.Integer"
>
<generator class="sequence">
<param name="sequence">INTERNAL_ID_SEQ</param>
</generator>
</id>



<property
name="name"
type="java.lang.String"
update="true"
insert="true"
column="NAME"
length="100"
not-null="true"
/>

<set
name="things"
lazy="true"
inverse="true"
cascade="none"
sort="unsorted"
>

<key
column="MYOBJECT_ID"
>
</key>

<one-to-many
class="com.Thing"
/>

</set>

</class>

</hibernate-mapping>



<hibernate-mapping
>
<class
name="com.Thing"
>

<id
name="id"
column="ID"
type="java.lang.Integer"
>
<generator class="sequence">
<param name="sequence">INTERNAL_ID_SEQ</param>

</generator>
</id>



<property
name="name"
type="java.lang.String"
update="true"
insert="true"
column="NAME"
length="100"
not-null="true"
/>

<many-to-one
name="template"
class="com.MyObject"
cascade="none"
outer-join="auto"
update="true"
insert="true"
>
<column
name="MYOBJECT_ID"
/>
</many-to-one>
</class>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

MyObject temp = (MyObject)session.load(MyObject.class, Id);
Set things = temp.getThings();
Iterator iter = things.iterator();

at this point, I check the size of things in the debugger and see 954.


Name and version of the database you are using:
Oracle 10g

The log is too big to include.

Did you check value of hibernate.jdbc.fetch_size?

http://www.hibernate.org/hib_docs/v3/re ... ation.html

Actually you probably need to set hibernate.max_fetch_depth

That fetch_size should not have any effect on the total rows returned. If you read my post, the result set does return all the rows. It's just the Set associated with the MyObject that is missing rows.

fetch_depth is completely irrelevant as this is not using a join query. The set is lazy loaded and therefore loaded completely separate from the primary object.

I would verify that that the data in your database contains 1600 unique rows based on the equals() method of your Thing object.

Because these are being placed in a Set, duplicates aren't allowed and if your equals() method identifies two rows as equal, only one of them will end up in the set.

no luck. I ran: "select distinct name, user_number from Thing" and got the same record count - 1600.

Here's my equals...

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

In your mapping you do not load userNumber property.

How many records return "select distinct name from Thing" ?

It was a data problem. pksiv was right after all. I had supposably identical dbs confused but one had all the same values for userNumber. There were 954 distinct names in the db. (gotta put those constraints on the db).

Thanks!!!