From: arne@vajhoej.dk   
      
   On 7/11/2025 7:43 PM, Arne Vajhøj wrote:   
   > On 7/11/2025 7:35 PM, Lawrence D'Oliveiro wrote:   
   >> On Thu, 10 Jul 2025 20:29:56 -0400, Arne Vajhøj wrote:   
   >> You can save a lot of code by using ORM.   
   >>>   
   >>> Example (Groovy and JPA):   
   >>>   
   >>> jpadata = em.createQuery("SELECT DISTINCT o FROM OrdersJPA AS o JOIN   
   >>> FETCH o.orderLines ol", OrdersJPA.class).getResultList()   
   >>>   
   >>> Gives you a list of order objects that each has a list of order lines   
   >>> objects.   
   >>   
   >> I thought the whole point of an ORM was to get away from having to hand-   
   >> construct SQL queries. And yet you have done exactly that.   
   >   
   > That is not SQL but HQL.   
   >   
   > :-)   
      
   Correction.   
      
   It is not HQL but JPQL.   
      
   The "SELECT ..." is identical in HQL and JPQL.   
      
   Both the API call and the naming of variable clearly indicates   
   that is JPA not Hibernate API.   
      
   I always test with Hibernate as JPA implementation, but standard   
   API!   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)