Dear all,
I am using QueryBySql, its working fine for all record selection but its
not working for DISTINCT, not even for specific column.Please help me, my project is
in tight schedule.Just have look on my code:
package com.mxic.tdsplus;
import java.util.*;
import com.mxic.tdsplus.leadscan.*;
import org.apache.ojb.broker.query.*;
import org.apache.ojb.broker.PersistenceBroker;
import org.apache.ojb.broker.PersistenceBrokerFactory;
public class TestQueryBySql
{
public TestQueryBySql() {
}
public static void main(String[] dhamu)
{
java.util.Iterator iter=null;
try
{
PersistenceBroker
broker=PersistenceBrokerFactory.defaultPersistenceBroker();//createPersistenceBroker("repository.xml");
QueryBySQL queryBySql=new QueryBySQL(LotSummaryForm.class,"SELECT DISTINCT(LOT_NO)
FROM LS_LOT_SUMMARY");
System.out.println("Query " +queryBySql.getSql());
Collection results = broker.getCollectionByQuery(queryBySql);
iter = results.iterator();
while(iter.hasNext())
{
LotSummaryForm lot_summary_form=(LotSummaryForm)iter.next();
System.out.println("Lot_NO = "+lot_summary_form.getLot_no());
}
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println(ex.getMessage());
}
}
}
Thanks in Advance
Dhamu
---------------------------------
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
