create query in Hibernate

Question

When we have to use

createQuery(String),   

createNamedQuery(String),  

createNativeQuery(String)   

in Hibernate and what is the difference between them?

Answer 1

1. CreateQuery: Used to create an HQL.

2. createNamedQuery: Used to define queries with name in mapping file or annotation. See this.

3. createNativeQuery: Used to execute native/pure SQL queries. Example

Answer 2

They differ in the meaning of the argument they are called with.

• createQuery takes an actual JP-QL query as argument.
• createNamedQuery takes the name of a query as argument, which is defined elsewhere, e.g. with a @javax.persistence.NamedQuery annotation.
• createNativeQuery is called with a SQL query.