Skip to main content

JPA 2 new feature @ElementCollection explained

@ElementCollection is new annotation introduced in JPA 2.0, This will help us get rid of One-Many and Many-One shitty syntax.

Example 1: Stores list of Strings in an Entity

@Entity
public class Users implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    @ElementCollection
    private List<String> certifications = new ArrayList<String>();

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public List
<String> getCertifications() {
        return certifications;
    }

    public void setCertifications(List
<String> certifications) {
        this.certifications = certifications;
    }

..
}

        Users u = new Users();
        u.getCertifications().add("Sun Certified Java Programmer");
        em.persist(u);

Generated Tables

   Users
   Column --> ID
    Row             1

Users_CERTIFICATIONS
  Column  Users_ID      CERTIFICATIONS
  Row           1                 Sun Certified Java Programmer

 @ElementCollection rules
  1.    This annotation was introduced to map basic and embedded type objects
  2.    You can use any collection of type Collection, List, Set, Map
  3.    Its easy to override default values for generated Tables and Columns
  4.    JPA 1.0 only supported collection holding entity types using (@ManyToOne, @OneToMany) annotations
Lets quickly look at code snippet for Embedded object based collection


@Embeddable
public class Certification {

    @Column(name = "name")
    private String name;
    @Temporal(TemporalType.DATE)
    @Column(name = "issue_date")
    private Date issueDate;

    public Date getIssueDate() {
        return issueDate;
    }

    public void setIssueDate(Date issueDate) {
        this.issueDate = issueDate;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}


@Entity
public class Users implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    @ElementCollection
    @CollectionTable(name = "Certification", joinColumns = {@JoinColumn(name="user_id")})
    private List<Certification> certifications = new ArrayList<Certification>();

   
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public List
<Certification> getCertifications() {
        return certifications;
    }

    public void setCertifications(List
<Certification> certifications) {
        this.certifications = certifications;
    }
..

}


        Users u = new Users();
        Certification c = new Certification();
        c.setName("Sun Certified Java Programmer");
        c.setIssueDate(new Date());
        u.getCertifications().add(c);
        em.persist(u);

Resulted Table structure

Table --> Users
   Column --> ID
    Row             1

Table --> Users_Certification
  Column  user_id      name                                                   Issue_Date                         
  Row           1                 Sun Certified Java Programmer        2010-09-05

Map based Collection is a rich area it needs a seperate article to describe it some detail.

Comments

John said…
Nice article. Nice blog. It's bookmarked now :-) Well done and thanks for the clean and clear explanation.
Anonymous said…
Very Nice.
Thanks from Mumbai
Jin Kwon said…
Where is the entry for Map based collection?
Unknown said…
good explanation :)
www.shikaku.ru
VPS and Web hosting
Anonymous said…
Amazing... thanks for your service to help community. I just bookmarked...
Rags said…
Nice article. Are there any scenarios where use of onetomany or manytoone is still valid/required/preferred to elementcollection?
Rory said…
You sir, deserve a beer! This is a really good and clean explanation. Cheers!
Anonymous said…
and db query by elementcollection values?
Oo^sai^oO said…
Where Do we mention the tablename here for the collection? how does that happen?
Anonymous said…
explained nicely, formatted code would be more readable.
Anonymous said…
It is a very helpful information. Thank you for providing useful information.
Spring Training in Chennai | Spring Course in Chennai | Spring Hibernate Training in Chennai
Mounika said…
Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
python training in chennai
python course in chennai
python training in bangalore
Mounika said…
Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
python training in chennai
python course in chennai
python training in bangalore
service care said…
All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, keep on updates.
motorola service center near me
motorola mobile service centre in chennai
moto g service center in chennai
Joyal said…
Effective blog with a lot of information. I just Shared you the link below for Courses .They really provide good level of training and Placement,I just Had Node JS Classes in this institute , Just Check This Link You can get it more information about the Node JS course.


Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery
Anonymous said…
Hey guy's i have got something to share from my research work
Sickrage
Louiz
Foundation
radhika said…
Really it was an awesome article about JAVA, very interesting to read.You have provided an nice article,Thanks for sharing.

AWS training in Chennai

AWS Online Training in Chennai

AWS training in Bangalore

AWS training in Hyderabad

AWS training in Coimbatore

AWS training
Aishwariya said…
I read this article. I think You have put a lot of effort to create this article. I appreciate your work.
Thank you much more for sharing with us...!
Reactjs Training in Chennai |
Best Reactjs Training Institute in Chennai |
Reactjs course in Chennai

Popular posts from this blog

Validating CSV Files

What is CsvValidator ?   A Java framework which validates any CSV files something similar to XML validation using XSD. Why should I use this ?   You don't have to use this and in fact its easy to write something your own and also checkout its source code for reference. Why did I write this ?   Some of our projects integrate with third party application which exchanges information in CSV files so I thought of writing a generic validator which can be hooked in multiple projects or can be used by QA for integration testing. What is the license clause ?   GNU GPL v2 Are there any JUnit test cases for me checkout ?  Yes,  source How to integrate in my existing project ? Just add the Jar which can be downloaded from here  CsvValidator.jar  and you are good. Instantiate  CsvValidator c onstructor which takes these 3 arguements          // filename is the the file to be validated and here is a  sample         // list - defines all the fields in the above csv file ( a

Reuse JPA Entities as DTO

Note : Major design advantages of JPA Entities are they can detached and used across tiers and networks and later can by merged. Checkout this new way of querying entities in JPA 2.0 String ql = " SELECT new prepclass2.Employee (e.firstname, e.lastname) FROM Employee e "; List<Employee> dtos = em.createQuery(ql).getResultList(); The above query loads all Employee entities but with subset of data i.e. firstname, lastname. Employee entity looks like this. @Entity @Table(name="emp") public class Employee implements Serializable {     private static final long serialVersionUID = 1L;     @Id     @GeneratedValue(strategy = GenerationType.AUTO)     private Long id;     @Column     private String firstname;     @Column     private String lastname;     @Column     private String username;     @Column     private String street;     @Column     private String city;     @Column     private String state;     @Column     private String zipc