Re: VMS x86-64 database server

On 7/10/2025 7:54 PM, Lawrence D'Oliveiro wrote:

On Thu, 10 Jul 2025 19:14:13 -0400, Arne Vajhøj wrote:

Even ORM's tend to embed a language. Either SQL or something ORM
specific: EJBQL, HQL, JPQL, JDOQL, JDQL, DQL etc..

 ORMs are a waste of time. I’ve seen how they deal with complex queries --
it’s just re-expressing the complexity of SQL in another equally complex
form.

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.
No magic. But the ORM framework handle sending query, reading data
and stuffing data into object structure. All the trivial stuff that
just makes the code take longer to read without providing any value.
Arne