OpenJPA: Multiple columns to List or Array

Question

I've got an legacy database with colums like that: value_1, value_2, value_3...

For a new project I want these columns to one list or an array

@Entity
public class Example {

   @????
   private List<String> values;
   or
   private String[];
}

How should i write the annotations make it work?

I tried it with an custom ValueHandler, but no success. I also can't find any example how to solve the problem or an good example for an custom ValueHandler

JB Nizet · Accepted Answer · 2013-08-15 12:02:58Z

1

@Column(name = "value_1")
private String value1;

@Column(name = "value_2")
private String value2;

public List<String> getValues() {
    return Arrays.asList(value1, value2);
}

answered Aug 15, 2013 at 12:02

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

2 Comments

Malte Over a year ago

Ok, so can I read the data as List. But if I change something in the List, the data will not send back to the database. Or I'm wrong?

JB Nizet Over a year ago

No, it won't. But you can add a setter to your entity and do the symmetric operation: value1 = list.get(0); value2 = list.get(1);.

Collectives™ on Stack Overflow

OpenJPA: Multiple columns to List or Array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related