You cannot cat the next() elements of a reportquery iterator to entity classes !
> -----Urspr�ngliche Nachricht----- > Von: Dhamodharan P [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 6. Dezember 2002 11:49 > An: OJB Users List > Betreff: Re: AW: QueryBySql, please help me (URGENT) > > > > Hi Thomas, > I tried but facing the following error: > java.lang.ClassCastException: [Ljava.lang.Object; > at com.mxic.tdsplus.TestQueryBySql.main(TestQueryBySql.java:33) > [Ljava.lang.Object; > > I used following casting in my while loop: > > while(iter.hasNext()) > { > LotSummaryForm lot_summary_form=(LotSummaryForm)iter.next(); > System.out.println("Lot_NO = "+lot_summary_form.getLot_no()); > > } > > Regards > > Dhamu > > > Mahler Thomas <[EMAIL PROTECTED]> wrote:Hi, > > Use pb.getReportQueryIteratorByQuery for such queries. > > cheers, > Thomas > > > -----Urspr�ngliche Nachricht----- > > Von: Dhamodharan P [mailto:[EMAIL PROTECTED]] > > Gesendet: Freitag, 6. Dezember 2002 10:48 > > An: OJB Users List > > Betreff: QueryBySql, please help me (URGENT) > > > > > > > > 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();//c > reatePersistenceBroker("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 > > > > > -- > To unsubscribe, e-mail: > For additional commands, e-mail: > > > > > --------------------------------- > With Yahoo! Mail you can get a bigger mailbox -- choose a > size that fits your needs > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
