atom feed7 messages in net.java.dev.appfuse.issues[appfuse-issues] [JIRA] Commented: (A...
FromSent OnAttachments
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

[
http://issues.appfuse.org/browse/APF-1049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12390
]

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.