criteria
Count of the result of a Hibernate Criteria group by - total grouped records returned
I have a Criteria-based query with the following grouping: Projections.projectionList() .add(Property.forName(\"xy开发者_Go百科z\").group()));[详细]
2023-04-04 10:33 分类:问答Converting HQL 'in' restriction to Criteria
I have a query like this: Query query = session.createQuery(\"from table1 c where c.colummewhatever =:value and (select p.colummewhatever fr开发者_如何学编程om table2 p where c.fkidcolumme=p.idcolumm[详细]
2023-04-03 05:50 分类:问答Dynamic Query with AND, OR criteria
I am using Dynamic Query to get the result from my custom table. I want to execute Dynamic Query with \"AND\"(&&) as well as with \"or\"(||) criteria.[详细]
2023-04-02 13:37 分类:问答NullPointerException when using and/or in criteria
A very simplified example of how I use createCriteria method for getting data in my Grails application:[详细]
2023-04-01 11:45 分类:问答Fastest way of checking if one (or more) entries with given id is present in several tables
In my application DB, for a given Foo Object with a String id, there are seven tables, each one contains information about Foo Object, and each of the 7 tables has a field with the String id of the Fo[详细]
2023-04-01 01:59 分类:问答one-to-many: making Hibernate select the reference's id instead of joining it
I have two classes stored in my database using Hibernate. Let\'s call them Container and Item. Item has a one-to-many relation to Container:[详细]
2023-03-31 08:20 分类:问答question on Hibernate Criteria API
I have a two table A and B: A columns (ID,NameA,BiD) B columns (ID,NameB) ID is referenced to Bid as foreign RelationMapping.[详细]
2023-03-30 15:35 分类:问答Nhibernate Criterion - select rows in table A of TypeId defined in Table B
the title is confusing sorry, if you can think of a better one, please change it. I have three tables, say, bikes, owners and a relationship table (something like many to many) that defines all owner[详细]
2023-03-28 21:34 分类:问答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 分类:问答JPA Criteria join
I have two entity classes with many to one relation. I need to select all the p开发者_JAVA技巧arent records that has a child record with a min value smaller than provided.[详细]
2023-03-25 02:50 分类:问答