Enterprise Java Development@TOPIC@

Part II. JPAQL

Table of Contents

3. JPA Query Language
3.1. Simple Entity Query
3.2. Non-Entity Queries
3.3. Multi-select Query
3.3.1. Multi-select Query with Object[]
3.3.2. Multi-select Query with Tuple
3.3.3. Multi-select Query with Constructor
3.4. Path Expressions
3.4.1. Single Element Path Expressions
3.4.2. Collection Element Path Expressions
3.5. Eager Fetching through JOINs
3.5.1. Lazy Fetch Problem
3.5.2. Adding Eager Fetch during Query
3.6. Distinct Results
3.7. Summary
4. JPAQL Where Clauses
4.1. Equality Test
4.2. Like Test
4.3. Formulas
4.4. Logic Operators
4.5. Equality Tests
4.6. Between
4.7. Testing for Null
4.8. Testing Empty Collection
4.9. Membership Test
4.10. Subqueries
4.11. All
4.12. Any
4.13. Summary
5. JPAQL Functions
5.1. String Functions
5.1.1. Base Query
5.1.2. LOWER
5.1.3. UPPER
5.1.4. TRIM
5.1.5. CONCAT
5.1.6. LENGTH
5.1.7. LOCATE
5.1.8. SUBSTRING
5.2. Date Functions
5.3. Order By
5.4. Aggregate Functions
5.4.1. COUNT
5.4.2. MIN/MAX
5.4.3. SUM/AVE
5.5. Group By
5.6. Having
5.7. Summary