How to map an integer array in JPA

Question

I use spring jpa with hibernate and postgres

In an entity, I tried to use a List and integer[]

In the database, I have a column of type:

integer[]

is there any jpa way to use it?

Mykola Yashchenko · Accepted Answer · 2017-09-08 12:30:46Z

12

JPA is not able to persist arrays to a separate table or database array (e.g. ones mapped to java.sql.Array) out of the box. So you have two ways:

1) Use @Lob to save this column as BLOB or CLOB

@Lob
private Integer[] values;

2) Use List<Integer> instead of an array

@ElementCollection
public List<Integer> values;

answered Sep 8, 2017 at 12:30

Mykola Yashchenko

5,3993 gold badges46 silver badges52 bronze badges

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

Comments

Grant Foster · Accepted Answer · 2018-10-12 18:15:25Z

1

Just doing this worked fine for me:

@Column(name="column_name")
private Integer[] columnName;

I didn't need @Lob like Mykola Yashchenko suggested.

answered Oct 12, 2018 at 18:15

Grant Foster

7582 gold badges11 silver badges22 bronze badges

Eric Aya · Accepted Answer · 2019-04-03 12:39:15Z

0

You can also write your custom generic array converter to resolve this issue.

Eric Aya

70.2k36 gold badges190 silver badges266 bronze badges

answered Apr 3, 2019 at 11:33

Amit Kumar

631 gold badge1 silver badge6 bronze badges

Always quote the most relevant part of an important link, in case the target site is unreachable or goes permanently offline.