List<String> with CollectionOfElements & EAGER

samuel.michelot · **Joined:** Wed Jul 04, 2007 6:29 am **Posts:** 11

Hi All,

I am trying to persiste an Entity (JPA with Hibernate) with a List<String>.
I can't use the OneToMany association because String is not an Entity.
So I use the @CollectionOfElements annotation, but it's not seen as a OneToMany assocation :
When I fetch the element, I have N instance of DataSet, where N is the number of element of listOfString

The entity:

Code:

@Entity
public class DataSet {
...
   @CollectionOfElements(fetch=FetchType.EAGER)
   @IndexColumn(name="listOfString")
   [b]private List<String> listOfString[/b];
..
}

The fetching code:

Code:

em.createQuery("SELECT d FROM DataSet d");

I read this post, saying that "HQL queries are not affected by the fetching strategy at all."
http://forum.hibernate.org/viewtopic.php?t=971700&highlight=onetomany+collectionofelements
But it's not my case, with EAGER, my list is loaded, but I have N instance of DataSet, where N is the number of element of listOfString

Can anyone help me please ?

Regards,
Samuel

LaLiLuna · **Posted:** Mon Oct 15, 2007 4:10 am

I do not understand how the query is related to your mapping.

samuel.michelot · **Joined:** Wed Jul 04, 2007 6:29 am **Posts:** 11

LaLiLuna wrote:

I do not understand how the query is related to your mapping.

Sorry, it's fixed now (I simplified my code for better comprehension)

LaLiLuna · **Posted:** Mon Oct 15, 2007 12:55 pm

If would be nice to share your solution.

samuel.michelot · **Joined:** Wed Jul 04, 2007 6:29 am **Posts:** 11

I am still looking for a solution, I corrected my previous post, but I don't have the solution of my problem....

samuel.michelot · **Joined:** Wed Jul 04, 2007 6:29 am **Posts:** 11

I need help please. I am still stuck with this problem. I tried a lot of configuration, but it's still not working :-(

samuel.michelot · **Joined:** Wed Jul 04, 2007 6:29 am **Posts:** 11

I found a solution. I added @Fetch(FetchMode.SUBSELECT) to fetch the list with another sql request :

@CollectionOfElements(fetch = FetchType.EAGER)
@IndexColumn(name = "listString")
@Fetch(FetchMode.SUBSELECT)
private List<String> listString;