HI ,
I have problem sessionFactory.getCurrentSession().createSQLQuery(
query).addEntity(PhysicalItemVerificationViewBean.class).list() ; it returns list but the list contains duplicated rows means same records multiple times . i have override equals and hashcode in bean class but still getting same records .if i use set instead of list some records are missing . Can anybody help me ASAP
Thanks in advance
Naresh Bahety

When you run your query outside of Hibernate, does it return records twice ? Maybe you miss a DISTINCT clause ?

No, actually when i run query in query browser it returns correct records but i run it through code it returns wrong values .please provide the solution .
thanks for reply.

Maybe you need to have a closer look to your implementation of equals()
hashCode().
If some record are missing it just means the corresponding objects were meaningfully equals for your Set.

no i have generated equals and hashcode through myeclise so there is no chance of mistake .
and this is my bean class

import java.util.Date;

public class PhysicalItemVerificationViewBean {

private Integer itemId;
private String itemName;
private String manufacturer;
private String location;
private String type;
private String batchNumber;
private Date expiryDate;
private Double sysqty;
private Double actualQuantity;

public Integer getItemId() {
return itemId;
}
public void setItemId(Integer itemId) {
this.itemId = itemId;
}
public String getItemName() {
return itemName;
}
public void setItemName(String itemName) {
this.itemName = itemName;
}
public String getManufacturer() {
return manufacturer;
}
public void setManufacturer(String manufacturer) {
this.manufacturer = manufacturer;
}
public String getLocation() {
return location;
}
public void setLocation(String location) {
this.location = location;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getBatchNumber() {
return batchNumber;
}
public void setBatchNumber(String batchNumber) {
this.batchNumber = batchNumber;
}
public Date getExpiryDate() {
return expiryDate;
}
public void setExpiryDate(Date expiryDate) {
this.expiryDate = expiryDate;
}
public Double getSysqty() {
return sysqty;
}
public void setSysqty(Double sysqty) {
this.sysqty = sysqty;
}
public Double getActualQuantity() {
return actualQuantity;
}
public void setActualQuantity(Double actualQuantity) {
this.actualQuantity = actualQuantity;
}

public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result
+ ((actualQuantity == null) ? 0 : actualQuantity.hashCode());
result = prime * result
+ ((batchNumber == null) ? 0 : batchNumber.hashCode());
result = prime * result
+ ((expiryDate == null) ? 0 : expiryDate.hashCode());
result = prime * result + ((itemId == null) ? 0 : itemId.hashCode());
result = prime * result
+ ((itemName == null) ? 0 : itemName.hashCode());
result = prime * result
+ ((location == null) ? 0 : location.hashCode());
result = prime * result
+ ((manufacturer == null) ? 0 : manufacturer.hashCode());
result = prime * result + ((sysqty == null) ? 0 : sysqty.hashCode());
result = prime * result + ((type == null) ? 0 : type.hashCode());
return result;
}

public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
final PhysicalItemVerificationViewBean other = (PhysicalItemVerificationViewBean) obj;
if (actualQuantity == null) {
if (other.actualQuantity != null)
return false;
} else if (!actualQuantity.equals(other.actualQuantity))
return false;
if (batchNumber == null) {
if (other.batchNumber != null)
return false;
} else if (!batchNumber.equals(other.batchNumber))
return false;
if (expiryDate == null) {
if (other.expiryDate != null)
return false;
} else if (!expiryDate.equals(other.expiryDate))
return false;
if (itemId == null) {
if (other.itemId != null)
return false;
} else if (!itemId.equals(other.itemId))
return false;
if (itemName == null) {
if (other.itemName != null)
return false;
} else if (!itemName.equals(other.itemName))
return false;
if (location == null) {
if (other.location != null)
return false;
} else if (!location.equals(other.location))
return false;
if (manufacturer == null) {
if (other.manufacturer != null)
return false;
} else if (!manufacturer.equals(other.manufacturer))
return false;
if (sysqty == null) {
if (other.sysqty != null)
return false;
} else if (!sysqty.equals(other.sysqty))
return false;
if (type == null) {
if (other.type != null)
return false;
} else if (!type.equals(other.type))
return false;
return true;
}





}

please provide the solution for these problem ASAP.

Can you provide the generated SQL?

the Sql is mentioned below my database is on postgress.

select * from physicalverificationview where LOWER(itemName)='crocin-tab-500mg';


Thanks.

Hi,

Problem is with either the hashCode method or hbm mapping file. In your hashCode method there should be only those fields which are either declare primary key or composite key in hbm file.

I was facing the same problem got resolved after doing the similar changes in hashCode & equals method and ofcourse the hbm file too.

thanks Dinesh for your reply.solution provided by you works .thanks