JPA Array Mapping

Question

How can I map an array of Doubles in JPA. I have the following code which fails because hibernate cannot initialise the array.

@Entity
public class YearlyTarget extends GenericModel {

    @Id
    public Integer  year;

    @ElementCollection
    public Double[] values;

    public YearlyTarget(int year) {
        this.year = year;
        this.values = new Double[12];
    }
}

DataNucleus · Accepted Answer · 2012-01-16 08:46:41Z

13

JPA does not mandate being able to persist arrays to a separate table; obviously JDO does but then you have chosen not to use that. Consequently you need to either store them as @Lob, or change your java type to a List.

answered Jan 16, 2012 at 8:46

DataNucleus

15.6k3 gold badges34 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Codemwnci · Accepted Answer · 2012-01-16 07:09:25Z

10

Use an Object type, such as ArrayList. Example

@ElementCollection
public ArrayList<Double> values;

public YearlyTarget(int year) {
    this.year = year;
    this.values = new ArrayList<Double>(12);
}

answered Jan 16, 2012 at 7:09

Codemwnci

55k10 gold badges101 silver badges130 bronze badges

5 Comments

emt14 Over a year ago

Do you mean that arrays cannot be mapped directly with jpa and a collection needs to be used instead?

tmbrggmn Over a year ago

@emt14 Plain arrays would be a real pain in the ass to work with, if you have a collection of values that changes frequently. This question tackles the same issue, with the same outcome: use a collection.

emt14 Over a year ago

Arrays are also the best storage option for a fixed length data type. No overhead compared to collections. Using the collection seems to be a workaround the fact that jpa does not persists arrays.

ewernli Over a year ago

@emt14 I suspect JPA implementations can no proxy arrays as easily as lists or other collections.

Adriaan Koster Over a year ago

@emt14 An ArrayList uses an array as underlying storage.There is not that much overhead when using an ArrayList instead of an array. Yes, resizing occurs but usually it does not have a huge performance impact (depends on the context of course). See also: stackoverflow.com/questions/716597/… The common opinion is that the benefits of using the List interface abstraction for readability and testability outweighs other concerns.

Tian Na · Accepted Answer · 2018-06-17 06:54:08Z

You don't specify the required database structure backing your mapping. @ElementCollection relies on a table that is joined up on retrieving the collection.

In Postgresql database for example you are able to store a simple array in within a column which is possible to map. You will need to in include a dependency:

<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-52</artifactId>
</dependency>

And your entity definition will look like:

@Entity
@Table(name = "products")
@TypeDefs(@TypeDef(name = "string-array", typeClass = StringArrayType.class))
public class Product {

    @Type(type = "string-array" )
    @Column(name = "colours")
    private String[] colours;

}

Currently the library only supports ints and strings, but it is a fairly simple task to add new types.

flobbe9 · Accepted Answer · 2022-08-19 16:32:25Z

0

To persist arrays you can use the @OrderColumnannotation together with@ElementCollection:

@ElementCollection
@OrderColumn
public Double[] values;

answered Aug 19, 2022 at 16:32

flobbe9

343 silver badges7 bronze badges

Collectives™ on Stack Overflow

JPA Array Mapping

4 Answers 4

Comments

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related