jpql
set parameter which is null in @NamedQuery (JPA QL 1.0)
I am writing a JPA QL named query that would search for documents. This should be done in only one query and I cannot switch to native SQL (that\'s non functional requirement).[详细]
2023-03-09 19:54 分类:问答JPQL: Receiving a Collection in a Constructor Expression
I\'m using JPQL and want to receive some normal parameters and a collection in a Constructor Expression to directly create the DTO-objects. But if the Collection is empty, I always get a error because[详细]
2023-03-06 01:12 分类:问答JPA select new with aggregate function on member collection
I have a query like the following: Select new mypackage.MyClass( u, max(sc.serviceDate)) from Unit u left join u.serviceCalls sc[详细]
2023-03-05 18:43 分类:问答jpql INTERSECT without INTERSECT
i have four queries that return intergers. select listOfIntegers from [something]... (edit: the results are ROWS)[详细]
2023-03-04 14:19 分类:问答How to retrieve last "m" instances from a "1-n" relationship using JPQL?
Is there anyway to retrieve the last \"m\" in开发者_运维知识库stances from a 1 to n relationship using JPQL?[详细]
2023-03-04 12:44 分类:问答Ordering a join fetched collection in JPA using JPQL/HQL
Given the below JPQL statement, how do I modify it so that the kittens in the resulting list are ordered开发者_如何学编程 by their age property?[详细]
2023-03-04 12:29 分类:问答What's the difference between the IN and MEMBER OF JPQL operators?
What\'s the difference between the IN and MEMBER开发者_如何学JAVA OF JPQL operators?IN tests is value of single valued path expression (persistent attribute of your entity) in values you provided to q[详细]
2023-03-03 04:46 分类:问答Compare date only (without time) in JPA2 (JPQL)
Im trying to compare Calendars with JPA2. The query looks somewhat like that: TypedQuery<X> q = em.createQuery(\"select r from Record r where r.calendar= :calendar\", X.class);[详细]
2023-03-02 15:48 分类:问答Left join bringing 2 different objects
I could n开发者_StackOverflowot make a better title, if anyone can do it please, help me out! Same for tags.[详细]
2023-02-28 21:13 分类:问答JPQL: Problem with the following WHERE-Clause using Inheritance
I\'m using the following query, for getting all Fruits that are linked with the User. return (List<Fruit>) getEm()[详细]
2023-02-28 17:39 分类:问答