Enterprise Java Development@TOPIC@

Java Persistence API: Query Exercise

Creating Queries with JPA

Revision: v2013-08-19

2014-03-07 00:10 EST

Copyright © 2014 jim stafford (jcstaff@apl.jhu.edu)

Abstract

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

Purpose
1. Exercise Data Model
1.1. Class Model
1.2. Database Schema
1.3. Object Instances
2. JPA Entity Exercise Setup
2.1. Setup Maven Project
3. Creating JPA Queries
3.1. Setup
3.2. Create/Execute Query
3.2.1. Multiple Results
3.2.2. Single Result
3.2.3. Single Result - NoResultException
3.2.4. Single Result - NonUniqueResultException
3.3. Query Parameters
3.4. Paging Query Results
3.5. Named Query
3.6. Value Queries
3.6.1. Retrieve Value
3.6.2. Retrieve Function Result Value
3.6.3. Retrieve Multiple Values
3.6.4. Encapsulate Row Values with ResultClass
3.7. Summary
4. SQL Queries
4.1. Setup
4.2. Create/Execute SQL Query
4.3. SQL Query Entity Result Mapping
4.4. SQL Result Set Mapping
4.5. Summary
5. Bulk Updates
5.1. Setup
5.2. Additional Setup
5.3. Using JPQL Bulk Update
5.4. Using Native SQL Bulk Update
5.5. Summary
6. Query Locks
6.1. Setup
6.2. Additional Setup
6.3. Using No Locks
6.4. Adding Lock Mode
6.5. Using Pessimistic Write Lock
6.6. Summary