Hibernate SQL Query/Native Query

This tutorial describes Hibernate SQL Query, which is also known as Native Query.

Hibernate SQL Query/Native Query

Hibernate SQL Query/Native Query

This tutorial describes Hibernate SQL Query, which is also known as Native Query.

Hibernate SQL native Query:

Hibernate facilitates to use SQL queries in your application. It is called native queries in Hibernate.
It is written like normal query and provide database specific features.
For native query you can use createSQLQuery() method on the Session interface.

public SQLQuery createSQLQuery(String sqlString) throws HibernateException

Hibernate Native Query Example :

Now we are going to describe a simple select native query example. Let employee is our table and we are selecting all  emp id ,name and salary.

package net.roseindia.main;

import net.roseindia.util.HibernateUtil;
import java.util.*;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class HibernateNativeSQL {
public static void main(String[] args) {
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();
String sql = "Select * FROM employee";
Query query = session.createSQLQuery(sql);

List<Object> objectList = query.list();
Iterator iterator = objectList.iterator();
System.out.println("Emp Id\t Name\tSalary");
while(iterator.hasNext()){ 
Object []obj = (Object[])iterator.next();
System.out.print(obj[0]);
System.out.print("\t"+obj[1]);
System.out.print("\t"+obj[2]);
System.out.println();
}
}
}

Output:

Hibernate: Select * FROM employee
Emp Id  Name  Salary
1       Mandy 20000
2       Som   20000
3       Mac   15000
4       Roxi  220000
14      Rowdy 20000

Download complete source code