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
