you are using a prior version of JDBC. Use JDBC2.0, it has all the methods
like recordcount, previous, first, last etc.
Tarun Dewan.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Neal Cabage
Sent: Wednesday, August 16, 2000 10:01 AM
To: [EMAIL PROTECTED]
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
