Tutorialspoint examples

Learn java tutorial with examples for beginners online

Hibernate native SQL

Native SQL refers to the real SQL for used database. Hibernate provides the facility to use native SQL. We can create a native SQL by createSQLQuery() method of Session interface.

Syntax of Hibernate native SQL which returns an object array:

Query query = session.createSQLQuery(“nativeSQL”);

Syntax of Hibernate native SQL which returns an entity:

Query query = session.createSQLQuery(“nativeSQL”).addEntity(entityName.class);



 * This class represents a persistent class for Student.
 * @author javawithease
public class Student {
	//data members
	private int studentId;
	private String firstName;
	private String lastName;
	private String className;
	private String rollNo;
	private int age;
	//no-argument constructor
	public Student(){
	//getter and setter methods
	public int getStudentId() {
		return studentId;
	public void setStudentId(int studentId) {
		this.studentId = studentId;
	public String getFirstName() {
		return firstName;
	public void setFirstName(String firstName) {
		this.firstName = firstName;
	public String getLastName() {
		return lastName;
	public void setLastName(String lastName) {
		this.lastName = lastName;
	public String getClassName() {
		return className;
	public void setClassName(String className) {
		this.className = className;
	public String getRollNo() {
		return rollNo;
	public void setRollNo(String rollNo) {
		this.rollNo = rollNo;
	public int getAge() {
		return age;
	public void setAge(int age) {
		this.age = age;


<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration SYSTEM
        <property name="dialect">
        <property name="connection.url">
        <property name="connection.username">
        <property name="connection.password">
        <property name="connection.driver_class">
        <property name="hbm2ddl.auto">
        <property name="show_sql">
        <mapping resource="student.hbm.xml"/>


<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-mapping SYSTEM
 <class name="com.javawithease.business.Student" table="Student">
  <id name="studentId" type="int" column="Student_Id">
	<generator class="native"></generator>
  <property name="firstName" column="First_Name" type="string"/>
  <property name="lastName" column="Last_Name" type="string"/>
  <property name="className" column="Class" type="string"/>
  <property name="rollNo" column="RollNo" type="string"/>
  <property name="age" column="Age" type="int"/>


import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
 * This is a utility class for getting the hibernate session object.
 * @author javawithease
public class HibernateUtil {
    private static final SessionFactory sessionFactory = 
    private static SessionFactory buildSessionFactory() {
    	SessionFactory sessionFactory = null;
        try {
        	//Create the configuration object.
        	Configuration configuration = new Configuration(); 
        	//Initialize the configuration object 
                //with the configuration file data
        	// Get the SessionFactory object from configuration.
        	sessionFactory = configuration.buildSessionFactory();
        catch (Exception e) {
        return sessionFactory;
    public static SessionFactory getSessionFactory() {
        return sessionFactory;


import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import com.javawithease.persistence.HibernateUtil;
 * This class is used for the hibernate operations.
 * @author javawithease
public class HibernateTest {
    public static void main(String args[]){
         //Create the student object.
         Student student = new Student();
        //Setting the object properties.
        student.setClassName("MCA final");
         //Get the session object.
         Session session = 
         //Start hibernate transaction.
        //Persist the student object.
        //Commit hibernate transaction.
        //select student records using native query
        Query query1 = session.createSQLQuery(
        "select * from Student where rollNo = :rollNo");
        query1.setString("rollNo", "MCA/07/15");
        List studentList1 = query1.list();
        //select student records using native query
        //with addEntity attribute
        Query query2 = session.createSQLQuery(
        "select * from Student where rollNo = :rollNo")
        query2.setString("rollNo", "MCA/07/15");
        List<Student> studentList2 = query2.list();        
        for(Student stu : studentList2){
            System.out.println("First Name: " 
                                    + stu.getFirstName()); 
            System.out.println("Last Name: " 
                                     + stu.getLastName()); 
            System.out.println("Class: " 
                                   + stu.getClassName()); 
            System.out.println("RollNo: " 
                                      + stu.getRollNo()); 
            System.out.println("Age: " + stu.getAge());     
        //Close hibernate transaction.


Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into Student (First_Name, Last_Name, Class, 
RollNo, Age, Student_Id) values (?, ?, ?, ?, ?, ?)
Hibernate: select student0_.Student_Id as Student1_0_, 
student0_.First_Name as First2_0_, student0_.Last_Name as 
Last3_0_, student0_.Class as Class0_, student0_.RollNo as 
RollNo0_, student0_.Age as Age0_ from Student 
student0_ where student0_.RollNo=?
First Name: Sunil
Last Name: Kunar
Class: MCA final
RollNo: MCA/07/15
Age: 27

Download this example.
Next Topic: Java Mail API tutorial with example.
Previous Topic: Hibernate named query using annotation with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.


Download tutorialspointexamples Android App
Copyright © 2018 Tutorialspoint examples DMCA.com Protection Status