jpql
Java - A JPQL Query to delete a oneToMany relationship
If I have this 3 entities : @Entity public class Student { @Id @GeneratedValue(strategy=GenerationType.IDENTITY)[详细]
2023-02-26 00:38 分类:问答JPQL: how to retrieve a List of data and set a value for each data in that list
So I have a entity Notification, that has a boolean attribute readStatus to determine of a notification has been read or not. When I click a button, I w开发者_Python百科ant to write a JPQL that retrie[详细]
2023-02-24 17:00 分类:问答java persistance query language limit resultset
Suppose I have following rows in a table \"mytable\" id 1 2 3 ... ... 500 and my query is like select m from mytable m where m.id < 300[详细]
2023-02-24 05:54 分类:问答What is wrong with this jpql query?(JPA)
Can you help me find the error in my JPQL query of the login method in my application please? // Login[详细]
2023-02-24 02:15 分类:问答jpql query manytomany
software <-m:n-> tag I want to create query for selecting all softwares where tag.id = id I write: TypedQuery query =[详细]
2023-02-22 23:11 分类:问答Please help converting this SQL to JPQL, problem with subquery (EclipseLink v2)
I have days trying to solve this. I need to have an ORDER BY and a LIMIT in a subquery, this is the native SQL:[详细]
2023-02-22 11:30 分类:问答How can get JPA to use an outer-join on a condition involving an associated entity?
I have two JPA entities: @Entity public class TaskSchedule { ... private String name; ... }开发者_JAVA百科[详细]
2023-02-22 03:15 分类:问答JPA passing parameter as Set
i want to pass a parameter in the jpql as set in an update statement. here is the statement: Query query = entityManager.createQuery(\"UPDATE Patient patient SET \"[详细]
2023-02-20 16:35 分类:问答How do I count the number of rows returned by subquery?
I want to do something like this: 开发者_高级运维select count(*) from (select ...) (As it would be in SQL), but in JPA.[详细]
2023-02-20 03:09 分类:问答Can I use group by in a subquery?
I want to do the following: select count(t) from Ticket t where t.id in (select st.id from Ticket st group by st.owner)[详细]
2023-02-19 07:59 分类:问答