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: stackoverflow.com/questions/14219498/… , or just use a List... — guido
– guido, Commented Oct 28, 2013 at 13:04

Masudul · Accepted Answer · 2013-10-28 13:03:36Z

1

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

answered Oct 28, 2013 at 13:03

Masudul

22k5 gold badges45 silver badges60 bronze badges

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

7 Comments

Débora Over a year ago

thanks for reply. then can you let me know how about the column type should be ? What is the column type should be ?

Masudul Over a year ago

this may help you stackoverflow.com/questions/4332467/…

Masudul Over a year ago

You need mapping OneToMany or use @EllementCollection

Débora Over a year ago

I can't use annotations all hibernates are written as XML

Débora Over a year ago

or then can I use int[] (primitive type) ? if can any sample please ?

|

Ahmad Abdelghany · Accepted Answer · 2013-10-28 13:28:47Z

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, 2013 at 13:28

Ahmad Abdelghany

13.5k6 gold badges45 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to map Integer array in Hibernate in hbm.xml

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related