Isn't that a different thing?
Yes in JDBC you can determine the number of rows processed, like ADO. I did
not think ADO had the ultimate result set size (which it would have to
translate to select count(col), or process all the rows) which would be very
poor in performance for the average case. The RowSet returned can be set to
provide backward scrolling or not, as well as other features (in JDBC2 ext)
such as disconnected and other features you'd be familiar with from support
classes in ADO.
Thor HW
----- Original Message -----
From: "Neal Cabage" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 15, 2000 9:30 PM
Subject: Re: JDBC - recordcount
> You're suggesting to use the SQL aggregate function? I suppose this would
> work but it's ultimately a work-around. Does this mean there is no
*direct*
> support for such information in JDBC?
>
> Also, is there control for setting the cursor Type for the recordset (eg
> forwardOnly,dynamic, etc.)?
>
> Thanks.
> Neal
>
>
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of ramadevi
> Sent: Wednesday, August 16, 2000 2:44 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [JSP-INTEREST] JDBC - recordcount
>
>
> use count * method of sql
>
> Neal Cabage wrote:
>
> > Does anyone know how to return a recordCount when using JDBC? For
> instnace,
> > in ADO (Microsoft world) recordCount is simply a property of the
recordSet
> > object. Is there something that provides a similar functionality? I
need
> > that value *prior* to moving through the records so simply incrementing
a
> > value is not an option.
> >
> > Also, can anyone recommend a driver (and/or method) for accessing a
> > Microsoft DB such as SQL server, that does not require the JDBC:ODBC
> bridge?
> >
> > Thanks.
> > Neal
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
