How to map Integer array in Hibernate in hbm.xml

Question

I use prosgres sql and the table is like this.

CREATE TABLE invoice ( id INTEGER NOT NULL PRIMARY KEY, item_ids INTEGER[] NOT NULL, seller VARCHAR(10) NOT NULL );

Here I want to map the 'item_ids' array to the Integer array (Integer[]) in hbm.xml. This Integer array does not have any other references.Only an array Any sample code please.

well you can go this way: http://stackoverflow.com/questions/14219498/array-with-usertype-in-hibernate-and-postgresql-mappingexception , or just use a List... — guido, Oct 28 '13 at 13:04

score 1 · Answer 1 · answered Oct 28 '13 at 13:03

1

You can't map Integer array in Hibernate. Use List<Integer> using <list></list> tags.

answered Oct 28 '13 at 13:03

Masudul

21,823
5
43
58

thanks for reply. then can you let me know how about the column type should be ? What is the column type should be ? – Débora Oct 28 '13 at 13:05
this may help you http://stackoverflow.com/questions/4332467/mapping-array-with-hibernate – Masudul Oct 28 '13 at 13:05
You need mapping OneToMany or use @EllementCollection – Masudul Oct 28 '13 at 13:06
I can't use annotations all hibernates are written as XML – Débora Oct 28 '13 at 13:08
or then can I use int[] (primitive type) ? if can any sample please ? – Débora Oct 28 '13 at 13:16
No, you can't use int[] – Masudul Oct 28 '13 at 13:22
Most of examples on the internetr are about custome Objects savings as List.. Would you give sample how can map List of Integers to sql array please ? – Débora Oct 28 '13 at 13:33

score 0 · Answer 2 · answered Oct 28 '13 at 13:28

0

I think you need to modify your database structure to be as follows:

CREATE TABLE invoice ( id INTEGER NOT NULL PRIMARY KEY, seller VARCHAR(10) NOT NULL);

CREATE TABLE invoice_items ( invoice_id INTEGER NOT NULL, item_id INTEGER NOT NULL);

answered Oct 28 '13 at 13:28

Ahmad Abdelghany

11,983
5
41
36

How to map Integer array in Hibernate in hbm.xml

2 Answers2