1. Hibernate property based on sum stackoverflow.comI have figured out that I can use hibernate to get the sum of a number of entities using HQL as follows... |
2. HQL syntax to match properties against a set forum.hibernate.orgI have two tables in a many to many relationship. User and Form I'm trying to create something similar to this: Code: select * from users a, form_authors b where b.frm_id = '402882c5f7d7367100f7d736b3900002' and a.usr_id = b.usr_id and a.usr_id in ('id1','id5','id7','id31'); w/ the only exception being that I only need user data. I've tried: Code: "select form.authors from test.Form form, test.User ... |
3. Using property named "id" in HQL forum.hibernate.orgHow can I use property named "id" in HQL? Ve primary key name is not "id", but "uniqueId", so when I use query like "from MyObject o where o.id=value " Hibernate generates SQL code like " where tblname.uniqueId=value ". Is there any way to make Hibernate not to substitute primary key insted of id in HQL queries? I am using Hibernate ... |
4. hql special property id forum.hibernate.orgHi, I'm having some trouble with the special property 'id' in hql... My object also has a property 'id' so I can't use it in my hql queries :-( Is there a work around for it something like myObject['id']=:value ? When using myObject.id, it replaces id with the pk field of my table. Best regards |
5. HQL with property named id forum.hibernate.orgHello, What happens if I have a property named id and I do an HQL query specifying feature.id. Will it take the column that represents the primary key or will it take the column represented by the property named id? I know that id refers to the unique identifier of the object specified in my mapping file. How do you then ... |
6. accessing |