Joining a semi-related entity in JPQL
Ok … I have three entities: A, B, C A has no relation on either B or C. @Entity class A{ } B has an A but knows nothing about C @Entity class B { @ManyToOne @JoinColumn(name = “a_id&…
Tag: jpql
How to make a Jpql query work in Spring Jpa Repository with Optional return?
I am using Jpql queries in my JpaRepository. The problem is that every time I call a method with an optional return I get this error: java.lang.ClassCastException: class [Ljava.lang.Object; cannot be …
JPQL Query to select entity from one-to-one relationship where it’s relative has a field matching a certain condition
I have three entities: EntityA maps to table_a, EntityB maps to table_b, and Catalog maps to catalog. In the database, there’s a many-to-many table between table_b and catalog, b_catalog_xref. EntityB …
how to find the data by an attribute (name_techno) in jpql
I am developing an application that allows managing candidates in a company, for that I use spring-boot, in order to select the employees who master such a technology (Techno) I used a request JPQL. …
Spring Boot @Query: Order by named parameter
I like my REST-Api endpoint to be sortable by diffrent model attributes. I have googled a lot of solutions, but none of them fit to my requirements. What I like to have is something like the …
jpa jpql Query on OneToMany relation
i have two Entity objects object 1 @Entity MyInfo String key; String eMail; String status; @OneToMany(mappedBy=”myInfo”) private List myInfoRequests; object 2 @Entity …
Does Spring Data JPA have a naming convention for “member of”?
Spring Data JPA constructs a number of queries based on naming convention of the interface methods. Is there any naming convention to do a “MEMBER OF” query? I can get the following to work with JPQL:…
Generation query when the ManyToMany relationship is used by Spring Data Jpa project
I’ve the following entities mapping: @Entity @Table(name = “books”) public class Book implements Serializable { @ManyToMany @JoinTable(name=”books2categories”, [email protected](…
What’s the difference between the IN and MEMBER OF JPQL operators?
What’s the difference between the IN and MEMBER OF JPQL operators?