hi
u can do it with JDBC 2.0
With a 2.0 driver, you can use the setFetchSize() method within a Statement
or a ResultSet object
Statement stmt = con.createStatement();
stmt.setFetchSize(400);
ResultSet rs = stmt.executeQuery("select * from customers");
will change the default fetch size to 400.
regards
sumeet
> -----Original Message-----
> From: Mohamed [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 3:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: How can I get no.of records using Entity Bean.
>
> I think that you should the see the sentences in SQL not in the EJB. I
> Think
> that there is a call to the data base with return the nomber of rows in
> the
> table.
>
> Mohamed
>
>
>
> Abdul Salam wrote:
>
> > Hi guys,
> >
> > I am sorry, if i disturbed you by this mail.
> >
> > I am using Entity bean managed by container for
> > retrieving data from the datbase. I am getting the
> > individual records using finder methods. I want to
> > find the total no. of records, the finder method
> > returns.
> >
> > I know the simple way by going thru the Enumeration
> > value in a loop. But if thousands of records were
> > there then it will take much time. Is there any easier
> > way to find the number of records the finder method
> > return.
> >
> > I appreciate your help regarding this.
> >
> > Thanks.
> >
> > Abdul.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> >
> >
> ==========================================================================
> =
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff EJB-INTEREST". For general help, send email to
> > [EMAIL PROTECTED] and include in the body of the message "help".
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
