Share on Google+Share on Google+

CreateSQLQuery Hibernate

This section contain how CreateSQLQuery work in Hibernate.

CreateSQLQuery Hibernate

This section contain how CreateSQLQuery work in Hibernate.

CreateSQLQuery Hibernate :

By using CreateSQLQuery() method you can directly call native SQL statement.
Hibernate provides native SQL query concept to utilize database-specific features.

According to some people Hibernate generated query is slow and they prefer SQL.
Hibernate provide way to use Hibernate native SQL query by calling it by createSQLQuery() method.

Query query = session.createSQLQuery(sql);

Example : This example shows how to use native query. student is our table.

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 HibernateCreateSQLQuery {
public static void main(String[] args) {
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();
String sql = "Select * FROM employee WHERE name like 'M%'";
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 WHERE name like 'M%'
Emp Id   Name     Salary
1        Mandy    20000
3        Mac      15000

Click here to download complete source code



Posted on: July 28, 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: CreateSQLQuery Hibernate  

Post your Comment

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