So I am trying to replace the following native SQL with JPA Criteria Api: or The entities look a bit like this: I implemented a org.springframework.data.jpa.domain.Specification I can use together with a JpaSpecificationExecutor like: and But I only get one side of the join/select like: when I do: How do I ad…
Tag: hibernate-criteria
How can I build a predicate filtering to where ALL tags in an array exist, joined to a record, using criteriaBuilder?
Here’s an example of the syntax I’m using for another condition (where ANY of the tags appear on the document via a FK). predicates.add(root.join(Document_.tags).in({ pseudocode array of tags })); I’m trying to come up with a similar predicate, but where the Document entity has ALL of the ta…
Query on parent’s collection – Hibernate Specification
I have three tables created with Hibernate. Product is the parent while barcodes is a collection end price is a child (one to many) of products. I’m trying to query starting from the child (Price). I was able to query on a string but now i would like to query on the collection s element. how would you w…
How to join 3 table using hibernate criteria?
I have three tables. parent parent_child_mapping child I want to join the 3 tables & filter by child name using ‘CriteriaBuilder’ & ‘Predicate’. How can i implement the below sql query using ‘CriteriaBuilder’ & ‘Predicate’. Parent entity Parent child…
Java – JPA-Specification: how to create criteria/specification on a field that belongs to a nested object?
I am using jdk 1.8 , hibernate and jpa in my project. And using specification/criteria to build my search query. I have a class A ( an hibernate entity) which has class B as an attribute. So, roughly, it looks like : and… My repository class looks like (roughly): } Most of the simple JPA queries are wor…
Groovy createCriteria issue with joined table
I have a domain class Coach which has a has many relationship to another domain class CoachProperty. Hibernate/Grails is creating a third joined table in the database. In the example below I am trying to fetch the coaches which both have foo AND bar for their text value. I have tried different solutions with …
How to join two tables with a group query using Hibernate (5.4) Criteria?
This is my Project Entity: ( Project.java ) This is my Task Entity: ( Task.java ) Desired DTO: ( ProjectWithSumOfTaskDto.java ) Table structure in database: tasks: id title description project_id projects: id name description The main question: What I need now is to join the “projects” table and &…
Hibernate Criteria API join to another table only with id
I am trying to join from one table to another by using the Hibernate Criteria API. The problem is that table Contract has only salesId as defined as long (so no FK). Then I am not sure how to associate Contract with Sales. Better to explain in an example below. The schema is the following: In Contract entity …
Criteria Restriction by date field
I have 2 tables, Partner and Visit. A partner can have many visits, also various in same day. I need to create a Criteria restriction to know how many days the Partner has visits since a given date. So, 2 or more visits in same date must be only one. Can this be done only by Criteria and Restrictions?? I