Book Image

Java Hibernate Cookbook

By : Yogesh Prajapati, Vishal Ranapariya
Book Image

Java Hibernate Cookbook

By: Yogesh Prajapati, Vishal Ranapariya

Overview of this book

This book will provide a useful hands-on guide to Hibernate to accomplish the development of a real-time Hibernate application. We will start with the basics of Hibernate, which include setting up Hibernate – the pre-requisites and multiple ways of configuring Hibernate using Java. We will then dive deep into the fundamentals of Hibernate such as SessionFactory, session, criteria, working with objects and criteria. This will help a developer have a better understanding of how Hibernate works and what needs to be done to run a Hibernate application. Moving on, we will learn how to work with annotations, associations and collections. In the final chapters, we will see explore querying, advanced Hibernate concepts and integration with other frameworks.
Table of Contents (15 chapters)
Java Hibernate Cookbook
About the Authors
About the Reviewers

Executing a native SQL query

We can directly use a hand-written core SQL query with hibernate. This is a useful feature if we want to execute a database-specific query that is not supported by the hibernate API, such as query hints or the CONNECT keyword in an Oracle database.

This is a useful feature when the developer has a ready native SQL. We can perform the Select, non-select, and Bulk operations as well.

How to do it…

We can use Session.createSQLQuery(String query) to execute a SQL query. We have multiple APIs available to execute the SQL query, and we will take a look at these in detail:

  • Scalar queries

  • Entity queries

Scalar queries

This is a basic type of query that returns a list of values (scalar).

For example, the following code shows how to select all the products from the product table:

SQLQuery sqlQuery = session.createSQLQuery("SELECT * FROM product");

List<Object[]> list = sqlQuery.list();
for(Object[] object : list){
  System.out.println("\nId: " + object[0]);