Skip to main content

JPA Performance settings Explained

Lets consider this simple Entity, Ignore @SecondaryTables and other annotations if you are not familiar with just focus on @Basic, @OneToOne, @OneToMany annotations and get ready to answer these questions.

public class Employee implements Serializable {

    private static final long serialVersionUID = 1L;
    private Long id;
    @Column(name = "name")
    private String name;
    @Basic(fetch = FetchType.LAZY)
    @Column(name = "comments", table = "Employee_Comments")
    private String comments;
    private List tags = new ArrayList();

    private Address address;


What happens when we load the above entity using em.find or by executing some select query ?

  1.   "comments" is Eagerly loaded
  2.   "comments" is Lazily loaded
  3.   "address" is Eagerly loaded
  4.   "address is Lazily loaded
  5.   "tags" is Eagerly loaded
  6.   "tags" is Lazily loaded
You might have guessed 2, 4 and 6 or 1, 3, 6 though neither of these are correct.


@Basic(fetch = FetchType.LAZY)

 Are just "hints" to the JPA provider and its not mandatory for JPA provider to implement them, So their is no quarantee that these objects when loaded will be lazily loaded.

Conclusion : Entities heavily using above annotations and also if we load and them in bulk could seriously cause performance bottlenecks, however there are nice ways of loading entities with trim data using "Contructor" Queries. which will be topic of my next thread.

Reference JPA Specs.
JPA 2.0 Specification document Page 364

"FetchType fetch (Optional) Whether the value of the field or property
should be lazily loaded or must be eagerly fetched. The
EAGER strategy is a requirement on the persistence provider
runtime that the value must be eagerly fetched. The
LAZY strategy is a hint to the persistence provider runtime.

JPA 2.0 Specification document Page 402
Also have the same comment 

JPA 2.0 Specification document Page 400Also have the same comment 


Popular posts from this blog

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

public class Users implements Serializable {

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

    public Long getId() {
        return id;

    public void setId(Long 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");

Generated Tables

Column --> ID
    Row             1


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 ?

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 constructor 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 field has index, type, isOptional, rege…