Share on Google+Share on Google+

Hibernate SQL Query/Native Query

This tutorial describes Hibernate SQL Query, which is also known as 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");
Object []obj = (Object[]);


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



Posted on: July 9, 2012 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: Hibernate SQL Query/Native Query  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image