I found this HQL query that I am trying to make sense of. The comment says the LEFT JOIN causes Hibernate to eagerly load the associated entities in the child table, and the DISTINCT modifier is neede
I have the following model: class A{ Map<String, Integer> tags } class B{ A a; } I need to find instances of B where its associated A has a certain key value in its tags map
The following (simplified) classes are mapped to the database via Hibernate: class SystemUser { Set<UserGroup> groups;
Hibernate internally uses PreparedStatements under 开发者_开发知识库JDBC when converting HQL to SQL. How are inline parameters within an HQL handled ?
I\'m implementing a \"QueryEngine\" design pattern for dynamic queries on with loose connection to a Query Language (Like LINQ).
I ha开发者_开发知识库ve 2 classes: class A { B b; public A() {} public A(B b) { setB(b); } ... } class B {
I\'m using NHibernate for a web application. I have a model like this: public class ProductViewModel {
I have a simple HQL SELECT query. When the columns are not null, I\'m able to retrieve the records. But if one of the columns are null, I don\'t get that record that has a null column.
What is the best/preferred way to select a (distinct) list of parent entities that has a child collection containing matches for ALL entries in a parameter list of children?
i want to achieve the following in HQL - select top n from table1 where开发者_运维技巧 table1.id IN (some select sub query)