Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.1.7

Mapping documents:
<list name="products" lazy="true" inverse="true" cascade="all-delete-orphan" table="RELEASE_PRODUCT"
<key column="RELEASE_ID"/>
<index column="ORDERING_NUMBER"/>
<one-to-many class="ReleaseProduct"/>
</list>

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

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I have a lazy loaded list that is loaded, size indicated 100 even though there is only 1 row in the returned list and SQL returns correctly 1 element when run independently.

Any comments, similar behavior would be helpful.

Thanks

Remove the table="RELEASE_PRODUCT" attribute from your list element. It's not needed, and might be causing problems.

Thanks for your response Steve. I think I figured out the issue, i am using a list which by definition is an ordered collection. My object has an ORDERING_NUMBER used as an index which has a value of 99 in the database. Hibernate creates a List (defined as an ArrayList) with 100 elements with my object being element 99. Hence 100 element collection.