Storing a Map<String,String> using JPA
82,801
Solution 1
JPA 2.0 supports collections of primitives through the @ElementCollection
annotation that you can use in conjunction with the support of java.util.Map
collections.
Something like this should work:
@Entity
public class Example {
@Id long id;
// ....
@ElementCollection
@MapKeyColumn(name="name")
@Column(name="value")
@CollectionTable(name="example_attributes", joinColumns=@JoinColumn(name="example_id"))
Map<String, String> attributes = new HashMap<String, String>(); // maps from attribute name to value
}
See also (in the JPA 2.0 specification)
- 2.6 - Collections of Embeddable Classes and Basic Types
- 2.7 Map Collections
- 10.1.11 - ElementCollection Annotation
- 11.1.29 MapKeyColumn Annotation
Solution 2
@ElementCollection(fetch = FetchType.LAZY)
@CollectionTable(name = "raw_events_custom", joinColumns = @JoinColumn(name = "raw_event_id"))
@MapKeyColumn(name = "field_key", length = 50)
@Column(name = "field_val", length = 100)
@BatchSize(size = 20)
private Map<String, String> customValues = new HashMap<String, String>();
This is an example on how to set up a map with control over column and table names and field length.
Related videos on Youtube
Comments
-
corydoras almost 2 years
I am wondering if it is possible using annotations to persist the
attributes
map in the following class using JPA2public class Example { long id; // .... Map<String, String> attributes = new HashMap<String, String>(); // .... }
As we already have a pre existing production database, so ideally the values of
attributes
could map to the following existing table:create table example_attributes { example_id bigint, name varchar(100), value varchar(100));
-
L. Holanda about 10 yearsIs there a workaround to do this using JPA 1? I only found examples with
Map<String, SomeOtherClass>
-
James Bassett over 9 yearsMight be worth mentioning that
example_attributes
should have a composite key(example_id, name)
- which is what hbm2ddl will generate from the above. -
Kamila almost 8 yearsI tried above example, but when trying to persist an entity, I am getting an exception: You must define at least one mapping for this table. Query: InsertObjectQuery(null). Any hints? I create an empty entity and set properties map, then trying to persist.
-
Jon over 7 yearsUsing MariaDB, I ran into
Specified key was too long; max key length is 767 bytes
doing this. The primary key it tries to create is a combination of the varchar(255) and the @JoinColumn, which exceeds the default column size. You need to either change your database or modify your @MapKeyColumn to provide a length:@MapKeyColumn(name="name", length=100)
-
ktcl over 3 yearsfetch type should be EAGER
-
mr nooby noob over 2 yearsThis worked for me! Had to make sure that I my table was referencing my other table's PK.