Re: Handling Large Resultset in Oracle

2008-10-06 Thread Armin Waibel
: Handling Large Resultset in Oracle Hi Paul, Somendra Paul wrote: Hi All, I am using OJB1.4 against Oracle10g with classes12.jar. We are trying to export data from the DB, using SQL query which returns 60 records , what we found out that is when we do iterator = query.getIteratorByQuery

Handling Large Resultset in Oracle

2008-09-21 Thread Somendra Paul
Hi All,    I am using OJB1.4 against Oracle10g with classes12.jar. We are trying to export data from the DB, using SQL query which returns 60 records , what we found out that is when we do iterator = query.getIteratorByQuery(),and iterate over the results,  we find that after iterating

Re: Handling Large Resultset in Oracle

2008-09-21 Thread Armin Waibel
Hi Paul, Somendra Paul wrote: Hi All, I am using OJB1.4 against Oracle10g with classes12.jar. We are trying to export data from the DB, using SQL query which returns 60 records , what we found out that is when we do iterator = query.getIteratorByQuery(),and iterate over the results, we

Re: Handling Large Resultset in Oracle

2008-09-21 Thread Somendra Paul
-user@db.apache.org Sent: Sunday, September 21, 2008 9:05:06 PM Subject: Re: Handling Large Resultset in Oracle Hi Paul, Somendra Paul wrote: Hi All, I am using OJB1.4 against Oracle10g with classes12.jar. We are trying to export data from the DB, using SQL query which returns 60 records , what