Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Hibernate Hibernate SQL Query/Native Query


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


If you enjoyed this post then why not add us on Google+? Add us to your Circles

Liked it!  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.

Posted on: July 9, 2012

Related Tutorials

Discuss: Hibernate SQL Query/Native Query  

Post your Comment

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