Enterprise Java Development@TOPIC@

Part VI. Java Persistence API: Query Exercise

Creating Queries with JPA

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

2015-11-18 02:15 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
42. Exercise Data Model
42.1. Class Model
42.2. Database Schema
42.3. Object Instances
43. JPA Entity Exercise Setup
43.1. Setup Maven Project
44. Creating JPA Queries
44.1. Setup
44.2. Create/Execute Query
44.2.1. Multiple Results
44.2.2. Single Result
44.2.3. Single Result - NoResultException
44.2.4. Single Result - NonUniqueResultException
44.3. Query Parameters
44.4. Paging Query Results
44.5. Named Query
44.6. Value Queries
44.6.1. Retrieve Value
44.6.2. Retrieve Function Result Value
44.6.3. Retrieve Multiple Values
44.6.4. Encapsulate Row Values with ResultClass
44.7. Summary
45. SQL Queries
45.1. Setup
45.2. Create/Execute SQL Query
45.3. SQL Query Entity Result Mapping
45.4. SQL Result Set Mapping
45.5. Summary
46. Bulk Updates
46.1. Setup
46.2. Additional Setup
46.3. Using JPQL Bulk Update
46.4. Using Native SQL Bulk Update
46.5. Summary
47. Query Locks
47.1. Setup
47.2. Additional Setup
47.3. Using No Locks
47.4. Adding Lock Mode
47.5. Using Pessimistic Write Lock
47.6. Summary