Java Hibernate Cookbook

Java Hibernate Cookbook

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.

Java Hibernate Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Setting Up Hibernate

Introduction

Getting the required libraries for hibernate

Creating a hibernate persistent class

Providing an XML-based hibernate mapping

Providing an annotation-based hibernate mapping

Providing a hibernate configuration using an XML file

Providing a hibernate configuration using the properties file

Configuring hibernate programmatically

Understanding the Fundamentals

Introduction

Building a SessionFactory

Creating a generic SessionFactory provider class

Opening a new session

Opening a stateless session

Saving an object to the database

Fetching an object from the database

Removing an object from the database

Updating an object

Creating a criteria

Restricting the results using a criteria

Pagination using a criteria

Sorting the results

Transforming a result

Using basic projection

Basic Annotations

Introduction

Declaring a class as an entity and creating a table in the database – @Entity and @Table

Creating a column in the table – @Column

Creating a primary key and composite primary key column – @Id and @IdClass

Creating an autogenerator column

Working with Collections

Working with Associations

Introduction

One-to-one mapping using foreign key association

One-to-one mapping using a common join table

One-to-one mapping using a common primary key

One-to-many mapping or many-to-one mapping

Many-to-many mapping

Querying

Introduction

Working with an alias

Performing aggregate operations

Executing a subquery using a criteria

Executing a native SQL query

Executing a query using HQL

Using formula in hibernate

Working with NamedQuery

Advanced Concepts

Introduction

Working with a first-level cache

Working with a second-level cache

Working with a query cache

Working with the table per class hierarchy strategy of inheritance

Working with the table per subclass strategy of inheritance

Working with the table per concrete class strategy of inheritance

Working with the versioning of objects

Maintaining the history of an object

Working with an interceptor

Working with batch processing

Integration with Other Frameworks

Introduction

Integration with Spring

Integration with Struts

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

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:

Code

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

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

Java Hibernate Cookbook

Java Hibernate Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Java Hibernate Cookbook

Executing a native SQL query

How to do it…

Scalar queries

Code