Hi..

i'm trying use ScrollableResults with the following snippet of my mapping file :-

<composite-id>
<key-property name="workflow_id" length="40" >
<column name="workflow_id" sql-type="varchar(40)" not-
null="true"/>
</key-property>
<key-property name="version" >
<column name="version" sql-type="float" not-null="true"/>
</key-property>
</composite-id>

whenever i perform a query, (at the same time using ScrollableResults) on my table has more than 1 record with either 1 of the primary key having the same value, 1 of the following problem will occur:-

1. hit an ObjectNotFoundException
2. ScrollableResults will only be able to extract 1 row of record..

is there a way out? Please help...i'm clueless.. Thanks!!