Java Persistence API (JPA)

  1. JPQL Query Language
    1. JPQL Fundamentals
      1. Language Purpose and Design
        1. Syntax Overview
          1. Case Sensitivity Rules
            1. Entity-Based Querying
              1. Differences from SQL
              2. Query Structure
                1. SELECT Clause
                  1. Entity Selection
                    1. Field Projection
                      1. Constructor Expressions
                        1. Distinct Results
                        2. FROM Clause
                          1. Entity Identification
                            1. Alias Declaration
                              1. Multiple Entity Sources
                              2. WHERE Clause
                                1. Conditional Expressions
                                  1. Logical Operators
                                    1. Comparison Operators
                                      1. Pattern Matching
                                        1. Null Checking
                                          1. Collection Operations
                                        2. Joins in JPQL
                                          1. Inner Joins
                                            1. Left Outer Joins
                                              1. Fetch Joins
                                                1. Join Syntax Variations
                                                2. Aggregate Functions and Grouping
                                                  1. COUNT Function
                                                    1. SUM Function
                                                      1. AVG Function
                                                        1. MIN and MAX Functions
                                                          1. GROUP BY Clause
                                                            1. HAVING Clause
                                                            2. Ordering and Pagination
                                                              1. ORDER BY Clause
                                                                1. ASC and DESC Ordering
                                                                  1. Multiple Sort Criteria
                                                                  2. Query Execution
                                                                    1. Query Interface
                                                                      1. Named Queries
                                                                        1. NamedQuery Annotation
                                                                          1. NamedQueries Annotation
                                                                          2. Dynamic Queries
                                                                            1. Parameter Binding
                                                                              1. Positional Parameters
                                                                                1. Named Parameters
                                                                                2. Result Retrieval
                                                                                  1. Single Results
                                                                                    1. Result Lists
                                                                                      1. Exception Handling
                                                                                    2. Bulk Operations
                                                                                      1. UPDATE Queries
                                                                                        1. DELETE Queries
                                                                                          1. Bulk Operation Limitations

                                                                                        Previous

                                                                                        5. Entity Manager and Persistence Context

                                                                                        Go to top

                                                                                        Next

                                                                                        7. Criteria API