Enterprise Java Development@TOPIC@

Part VI. Java Persistence API: Query Exercise

Creating Queries with JPA

Copyright © 2019 jim stafford (jim.stafford@jhu.edu)

2019-08-22 07:10 EST

Abstract

This document provides exercises to create JPA Queries using JPA Query Language, native SQL, and (future) the Criteria API.

Table of Contents

Purpose
41. Exercise Data Model
41.1. Class Model
41.2. Database Schema
41.3. Object Instances
42. JPA Entity Exercise Setup
42.1. Setup Maven Project
43. Creating JPA Queries
43.1. Setup
43.2. Create/Execute Query
43.2.1. Multiple Results
43.2.2. Single Result
43.2.3. Single Result - NoResultException
43.2.4. Single Result - NonUniqueResultException
43.3. Query Parameters
43.4. Paging Query Results
43.5. Named Query
43.6. Value Queries
43.6.1. Retrieve Value
43.6.2. Retrieve Function Result Value
43.6.3. Retrieve Multiple Values
43.6.4. Encapsulate Row Values with ResultClass
43.7. Summary
44. SQL Queries
44.1. Setup
44.2. Create/Execute SQL Query
44.3. SQL Query Entity Result Mapping
44.4. SQL Result Set Mapping
44.5. Summary
45. Bulk Updates
45.1. Setup
45.2. Additional Setup
45.3. Using JPQL Bulk Update
45.4. Using Native SQL Bulk Update
45.5. Summary
46. Query Locks
46.1. Setup
46.2. Additional Setup
46.3. Using No Locks
46.4. Adding Lock Mode
46.5. Using Pessimistic Write Lock
46.6. Summary