Iam using Hibernate version 2.0 and would like to know how can i set fetch option at runtime.I dont want to use createCriteria as i will not be able to use projection.
my function looks like following
public ArrayList getActivatedAddendumFixedPricing(String addendumVersion,int startIndex,int numberOfResults,String mode)
throws HibernateException {
StringBuffer sb = new StringBuffer();
List objects = null;
ArrayList activatedAddendumFixedPrice = new ArrayList();
Query q =hibSession.createQuery("select fp,quote.quoteNo,quote.quoteVersion,qtr.quarter,qtr.year,qtr.quantity,fp.price,fp.currencyCd from ScheduleFixedPriceT fp,QuoteT quote,QtrFixedPriceT qtr where fp.status='A' and quote.fulfillmentType='I' and fp.addendumVersionT.version=:addendumVersion and quote.id=fp.quoteId and fp.fixedPriceId=qtr.fixedPriceT.id");
if(mode.equals("display")){
q.setFirstResult(startIndex);
q.setMaxResults(numberOfResults);
}
q.setInteger("addendumVersion",Integer.parseInt(addendumVersion));
objects=q.list();
Iterator iter=objects.iterator();
while (iter.hasNext())
{
activatedAddendumFixedPrice.add((Object[]) iter.next());
}
return activatedAddendumFixedPrice;
}
NOTE: I have set outer-join option as true.But I want to set fetch at runtime.
Thanks in advance
|