Map a list of strings with JPA/Hibernate annotations

Question

I want to do something like this:

    @Entity public class Bar {
        @Id @GeneratedValue long id;
        List<String> Foos
    }

and have the Foos persist in a table like this:

foo_bars (
    bar_id int, 
    foo varchar(64)
);

UPDATE:

I know how to map other entities, but it's overkill in many cases. It looks like what I'm suggesting isn't possible without creating yet another entity or ending up with everything in some blob column.

Answer 1

create an entity 'FooBars'

refactor the attribut 'Foos' to

@OneToMany List Foos

Answer 2

I'm think it's that what you need:

@Entity 
public class Bar {
    @Id @GeneratedValue long id;

    @OneToMany(mappedBy="bar")   //"bar" = field name in mapping class
    List<FooBar> Foos;
}

@Entity 
public class FooBar {
    @Id @GeneratedValue long id;

    @ManyToOne
    @JoinColumn(name="bar_Id")  
    Bar bar;
}

Answer 3

This is in Hibernate terms a "collection of values" or "elements". There is a (Hibernate specific) annotation for it. JPA does not support this (yet).

In short, annotate your collection like this:

@CollectionOfElements
@JoinTable(
        table=@Table(name="..."),
        joinColumns = @JoinColumn(name="...") // References parent
)
@Column(name="...value...", nullable=false)

This will create the necessary table with foreign keys and restrictions.

Answer 4

If you store your list as an array, it works:

setFoos(String[] foos);

you can transform it like this:

setFoos(myList.toArray(new String[myList.size()]));

Answer 5

I sometimes prefer persisting such collections as @Lobs (i.e. serializing them in the database)