BE THE CODER > Hibernate > Native SQL

The following example shows how to execute native SQLs. It returns a List of Object arrays (Object[]) with scalar values for specified columns in the query. Hibernate uses ResultSetMetadata to determine the type of the returned scalar values. Refer first example for the configuration and mapping.

File Name :	com/bethecoder/tutorials/hibernate/basic/native_queries/ScalarQueryTest2.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.hibernate.basic.native_queries;



import java.util.Arrays;

import java.util.List;



import org.hibernate.Query;

import org.hibernate.Session;



import com.bethecoder.tutorials.hibernate.basic.util.HibernateUtil;



public class ScalarQueryTest2 {



  /**

   * @param args

   */

  public static void main(String[] args) {



    Session session = HibernateUtil.getSessionFactory().openSession();

    session.beginTransaction();

    

    Query query = session.createSQLQuery("SELECT id, name, empcnt FROM company");

    List<?> rows = query.list();    

    System.out.println("Selected row count : " + rows.size());

    

    for (Object row : rows) {

      System.out.println(Arrays.toString((Object[])row));

    }

    

    session.getTransaction().commit();

    session.close();

  }

  

}

Scalar Query2