object « HQL « JPA Q&A

1. New object with HQL stackoverflow.com

Trying to create an object from an HQL query, but just can't figure out what i'm doing wrong. Query:

String query = "SELECT product.code, SUM(product.price), COUNT(product.code)
from Product AS product
GROUP BY product.code"

(or should I ...

2. Problem while retrieving Object using HQL stackoverflow.com

I am new to hibernate and trying to learnits nuts and bolts.i have a table Destination which has destinationid as unique Key i also have UUID as unique key in the ...

3. Account Balance verification with Java and Hibernate HQL stackoverflow.com

I have following properties in my current Account Balance object:

long id;                     ...

4. HQL Object Named Parameters stackoverflow.com

I was wondering if it is possible to retrieve a specific column from an object named parameter in HQL. Example

public class Product
{
    private int id;
    private ...

5. HQL Object set from set stackoverflow.com

I got a Set<UserDTO> collection in a not Hibernate object, and I got a User domain entity in Hibernate. UserDTO contains less information about user (only id and name) How can I select ...

6. Retrieving coplex objects in HQL coderanch.com

7. Problem while retrieving Object using HQL coderanch.com

Hi All, I am new to hibernate and trying to learn its nuts and bolts.i have a table Destination which has destinationid as unique Key i also have UUID as unique key in the destination table. i want to provide a method by which user can fetch Destination based on destinationid also so i tried to use HQL as below Session ...

8. HQL creates partial object graphs. forum.hibernate.org

Let say that I have policies and policies have multiple addresses. I want to do a search an find all policies that have at one of the addresses in Iowa. My HQL would be from policy p left join fetch address a where a.state = 'IOWA' But that returns a policy with the address collection containing only the IOWA addresses. I ...

9. HQL for objects with at least one matching element in coll? forum.hibernate.org

10. HQL returning duplicate objects forum.hibernate.org

Newbie Joined: Fri Apr 16, 2004 11:48 am Posts: 18 Version: 2.1.3 I have ReferenceEntity and ReferenceObligation. A ReferenceEntity has many ReferenceObligations Code:

11. HQL or Object traversing????? forum.hibernate.org

12. hql on many-to-many returns multiples of the same object forum.hibernate.org

I have a fairly standard unidirectional many-to-many relationship between a user table and a role table. I am attempting to retrieve a specific user and the roles for that user. Any ideas why the following hql query would return me a collection of 4 of same OpUser object? Note that this particular user has four roles in the db. I tried ...

13. where to define actual typesafe Java object & let HQL kn forum.hibernate.org

Beginner Joined: Mon Sep 19, 2005 3:59 pm Posts: 31 Hi there, how can I define an actual typesafe Java object, and HQL can find it? Thanks for any help. Lamborghini Code: Query query = session .createQuery("select ...

14. HQL named parameters cant go deeper than 1 level in object? forum.hibernate.org

15126 [main] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors 15204 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker - select << begin [level=1, statement=select] 15251 [main] DEBUG org.hibernate.hql.ast.tree.FromElement - FromClause{level=1} : com.agensys.projectmanagement.model.ProjectMeeting (pm) -> projectmee0_ 15266 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode - Resolved : pm -> projectmee0_.meeting_id 15266 [main] DEBUG org.hibernate.hql.ast.tree.DotNode - getDataType() : title -> org.hibernate.type.StringType@1397e5c 15266 [main] DEBUG org.hibernate.hql.ast.tree.FromReferenceNode ...

15. HQL with related object forum.hibernate.org

16. Conditions on a Set / HQL / Object creation forum.hibernate.org

Hi, I have a few wonderings. First. Is it possible to set conditions on members of type set in a single query? Eg. I have a class Team that among others consists of a set of games and I want to fetch the Team, but the method getGames() should only return games that were played after a given date. class Team{ ...

17. Hibernate HQL returns same objects. forum.hibernate.org

For some reason when i run my createQuery from the Session object that is initialized, it returns the correct number of objects, but the objects are duplicated. It seems that hibernate pulls the first row it finds containing my first column value. Example: DB Table ROW_1 ROW_2 ROW_3 ROW_4 1234 abcd 10-08-2008 dev 1234 efgh 11-08-2008 dev 1234 ijkl 12-08-2008 dev ...