I have a table named "Store" which contains an attribute of type Set listOfItems.This attribute named "listItems" , is annotated with @ElementCollection(fetch= FetchType.EAGER) and @CollectionTable(name="items").
When i am executing projection on this table with the projection property including the attribute items, I am not getting this attribute with the projection.Instead i am getting the Oid of store table assigned as value to attribute listItems.
I captured the sql statement which is getting executed, in this join on the table "items" is not done .
i even tried manual join with crit.setFetchMode("items",FetchMode.JOIN) and captured the sql statements . Even in this the join on the Table is not
Let me know what i am missing .