All yo hibernate Gurus,
Hi ,
I am lookinng into some performance tuning of a query .The scenario is i retrieve some ids iterating over a list and pass them to a query as parameter so there are as many queries as iterations .Can i have a list directly passed to a query as a parameter and return the List at once.
The code snippet is as under:
/* public Map findEmployeeCollection(int instCode) throws DaoException
{
log.warn("Entering method findEmployeeCollection");
Map map = new HashMap();
Ccs11119PensionData ccs11119PensionData;
List aList = null;
Iterator iterator = null;
List employeeList = null;
int iEmployeeId =0 ;
Employee employee = null;

try{

employeeList = pensiondata11119.findIEmpoyeeID(instCode);

for(int i =0;i<employeeList.size();i++)
{
ccs11119PensionData = (Ccs11119PensionData)employeeList.get(i);
iEmployeeId = Integer.parseInt(ccs11119PensionData.getId());

aList = session.createQuery(
"from Employee as employee where employee.iemployeeid =" +
iEmployeeId
).list();
iterator = aList.iterator();
iterator.hasNext();
employee = (Employee)iterator.next();
count++;
map.put(new Integer(iEmployeeId),employee);
}

}
catch(HibernateException hex)
{
log.warn("caught exception "+hex);
}
log.warn("Exiting method findEmployeeCollection");
return map;

}*/


Any help will be highly appreciated.
Thanks in anticipation,