hql
Finding Null IDs with HQL
I\'m constructing a hql query that needs to return orders where the User\'s ID is null: IList<Order> rows = DataContext.LoadList<Order>([详细]
2023-03-31 14:11 分类:问答Hibernate How to add a column in a middle table
Here\'s the details. I have 2 entity tables with one to many relationship. First, Exam class has many Category class. Hibernate generates this tables[详细]
2023-03-31 10:29 分类:问答NHibernate collection size without loading the entire collection
:) I have the following classes: Dislike DislikedComment (Comment) MemberId (int) Comment Dislikes (List<Dislike>)[详细]
2023-03-30 05:54 分类:问答How to iterate over a nested list
Hi I have a hibernate query which is giving me a list with type List<List<integer>>. How can I iterate this? My hibernate query is:[详细]
2023-03-29 17:07 分类:问答HQL Querying, finding by string idea
Two questions. Is there a way for us to query by substring/contains method or like a search style query or even regular expression matching?[详细]
2023-03-29 00:17 分类:问答SQL statement, subquery count?
I\'ve got the following SQL tables Department name|employees| Employee name|gender|type|dead | |John|male|good|yes|[详细]
2023-03-28 17:51 分类:问答Any ways to have single select query instead of multiple select queries in Hibernate?
I am using Spring + Hibernate(HQL). I have a requirement where I need to fire select query multiple times as parameters are different each time.[详细]
2023-03-28 13:50 分类:问答How to select the size of a @OneToMany(mappedBy))collection using HQL
First some context and explanation: I have written the following HQL query: select size(childGroups), size(ipts), g.id, g.name, g.status from LogicalGroup g where g.isRoot=true group by g.id, g.name[详细]
2023-03-27 01:57 分类:问答Transformers for SQL to return non entity pojo class
hi i am trying to return non entity class of the resulting query using Transformers in hibernate. My pojo class is[详细]
2023-03-26 21:02 分类:问答named parameters in a subquery in hibernate
how can I pass a parameter to a subquery in hibernate? I am trying this but I get an exception that :currentDate does not exist as a named parameter in (...[query]...) even though the query clearly sh[详细]
2023-03-26 02:15 分类:问答