May 22, 2013

You are here: Home / Hibernate / Implementing composite primary key with JPA and Hibernate

Implementing composite primary key with JPA and Hibernate

January 13, 2011 14 Comments

Implementing composite key is different from the normal primary key , which I have explained in my previous post How to implement primary key with JPA and Hibernate .In this example we are going to learn how to create a compound primary key.

Here let’s take an example table  ACCOUNT with three attributes

[Emp_id]

[Account_id]

[Balance].

imagine a situation where we need a combination of Emp_id and Account_id to make up our prmary key.
For this , we will create a separate class with the attributes with which we want to create a compound key ie,  Emp_id and Account_id

import java.io.Serializable;

import javax.persistence.Embeddable;

@Embeddable

public class CompoundKey implements Serializable{

private String emp_id;

private String account_id;

public CompoundKey(String emp_id,String account_id) {

this.emp_id=emp_id;

this.account_id=account_id;

}

public String getAccount_id() {

return account_id;

}

public void setAccount_id(String account_id) {

this.account_id = account_id;

}

public String getEmp_id() {

return emp_id;

}

public void setEmp_id(String emp_id) {

this.emp_id = emp_id;

}

}

 

The above compound key class need special implementation

1)  The compound key class must implement serializable interface.

2)  Annotate the class with embeddable.

3)  All the getters and setters.

4) You can create the constructor, Which is not mandatory.

Now let’s create the  class for Object relational mapping. Instead of  getter/setter methods of the three data , we will create one object for the compound key class and the other attribute Balance.

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.Table

@Entity

@Table(name=”ACCOUNT”)

public class AccountVO  {

private CompoundKey compoundKey;

private int balance;

@Id

public CompoundKey getCompoundKey() {

return compoundKey;

}

public void setCompoundKey(CompoundKey compoundKey) {

this.compoundKey = compoundKey;

}

@Column(name=”Balance”)

public int getBalance() {

return balance;

}

public void setBalance(int balance) {

this.balance = balance;

}

}

 

Here you can notice that we have used  @Id – for creating id we have created the object of the class CompoundKey

Hibernate Client code

package compoundPrimarykey;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class testHibernate {
public static void main(String[] args) {

AnnotationConfiguration config=new AnnotationConfiguration();
config.addAnnotatedClass(AccountVO.class);
config.addAnnotatedClass(CompoundKey.class);
SessionFactory sessionFactory = config.configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx=session.beginTransaction();
CompoundKey compoundKey=new CompoundKey(“100848″,”100″);
AccountVO accountVO=new AccountVO();
accountVO.setCompoundKey(compoundKey);
accountVO.setBalance(100000);
session.save(accountVO);
Criteria crt=session.createCriteria(AccountVO.class);
List list=crt.list();
for (Iterator ite = list.iterator(); ite.hasNext();)
{
AccountVO accountVO2= (AccountVO) ite.next();
System.out.println(“Account  Balance  =”+accountVO2.getBalance());
CompoundKey compoundKey2=accountVO2.getCompoundKey();
System.out.println(“Emp id  =”+compoundKey2.getEmp_id());
System.out.println(“Account  id  =”+compoundKey2.getAccount_id());
}
tx.commit();
}
}

Related Posts

Filed Under: Hibernate

Comments

  1. Sumit says:
    February 10, 2011 at 5:21 pm

    Is this entity getting updated as well?
    Using a similar configuration, I am able to save into the database, but am unable to update it.

    Reply
    • bkrakesh says:
      February 10, 2011 at 6:17 pm

      You can do update also using the same way explained in the example . Please try this code

      String updateBalanceQuery=”update AccountVO accountvo set accountvo.balance=500 where accountvo.compoundKey.emp_id=:empID”;
      Query query=session.createQuery(updateBalanceQuery);
      query.setString(“empID”, “100848″);
      query.executeUpdate();

      Reply
  2. Kenya Nevarrez says:
    May 29, 2011 at 10:03 pm

    This is such a great resource that you are providing and you give it away for free. I enjoy seeing websites that understand the value of providing a prime resource for free. I truly loved reading your post. Thanks!

    Reply
  3. Chen Bo says:
    July 19, 2011 at 3:26 pm

    Thank you for the post. It works.

    However, I have a question about the annotation mapping.

    In class AccountVO balance field, we have annotation @Column(name=”Balance”) to clearly map balance to the corresponding table column. However, for the CompoundKey, we do not have similar annotations for the compound key fields. How does Hibernate know which column in the database table to map the key fields to?

    Thanks.

    Reply
  4. Ali says:
    February 6, 2012 at 3:02 pm

    Thanks dude!!!
    Great and Simple tutotial…

    Many Thanks,
    Ali

    Reply
  5. chandra says:
    March 13, 2012 at 9:30 am

    Great……i understood abt wt u have implemented but wt my question is how to implement auto increment for composite key.

    Thanks
    chandra

    Reply
  6. Mansoor says:
    March 25, 2012 at 8:18 pm

    Thanks

    Reply
  7. Sunil says:
    June 20, 2012 at 4:20 am

    what happens if you are creating the account or employee. the composite key wouldn’t have the account id available at that time, right? how does that work?

    Reply
  8. Best of Android says:
    August 7, 2012 at 5:55 pm

    Thank you very much for sharing this code. It helped me in solving the issue :)

    Reply
  9. Tomek says:
    November 28, 2012 at 2:54 pm

    Thank you, this helped. :)

    Reply
  10. Peter Sarazin says:
    December 28, 2012 at 3:51 am

    This got me 90% of the way in my application. My class attribute names do not match my database column names, so to make it fully work I just had to add @Column annotations to my equivalent of the emp_id and account_id attributes in the CompoundKey class implementation.

    Reply

Leave a Reply