| From | Sent On | Attachments |
|---|---|---|
| ChenZhiguo (JIRA) | Apr 15, 2008 1:20 am | |
| ChenZhiguo (JIRA) | Apr 23, 2008 12:11 am | |
| ChenZhiguo (JIRA) | Apr 23, 2008 12:41 am | |
| ChenZhiguo (JIRA) | Apr 23, 2008 12:43 am | |
| Sharif Uddin (JIRA) | Jul 15, 2008 5:30 am | |
| ChenZhiguo (JIRA) | Jul 15, 2008 7:59 pm | |
| Matt Raible (JIRA) | Jul 15, 2008 9:12 pm |
| Subject: | [appfuse-issues] [JIRA] Commented: (APF-1049) Hibernate returns repeat records when getAll | |
|---|---|---|
| From: | ChenZhiguo (JIRA) (iss...@appfuse.dev.java.net) | |
| Date: | Apr 23, 2008 12:41:02 am | |
| List: | net.java.dev.appfuse.issues | |
ChenZhiguo commented on APF-1049: ---------------------------------
If I use hql="from Salary", the hql will be:
select salary0_.id as id2_, salary0_.salary as salary2_, salary0_.userId as
userId2_ from Salary salary0_
select user0_.id as id0_1_, user0_.account_expired as account2_0_1_,
user0_.account_locked as account3_0_1_, user0_.address as address0_1_,
user0_.city as city0_1_, user0_.country as country0_1_, user0_.postal_code as
postal7_0_1_, user0_.province as province0_1_, user0_.credentials_expired as
credenti9_0_1_, user0_.email as email0_1_, user0_.account_enabled as
account11_0_1_, user0_.first_name as first12_0_1_, user0_.last_name as
last13_0_1_, user0_.password as password0_1_, user0_.password_hint as
password15_0_1_, user0_.phone_number as phone16_0_1_, user0_.username as
username0_1_, user0_.version as version0_1_, user0_.website as website0_1_,
roles1_.user_id as user1_3_, role2_.id as role2_3_, role2_.id as id1_0_,
role2_.description as descript2_1_0_, role2_.name as name1_0_ from app_user
user0_ left outer join user_role roles1_ on user0_.id=roles1_.user_id left outer
join role role2_ on roles1_.role_id=role2_.id where user0_.id=?
and so on.
Hibernate returns repeat records when getAll --------------------------------------------
Key: APF-1049 URL: http://issues.appfuse.org/browse/APF-1049 Project: AppFuse Issue Type: Bug Components: Persistence Layer Environment: windows,struts2,hibernate,mysql Reporter: ChenZhiguo Assignee: Matt Raible Attachments: test1.rar
I have a entity named salary.
salary is oneToOne user.
if a user has two roles,when I get all of salary,there will be one repeat
record.
if a user has three roles,when I get all of salary,there will be two repeat
records.
and so on.
attachment is my demo project.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.appfuse.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira





