Hi Gavin
Iam facing a problem please help me out.
Iam using WSAD and DB2.Iam configuring my WSAD to use the DB2 datasource.Iam specifing the jndi name in my hibernate util file and using org.hibernate.dialect.DB2Dialect.
I have tried both using createQuery and createcriteria .I am getting the list of employees for a given departmentid which iam sending .I should get DepartmentListDTo which should have different DepartmentDTo with different employee ids.I.e i shud get 6 different DeoartmnetDTos for a given deptid .Iam getting the size of the list as fine.but the list contains the same dtos i.e 6 same departmentDtos.why is it so.I executed the generated sql in the DB2 query analyzer and supplied the dept id I got what i wanted in the query analyser.
Iam doing someting like this.

List depts = hibernatesession.createCriteria(DepartmentDTo.class)
.add(Expression.eq("deptid"deptID)
.list();
iam supplying deptID.The list size returns 6 which is fine .but when i loop through the list i get the same DTOs same values of employees.
i.e.
Iterator iter = depts.iterator()
while(iter.hasNext()){
DepartmentDTO dept =(DepartmentDTO) iter.next();
system.out.println("Employe name" +dept.getEmpName());
}

I get teh same values for the getEmpName().Please help me why is it happening.I tried using even createQuery but same result>but on sqlserver database it worked fine.Please help me out.Eagerly awaiting for ur response.
Thanking in advance

Read the FAQ!