Hibernate: how to map java object on two columns automatically?

Question

Imagine I have one common functionality: series and number (string and integer) of some document. My object (insurance policy) contains information about series and number of different documents, so I would like to group this series and number into one java object and let hibernate store two fields on each object in the same table.

See the example:

    class Polis {
        private DocInfo kaskoNumber;
        private DocInfo osagoNumber;
        private DocInfo tsNumber;
    }
    class DocInfo {
        private String series;
        private Integer number;
    }
    table:
    polis(kaskoSeries varchar2, 
          kaskoNumber numeric, 
          osagoSeries varchar2, 
          osagoNumber numeric..... )

Something like this. What I really want to do - to get rid of duplication of fields in Polis object and incapsulate series and number fields in DocInfo object. This is ok for java, but as for Hibernate the only way I know - is to create ManyToOne relation and move this information to the other table (doc_info). But I need to keep all the information in one table!

Thanks.

axtavt · Accepted Answer · 2011-02-20 14:46:15Z

10

Use @Embeddable and @AttributeOverrides:

@Entity
class Polis {
    @AttributeOverrides( {
        @AttributeOverride(name="series", column = @Column(name="kaskoSeries") ),
        @AttributeOverride(name="number", column = @Column(name="kaskoNumber") )
    })
    private DocInfo kaskoNumber;

    @AttributeOverrides( {
        @AttributeOverride(name="series", column = @Column(name="osagoSeries") ),
        @AttributeOverride(name="number", column = @Column(name="osagoNumber") )
    })
    private DocInfo osagoNumber;
    ...
}

@Embeddable
class DocInfo {
    private String series;
    private Integer number;
}

See also:

5.1.5. Embedded objects (aka components) .

answered Feb 20, 2011 at 14:46

axtavt

243k42 gold badges518 silver badges486 bronze badges

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

1 Comment

bitec Over a year ago

Great help, thanks a lot! Annotations are a bit monsterous, but java class became more readable and convenient.

Willis Blackburn · Accepted Answer · 2011-02-20 14:42:39Z

0

You want a Hibernate "component"--which in JPA is called an "embeddable" object. The component/embeddable has the two fields, and your entity class just has one instance of the component/embeddable. The two columns live in the entity table along with the rest of the entity's fields.

answered Feb 20, 2011 at 14:42

Willis Blackburn

8,25422 silver badges40 bronze badges

1 Comment

Willis Blackburn Over a year ago

I should mention, you can have multiple instances of the same component/embeddable in a single entity class, each mapping to different columns. I've done this many times myself.

Collectives™ on Stack Overflow

Hibernate: how to map java object on two columns automatically?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related