I have a table that has a child table that has one field mapped with an UserType. Works fine if the child relationship has less than 10 rows. When the child has 10 or more rows, i get a SQL Exception "ORA-01002 Fetch out of sequence" in Hibernate's Loader class. After briefly looking at the Loader.java code, It seems that Loader.java doQuery method defines the field hydratedObjects as an ArrayList of 10 elements. Is this the root cause ? Is there any workaround to this problem ? Thanks.

After further testing, the problem is due to calling a stateless session bean from the UserType's nullSafeGet. This bean just retrieves data from a cached object and there is no database call anywhere. Anyone experiences the same issue ?
Thanks.