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: criteria-api
How can I avoid null using lambda in this case?
The following method you have seen returns all the information of the user in the database according to the phone number as follows. However, when I perform an operation based on a phone number that is not in the database, it still returns the second part instead of this message. But I want it to look like th…
JPA Criteria builder for dynamic query
I have to write a method where I pass it some arguments and depending on which arguments are empty it modifies the query I need to execute at the end. E.g. if I want to select from a table Customer that has an ID, name, surname and address the starting query would be SELECT * FROM Customer WHERE ID=myId AND
What is the difference between CriteriaBuilder.createQuery and EntityManager.createQuery?
Let’s say I have the code, like: Can some please explain why we are using two createQuery() methods and what is the difference between them? Answer CriteriaBuilder#createQuery(Class<T> resultClass) creates CriteriaQuery<T> and EntityManager#createQuery(CriteriaQuery<T> criteriaQuery) c…
JPA Criteria multiselect with fetch
I have following model: Now I would like to query only columns: id, name, shortName and mentor which referes to User entity (not complete entity, because it has many other properties and I would like to have best performance). When I write query: I have following exception: Query before exception: I know that…
How to properly determine whether an “exists” JPA Criteria Query clause returned true or false?
I don’t know how to perform a JPA criteria query that returns with a boolean output. The goal is to have a criteria query that looks like this when rendered on Oracle: The where exists (…) part I performed with a subquery. I’m struggling with the external query. The practical use of this is …