criteria
Create SqlProjection with alias of joined table
I have this situation: public class AnswerSet { public virtual IList<Answer> Answers {set; get;} }[详细]
2023-02-23 14:37 分类:问答hibernate inner select in from clause
I\'d like to know if it\'s possible to specify a select clause in a from clause something like select count(*) as Y, this_.NAME as A, sel2.C[详细]
2023-02-23 07:01 分类:问答Hibernate Query Not Projecting Correctly in One To Many
I am doing a query where I need to get a user back, that also has UserConnectors populated with it.My Query keeps bringing back two results instead of one for a single ID.It should be one result, but[详细]
2023-02-23 03:12 分类:问答Transform HQL into Criteria
I have a query in HQL which fully works. However, I\'d like to have it expressed in the Criteria form, which is easier to read and maintain.[详细]
2023-02-22 20:49 分类:问答When using setFetchMode in Hiberate criteria how do I set a restriction on the oneToMany table
I\'m struggling to create a Hibernate criteria query that uses setFetchMode(... SELECT) and places a restriction on the returned child records. If I use a creteAlias as recommended it produces an inne[详细]
2023-02-22 08:22 分类:问答JPA: Invalid-Key Error when using the Criteria API
I always get the same error when using the criteria API: Local Exception Stack: Exception [EclipseLink-6075] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions[详细]
2023-02-22 02:31 分类:问答Hibernate empty string for an equality restriction for PostgreSQL 8.3 and Oracle 11g
Extending on How does hibernate use an empty string for an equality restriction? I am having a problem about how to check for an empty string between Oracle 11g and PostgreSQL[详细]
2023-02-21 14:20 分类:问答Hibernate select groupProperty , rowCount with rowCount > n?
Sorry if it is a dumb question but I\'ve stuck with this problem for a whole afternoon but cannot find a solution because I\'m not skilled with complicated SQL :[详细]
2023-02-19 23:46 分类:问答Yii condition <IS NULL>
How to find row by column with null value? It doesn\'t work: $criteria->condition = \'`se开发者_开发百科ller_id` IS NULL\';[详细]
2023-02-18 02:52 分类:问答How do I use a complex criteria inside a doctrine 2 entity's repository?
Lets say I have a table that holds information about festivals. Each festival has a start and end开发者_开发技巧 date.[详细]
2023-02-18 02:51 分类:问答