8

I would like to know the difference between on these methods.

When use the createQuery()and find() methods of EntityManager ?

What the advantages about each of them ?

Thank you for answer me.

Andriel
  • 354
  • 2
  • 5
  • 20

2 Answers2

14

You use find when you want to look up an entity by primary key. That means you know exactly what you're looking for, you just want to pull it out of the database.

You use createQuery when you want to find entities using criteria or if you want to use a JPQL statement to define what you get back. So you would use the query when you want to get an entity or collection of entities matching some conditions.

Nathan Hughes
  • 94,330
  • 19
  • 181
  • 276
  • Thank you to reply. Then the advantages is the same for both. So depends what I'll search exactly. Nice post link's. :-) – Andriel Mar 29 '13 at 14:23
  • Correct me if I am wrong, but .find() hits 2nd level cache, whereas createQuery will not – Broccoli Dec 18 '20 at 12:13
  • 1
    @Broccoli: createQuery uses the query cache, see https://vladmihalcea.com/how-does-hibernate-query-cache-work/ – Nathan Hughes Dec 18 '20 at 13:17
11

The createQuery method allows you to create a JPQL statement that will be executed. The JPQL statement allowed is much more dynamic than the one executed by find. For example given the following table:

create table CAT(
   cat_id integer,
   cat_name varchar(40)
)

You could execute a query to find the cat by name.

entityManager.createQuery("select c from Cat c where c.name = :name");

The find method only allows you to retreive an object using its primary key. So to use the find method for the above table:

entityManager.find(Cat.class, new Integer(1));

In a nutshell, createQuery allows you to retrieve entities in a more dynamic fashion, while find limits you to searching for an entity with a known id.

Kevin Bowersox
  • 93,289
  • 19
  • 159
  • 189