Serializing List of POJOs using Hibernate

Question

I have a Java class that is mapped to a database table using JPA. Inside this class I have a List<Code> that I need to store in database.

So the Code class is not mapped into Hibernate. Is there a way to Serialize the List<Code> without mapping the Code class into Hibernate? Thanks in advance.

Error Message:

org.hibernate.exception.SQLGrammarException: could not insert collection [com.app.Account.codes#2]

Problem is that I'm getting error when Hibernate attempts to Serialize my List.

@Entity
@Table (name="account", catalog="database1")
public class Account{
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column (name = "id")
    private String id

    @Column (name = "type")
    private String type;

    @CollectionOfElements
    @Column (name = "codes")
    List<Code> codes;
    ...
    ...
}


public class Code implements Serializable{
//This is a basic POJO that is not mapped into Hibernate. I just want this object
//to be stored in database.
}

JB Nizet · Accepted Answer · 2011-11-28 22:05:26Z

3

You need to annotate the codes field with @Lob, not with @CollectionOfElements.

See http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#d0e6099 and the following paragraph.

This is a very fragile way of persisting a list of objects, though, because it uses binary serialization, which might quickly become non-backward compatible if the list or the Code class changes. It's also impossible to query or inspect using database tools.

I would rather map the Code class as an entity or as an embeddable.

answered Nov 28, 2011 at 22:05

JB Nizet

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

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

Collectives™ on Stack Overflow

Serializing List of POJOs using Hibernate

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related